AI and Agentic Automation

Hello everyone,   How to display the table format in appian using expression rules?  If anyone has the idea how to generate the table using html please help me . Thanks in advance. The finally format in pdf should be like this

here for the fist two filters i want to use it as "AND" operator filters and last two I want use as "OR" operator. Is there any way to do it inside the a!queryrecordtype function?

Hi, I have a string in DB which is: "<key>PROJECT_CODE</key><style>BOLD</style><color>#EF0010</color>" and I want your help to split this into different variables, like after splitting the above string  var1 will have value = PROJECT_CODE, var2 will have value = BOLD, var3 will have value = #EF0010 Thanks in advance!

Hi All, My scenario is to filter the below view column in appian expression rule using the two rule inputs of "date" dataype(startDate,EndDate), We can see in screenshot, the  column is of text and its in concatenated way, is it possible to filter this from appian? Could you please help me on this. Thanks in Advance.

if( isnull(ri!type), {}, a!forEach( items: a!queryEntity( entity: cons!POINTER_TO_DSE, query: a!query( filter: a!queryFilter( field: "type", operator: "=", value: ri!type ), pagingInfo: if( isnull(ri!pagingInfo), a!pagingInfo(1, - 1), ri!pagingInfo ) ), fetchTotalCount: true ), expression: if( ri!type = "Text", updatedictionary(fv!item, { textField: true }), if( ri!type = "Decimal", updatedictionary(fv!item, { decimal: true }), if( ri!type = "Date/time", updatedictionary(fv!item, { dateTimeField: true }), if( ri!type = "Integer", updatedictionary(fv!item, { integer: true }), if( ri!type = "Date", updatedictionary(fv!item, { date: true }), if( ri!type = "Boolean", updatedicti

Hi, How can I print the numbers between two numbers. Eg: Number 1 = 1, Number 2 = 5. Expected output 2,3,4 Kindly help. Thanks in Advance

a!localVariables( local!metadataJSON: if( a!isNotNullOrEmpty(ri!metadataJSON), a!fromJson(ri!metadataJSON), null ), local!result: a!forEach( items: local!metadataJSON, expression: a!localVariables( local!section: fv!item, a!forEach( items: local!section.questions, expression: a!localVariables( local!questionrow: fv!item.questionrow, a!forEach( items: local!questionrow, expression: if( fv!item.questiontitle = ri!targetField, updatedictionary(fv!item, { "responsetext": ri!value }), null ) ) ) ) ) ), local!metadataJSON ) I have a nested json. I need to update its field "responestext" if its questiontitle is equal to the parameter. Then return the new json. But the original variable metadataJSON is not updated. Is there an

i tried but i did not get exact output, any one try this .. a!localVariables( local!expression: "x+y-x*y", local!result: a!forEach( items: enumerate(len(local!expression)) + 1, expression: local!expression[fv!index] ), local!arryIndex: { x: wherecontains(touniformstring({ "x" }), local!result), y: wherecontains(touniformstring({ "y" }), local!result), }, local!etdata: a!update( data: local!result, index: { local!arryIndex.x, local!arryIndex.y }, value: { 10, 20 } ),local!etdata)

Hello, I am learning query entities and I am getting the warning message (missing domain prefix).  cons!UA_DSE_STUDENTSINFO is mapped to UA_Students DB. I believe it is configured properly because I use the same constant to write values to DB. I am getting the same warning message when I try to use sorting. 

I need an expression which finds corresponding value based on ranges: Input:x{v1,v2,...,vn+1}{r1,r2,...,rn} Result:if (x<=r1) then v1else if (x<=r2) then v2....else if (x<=rn) then vnelse vn+1 Thanks

Hi folks, I have a requirement like display the number of resignation cases per quarter and the data in grid format. Facing issues to fetch data by quarterly. Please help me on this, Thank you. 

I want to set up configure or flow to process multiple if conditions. If(condition= true and condition2=true), true, false) Takes a specific path if condition is true. Wanted to know if it was possible

While trying to check an empty map, a!isNullOrEmpty and a!isNotNullOrEmpty are not working, rather giving opposite result.  The result of a!isNullOrEmpty(a!map())should be true but the function is returning false. Not sure if this is a bug but something that might need the engineering team's attention. [mention:6b9f80ff18f9420082d13ef2d5121d56:e9ed411860ed4f2ba0265705b8793d05]

A,                                             1 BC,                                          2 DEF,                                        3 GHIJ,                                       4 KLMNO                                   5 ---------                                     -- A to Z                              &nbsp

Hi everyone, I've a task that say: Convert 12/12/21 to December 12, 2021 and he gives me this hint Hint: You need to use two Appian functions: text() and datevalue() this is the task on the image below. can anyone would help me to do this task.

I want to Create time slots for specific interval and get a List of all slots (like 20 min or 30 min slot) for Interval.

I have the following which i saved as a process variable of type text { "userId": "abc123", "submissionId": "111222333", "createdDt": "2022-06-17T04:07:19.611Z"} I want to remove spacing between the commas and colons, trying to do so with substitute(pv!text, ": ", ":") and substitute(pv!text, ", ", ","). It works for the colon, but not for the comma, so the result is the following { "userId":"abc123", "submissionId":"111222333", "createdDt":"2022-06-17T04:07:19.611Z"} Also, when i use stripwith(pv!text,","), the comma can be affected and removed. Wondering why substitute cant do the same. Any ideas as to why this is happening or how else I can remove the space between the comma?

I have a requirement where the client would like to be able to scan barcodes using a handheld scanning machine and have them save in the Appian UI. I have read the following documentation: https://docs.appian.com/suite/help/20.4/Retrieve_Data_By_Scanning_A_Barcode.html From the documentation, it seems that it is only possible to scan a barcode and show it on the Appian UI using a mobile device (smartphone). Is there any way to achieve the same functionality using a handheld scanner, either Bluetooth or USB?  The brand the client has is Symbol.  For example: www.amazon.com/.../B00HYOPAJG

instead of having text for a rule input which accept user names, is it possible to have a user type? 

hello! i have a question, well, i have a dropdown with some data, for example, in a dropdown i have states, what i want is that when i select a specific state, a list of cities appears in another dropdown, with my team we have done it with if, if nested, match, but we keep getting errors, regarding the interface, and with the definition, it even tells us that the values of the cities in the other dropdown are invalid, for your attention, thanks alot!   

I need to get a list of all objects separately of a application , the application contains around 3500 objects , any suggestion how can i get this 

Hi All, Assume like the user have entered the below start date and end date and also, they have selected some contracts and price groups based on the date logic. Start Date: 15th June 2022 End Date: 15th July 2022 Now I have a table like below with all the selected data, Contract number Price grp id Frequency xxx xxx-1 Monthly xxx xxx-2 Quarterly xxx xxx-3 Semi-Annually xxx xxx-4 Annually   My scenario is like I have to check the frequency from above table(cdt) and split it into multiple rows based on the date range (Start Date & End Date) and update in another table(cdt),please refer the resulting expectation, Case 1: Frequency: Monthly>>then 2 rows >>1st row: {Start Date: 1st Jun 2022 – 30th Jun 2022}>>2nd row: {Start Date: 1st Jul 2022 – 31st Jul 2022} Case 2: Frequency: Quarterly>>then 2 rows >>1st row: {Start Date: 1st Apr 2022 – 30th Jun 2022}>>2nd row: {Start Date: 1st Jul

Hi, I'm doing the activity of the course, but I got a problem with this query:  a!queryRecordType( recordType: 'recordType!{058be2d0-0acb-453f-93ac-4c9f650cf004}Vehicle', fields: a!aggregationFields( groupings: a!grouping( field: Vehicle.make, alias: "Vehiclemake" ), measures: a!measure( field: Vehicle.make , function: "COUNT", alias: "count" ) ), pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 100 )) .data when I tried to test the rule I got this error: Expression evaluation error at function a!aggregationFields [line 3]: Could not find variable 'Vehicle' I followed every single step in the exercise So, I don't understand what's the wrong here. Can anyone tell me what's the wrong??