Discussion Categories

HI Team,I have a nested cdt. for example {id:1, employee:nested_cdt, contact:1234567890, age:21, year:1}, based on age field I'm updating the employee, contact, year using 3 different foreach. So can I do this in a single foreach using update(), I tried but it resulting in 3 different cdt's instead of one. Can anyone help or provide a better solution with a sample code?Thanks in advance [mention:126a676c85024855948336691b0a7b92:e9ed411860ed4f2ba0265705b8793d05] 

We what to catch errors in a running process model, save the error in DB. We also want to know when the PM halts, save something to DB, too.

We have DEV, QC and Production Cloud based Appian environments. When developing on the DEV environment, and creating a new Record Type which then creates a new SQL table on our cloud database schema, it generates a SQL script for you to create the table. There is also a checkbox option to apply that SQL script immediately for you to your source schema.  The same happens if you update the Record Type fields. A SQL script is generated to alter your source table for you. I'm interested to hear how everyone handles their database changes across environments when using Record Types that generate the source tables for you? Do you download and store every single SQL script as you make changes to a Record Type? If so, where do you store them? Do you manually run those scripts on your databases for each environment? Do you deploy them as part of a package which only has the SQL scripts? Or do you deploy them as part of a package which includes both the SQL scripts and your ap

Hello there! I have some date as a data subset form and I need to create a pie chart which show which contract are overdue and which not .This pie chart need to be drilldown to a grid  which list only the contract on the selected category. The data are these: local!contrat: todatasubset({ a!map(id: 1,name: "Contract A",,deadline: today()-6,status: "Decline"), a!map(id: 2,name: "Contract B",,deadline: today()-20,status: "Open"), a!map(id: 3,name: "Contract C",,deadline: today()-2,status: "Draft"), a!map(id: 4,name: "Contract D",,deadline: today()+28,status: "Open"), a!map(id: 5,name: "Contract E",,deadline: today()-30,status: "Complete"), }, How can I do the grouping with this format of data? Thank you in advance

We are trying to fetch access token in order to integrte with gmail. To get the access token, we need JWT, which comprises of header, claim set and signature. The header and claim set part are clear. Can anyone help to understand how to compute this signature in appian? Is there any plugin available in the market?

For using GUID/UUIDs as primary keys, Appian supports varchar datatypes; however this is not very performant for indexing. The UUID datatype was introduced in MariaDB 10.7 and supports index-friendly storage. Will Appian support this datatype for data synced records?  Our use case involves supporting data transfer and merge from distributed systems, so using GUIDs as primary keys prevents any conflicts upon merge. Otherwise, we'd need to clear out all the keys and generate new ones upon inserts (pks and fks). Also we'd need to maintain a mapping of origin keys to destination keys. This is a tedious process. 

I have a requirement to generate and view PDF on single click , how can i do ? now i am generating then viewing pdf using start process, is there any way to do in one click thanks,

Hi,I am trying to get all the values from a table using Appian RPA Get table values action. But I am getting an error. This is the table I am trying to get. Transaction Date #Ref Description Contact Deposit Charges Payment Balance Action This is the table action configuration. This is the error I am getting.[STAT] 2023-11-03 04:37:36 01m 06s (0h) - - Start action 'browser->get-table-values' - 'Get table values' // dur: - - avg: - etc: [INFO] 2023-11-03 04:37:36 01m 06s (0h) - Target table has no footer section [WARN] 2023-11-03 04:37:37 01m 06s (0h) - Method manageException invoked [ERROR] 2023-11-03 04:37:37 01m 07s (0h) - java.lang.reflect.InvocationTargetException at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at j

I want a column in an editable grid where I have checkboxes for every cell in that column. User can select yes or no option

Greetings, Could anyone suggest to me a basic POC get a good grasp in Appian RPA? I am good in Basic RPA but still, I wanna work in a POC to get a good Knowledge. so, I am kindly requesting you to suggest me a POC to work on Appian RPA. Thanks and Regards

Hello!I'm having a doubt about the use of the function index(), as a best practice in Appian development.In the Appian documentation appears as: index( data, index, default ), but I know that we can use the function as: index( data, index, index, index... (as many as needed), default ), to navigate between an object and it returns the value needed. The question is: Should I use nested index() functions? or Is better to use just one index function with many indexes inside? Example: {CountriesES, CountriesUS, CountriesNL} -> Cities -> Town 1 - Index(CountriesES, "Cities", "Town", null) 2 - Index(lIndex(CountriesES, "Cities", null), "Town", null).

Hi I am Learning Appian development, i have doubt how to combine two text local variables please hep me on this a!localVariables ( localVar1: Text := "Hello,", localVar2: Text := " World!" ) local!combinedText := local!localVar1 & local!localVar2

I have got this error when I click on button in interface for starting Process model. How can I resolved this error

I want to get the sum of values from a column in the expression editor and I want to use that expression object in an interface to show my Sum which I calculated.

Hi All, I have a scenario where i am facing some issue: I have a process model to create a data into db by using import excel to database, when i add the data in excel and upload its working as usual, but when i miss some rows in excel while adding data and uploading. process model is not writing that data in Database, its simply completing the flow but not writing the data.

i link: a!documentDownloadLink(document: fv!item.appianDocId ),   used the above two lines to  download  a document but it does not download  , it open a tab with a message error : { "error": "APNX-1-0000-000", "message": "Invalid Content ID", "title": "An Error Has Occurred"}

Hi All, I have a scenario where if an expected SLA date&time falls on a non-working day, I need to get next working day value. For example, I have my initial submitted date as 12/27/2023 2:01 PM PST and expected SLA date time based on some biz logic should be 1/2/2024 7:01 AM PST. I have used the below logic but somehow instead of getting the SLA date result for next year as 1/2/2024 7:01 AM PST, I am getting the SLA date result in the same year as 1/2/2023 7:01 AM PST. Please note correct process calendars are used and Dec 30 2023,  Dec 31 2023 and Jan 1 2024 are all set as non-working day. Please help/advise on how I can update to get the correct value:local!finalSLADateTime: if(calisworkday(1/1/2024 7:01 AM PST, local! Calendar),1/1/2024 7:01 AM PST,1/1/2024 7:01 AM PST + (dayofyear(caladddays(1/1/2024 7:01 AM PST, 0, local! Calendar)) - dayofyear(1/1/2024 7:01 AM PST))),

Hi All, I want the output of a workday function to be Date&Time instead of just Date. Please advise on how I can wrap the below logic to get the output as Date& Time:workday( todatetime("01/01/2024 7:01 AM"), ( dayofyear( caladddays(todatetime("01/01/2024 7:01 AM"), 0, "Default Calendar") ) - dayofyear(todatetime("01/01/2024 7:01 AM"))),datetime(2024,01,01) )I need the output to be 1/2/2024 7:01 AM instead I just get 1/2/2024.

I am building a editable grid in an interface. I want to give ability to the user so he can add new row to the grid. When he clicks on the new row button  a new row appears and after filling that row, it should be added to the record type and the grid type.

Hi All, I need to show and store 7 digits after decimal and before decimal its 'n' number and the data type is number(decimal) how I can do that?  Thanks in advance.

Is it possible to add variables (fields) /some matter like "hi ,this request needs supervisors approval"  in the task ?

I am trying to implement a basic expression rule to determine if a short string is formatted correctly. I have the code below but it returns the error "Keyword Argument unsupported by function contains". I am getting similar errors in other parts of my application so I'd like to figure out what the error means.

Greetings, My requirement is to create an Appian application that runs within the environment, giving the user the ability to view the log data from login-audit.csv and logout-audit.csv. While I have done this, I was wondering if I'd be able to expand on it: Is there a way to view which application objects a user has modified in their session? If there is a log file that tracks this in shared-logs, that would be handy. Thanks in advance. 

In table we have two fields id and status but according to id i want condition like if status chnaged to cancelled then it should move to end node how i can use this condition in XOR gateway ?

Hi, understand from the documentations that the limit of activity chaining is < 50 nodes. Want to understand if the limit includes the nodes within synchronous sub-processes? Also what if the sub-processes ran multiple times?  For e.g., parent process has 40 nodes, including a synchronous sub-process with 15 nodes. Does that mean that somewhere along, the activity chaining would break? What about this other scenario - parent process has 20 nodes, including a synchronous sub-process with 10 nodes but it runs multiple times (let's say 4) - would activity chaining break in this scenario as well?  For some context: We are trying to implement a search feature for our client that requires the integration between 3 APIs... in our interface we are using a!StartProcess to trigger a process model and using processInfo to get the process variable to display the results of the integration. But ofc our process model is too large (with each integration as their own sub-pro