Discussion Categories

Hi Community, I have noticed strange and unexpected behavior of the Write Records Smart Service in the current version of Appian. I have a table with a primary key that is not automatically populated via auto-increment or a sequence; instead, the value is provided by the application. A sync-enabled record type is configured for this table. I am trying to create a process model that is responsible for cloning a record. The process model consists of three steps: Retrieving the data using queryRecordByIdentifier and storing it in a process variable (pv!record). Adjusting the attribute values of the process variable (pv!record), ensuring that certain attributes in the cloned record have different values, and assigning a new value to the PK field. Writing the record to the database using the Write Records Smart Service. While executing the process model, I encountered the error: The input "Records" cannot update a record's primary key value. The request to update t

I have two process variable bkk_act_id,filt_table. Both are record type of two different table with common Account_id. I want to use account list in the first table to filter the second table rows containg that Account_id. While this work if I use the record type directly, but when I try to do the same with process variable its throwing error for both the variable processing:  Expression evaluation error at function a!queryRecordType [line 11]: Could not cast from Tst_act_list to RecordType. Details: CastInvalid) (Data Outputs) a!localVariables( local!accountIds: index( a!queryRecordType( recordType: pv!bkk_act_id, pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 5000) ).data, pv!bkk_act_id['recordType!{c1a6fae6-0413-4ce9-b777-4bf0906e36a2}Tst_act_list.fields.{50cfb814-61d1-4617-9005-25befed5abe7}accountId'], {} ), local!filteredData: a!queryRecordType( recordType: pv!filt_table, /* Table to filter */ filters: a!queryFilter( field: pv!filt_table['recordType!{73b2f9fb-792e-4

Hi all, I am trying to make a small robot that downloads an excel file from Appian and uses a macro template to apply formatting to the downloaded file.Using the Open excel workbook action on the downloaded file everything works. When I use the same action to open an xlsm file, that is, the file with the macro, I get this error which I attach.I thank in advance those who will help me solve the error.Best regards,Marco Pennacchia

I have a scenario where, if I click the "Reject" button, the comments field should be required and cannot be empty. If the "Approve" button is clicked, the comments field should be optional and be submitted. I have a ri!cancel input that changes to true when "Reject" is clicked and false when "Approve" is clicked. However, the validation isn't working as expected. I tried setting the "required" parameter to ri!cancel, but after clicking "Reject" and then "Approve," ri!cancel doesn't seem to change back to false, and still throws validation for approve button if comments is emptyCode for the interface comment field and buttons: a!textField( label: "Comments", labelPosition: if(ri!readOnly, "ADJACENT", "ABOVE"), value: ri!TR_Expense_Details.comments, saveInto: ri!TR_Expense_Details.comments, characterLimit: 250, showWhen: ri!TR_Expense_Details.hrApproval = true(),

My current phone number is getting off in few days so I need to change the number to a new one, but i'm unable to do that cause i can't find the option to do that. Anyone who knows about it ,do tell. 

Hi all,I have a doubt is there a possibility we could have a race condition problem when appending from parallel process nodes to the same pv array? I have a following situation: So, I am generating several documents in parallel. Some of them will be generated, some of them will be skipped (based on ContractX gateways decision). When generated, I would like to add them as a document cdt instance to the array of document cdts stored in a process variable. So in each yellow marked script task I am using (on output tab) :I usually didn't have problems with possible race condition. But, in theory, is this 100% safe method? Is there a possibility multiple 'Add to docs array' nodes are executed on different process engines and execution happens exectly at the same time and there is a possibility of data loss (some items are not added to the array because 2 engines had different state of the array)?I know there is a workaround where we can merge all parts of the array after

Hi all, I am new to the Appian. I am created an interface with record type, add option and a process model to save the data in database. Created process model with the options ‘write to entity’ and ‘write to records. Below is my understanding. Enable activity chaining is refreshing record type data in both the options. Rule input for interface can be created by using CDT. This will work only for ‘write to entity’. ‘Write to entity’ and ‘Write to record’ both are same. ‘Write to record’ is the latest one and ‘Write to entity’ is the legacy approach.  Please confirm is there any other main difference.

local!data: { { name: "John", status: "Active", test: 10 }, { name: "John", status: null, test: 4 }, { name: "Alice", status: "Active", test: 5 }, { name: "Alice", status: null, test: 6 }, { name: "Bob", status: null, test: 8 } }This a the above data now my requirement is remove null status only for the duplicate name and transfer the test value to the non-null status.Can any one please help me with this.

We are trying to build CICD using Github and Github actions. Could we get help around setting up Github for Appian.

Hi Everyone, am trying to add comment history to capture the comments added by the user and stages of the approval. Requirement is to show the comment by default, if user not added the comment remove the space.  Below is the reference code. But the condition seems not working. Thanks to help here to learn more!

Hi Experts, Need your help in one scenario. I have one interface which is fetching a data in a local variable from an ER in which we are getting response from an API. It is happening that we are getting the previous response in a rich text field(showing the local variable data) from the API for a particular value on an interface. If we change the value then only we are getting a new response. If we use same value again and again and setting different Timeout limit in the integration, the output we are getting from an API is same until and unless we change the value.  Is Appian cached the value-API response on an interface?  

Is there any possibility that load() and with() will be discontinued ??  is there any possibility that load() and with() will be deprecated We have a!localvariables to do the same thing more efficiently.

input : {{1,3},{2,3},{4,5},{5,6}} output : {3,6,20,30} We have to get product of each item(i.e list) in the array. Please help me out with this issue

I have an error in Image colums when enter the following expression according to instructions in the part5 Dsign Record Types:if(a!isNullOrEmpty(fv!row[recordType!AX Vehicle.fields.image]), a!EXAMPLE_DOCUMENT_IMAGE(), fv!row[recordType!AX Vehicle.fields.image]) Error message:Error Evaluating UI ExpressionExpression evaluation error at function a!gridField_23r3 [line 51]: A grid component [label="null"] has an invalid value for "columns". A grid column [label="Image"] has encountered an error. Expression evaluation error at function a!imageField [line 55]: User Does Not Have Rights to Perform this Operation I have completed the exercises in the security part 3 of the Acme Auto application correctly. How can I fix this?appreciate all the help I can get. Thank You!

I have created a related action for a record type, and it is working well when i open it from the summary view in the main dashboard where i am presenting it but when i am trying to create a button for the same action it is not working well.

Hi, is there a link or a dedicated space where we can submit suggestions for missing icons in the Appian library based on specific customer use cases? I’ve often found that certain icons could enhance a user interface but were not available, such as a drilling rig for the Energy and Utilities industry.Many thanks in advance!

Does deploying custom plugins with custom data types automatically create CDTs in Appian? If not, does the plugin deployment fails if those CDTs are not created manually prior to deployment. Thanks in advance!

I want to have a questionnaire with linked questions, like when user choose option A then go to question 2 while user choose option B then go to question 3. And the questions are not static, user also need to manage the questions in Appian, meaning the questions are dynamic. User can change the answer and which question it is linked to. How can I implement such feature?

Hi Now,I'm learning Appian Service Backed Record Types following Appian tutorial video and reference links. ・videowww.youtube.com/watch ・linkdocs.appian.com/.../Sync_Records_Smart_Service.htmldocs.appian.com/.../Sync_Records_Smart_Service.html I have implemented it as shown in the attached screen, but it is causing an infinite loop. If anyone knows, please provide the details of how to implement it correctly. Thanks

In the Interfaces 103 training, during Sprint 3, the video at around 2:34 shows 3 objects under Workflow and 4 objects under Security and Organization. However, my screen shows 2 objects under Workflow and 4 objects under Security and Organization. Then at 3:02 in the video, our screens again look (about) the same. Then at 3:09 in the video, the instructor has a "PF_CreateGoal" interface, but I don't have it. I have the other 5 interfaces, from the prior sprint (lesson) but not the new interface. I also do not have a workflow like his "PF Neww Goal" workflow. In fairness, the current "Generate Record Actions" is a bit different from the video. But the "Generate Record Actions" succeeded, so where did the objects go? -John

Hi All,We have a process in our environment which gets triggered whenever it receives an email. We have a requirement from business where they want the whole outlook email or any email sent by them to Appian which triggers the process to be stored as some document inside appian. Is there any way to achieve this?

We need to generate excel from table having 40 MB data via Appian. Out put excel will have 200 columns based of user selection in Appian UI. We are thinking do this via Batch during non business hours to avoid the load but checking is any limit on number of columns or excel size. As Export sql to excel seems to be having 36 MB limit. Can some one suggest? Thanks

Hi,  A user task with notification setting enabled - sends mail when it reaches the node. This user task has a Save button, which brings the control back to the same node in the process flow. Upson save, mail notification triggers again.  Tried activity chaining to avoid 2nd time notification upon save, but triggers mail. Is it possible to avoid this?  Note: I can have a split gateway and have a mail notification smart service and disable the automatic config. But wanted to check if there is any OOTB. Any help/ideas are appreciated. Thanks,Keerthi

Hi All, while user trying to upload file from the site its taking 30 to 40 sec time to open file folder,. thanks

Hi everyone,  I'm not sure if you guys have the same problem as mine, but haven't found any similar topic in the forum... I am having an interface, which is using a recordtype as data source. The record type already had 5 user filters to be used in the interface.  Appian's recordtype based interface is currently providing a prebuilt feature that allows users to Manage Filters (Save/ Set as Default/ Reset filters), and we are using this feature to save some filter choices. However, recently I added a new user filter, and realise all my saved filters were removed from the filter tab. It brings quite an issue to some users, as they have saved lots of filters to customize their reports.  Have you seen this issue before? And is there any way that I can retrieve the filters back/ or prevent this issue when deploying the new user filter to PROD?