Discussion Categories

Howdy All, I'm new to Appian and struggling with how to configure the Editable Grid for a form response. Particularly trying to troubleshoot the "Add New Row" feature within the Editable Grid. Any advice or guidance on how to adjust this would be appreciated! /* Editable Grid */ a!sectionLayout( label: "", contents: { a!gridLayout( label: "Please Complete below if there is no quote attached.", labelPosition: "ABOVE", headerCells: { /* 1 */ a!gridLayoutHeaderCell(label: "Action"), /* 2 */ a!gridLayoutHeaderCell(label: "Item Number"), /* 3 */ a!gridLayoutHeaderCell(label: "Item Description", align: "LEFT"), /* 4 */ a!gridLayoutHeaderCell(label: "Part Numbe

Hi All, We are getting the following error in process model "This process has been inactive for a time period exceeding defined limits" . This error is occuring in a user input task. Can anyone let us know what is the reason behind getting this error? The process has been configured to run every day at 12am.

As above table having many to one relationship we can see as arrow, we are considering Mapping table as master table, All tables we have created Record type. 1. in one UI page used "Mapping table", and in that page we are selecting Country, Region and Category code. Entering textbox values of "Info table" and "Att table" and clicking "Submit" button. We are getting error. "function a!dropdownField [line 33]: An error occurred while executing a save: Expression evaluation error: Field with [identifier=9b2cef30-2e3c-4575-9e32-c9897a6dff7a] not found on the Record Type" 2. Here we need to insert same record in "Info table" and "Att table" once done then new both Ids need to insert in "Mapping table" how we can do in one go on click of submit button? "The input "Records" cannot be created or updated. The relationship configuration between "Mapping table" and "Att table"

Hello, I am trying to do a simple check on a paragraphField or any field(integer, text, decimal field). The validation is not working for empty or null. I tried giving a!isNullOrEmpty(ri!value), Null(ri!value), ri!value=null. The validation message is not shown.  If i give any other logic, it works. 

Update class 8 to 9 { a!map(name: "X", class: 5, School: "ABC"), a!map(name: "Y", class: 6, School: "ADC"), a!map(name: "Z", class: 7, School: "AEC"), a!map(name: "K", class: 8, School: "AFC") }

Hi, I have a requirement to create a graph with the following. Active in Oracle  - 1(ID) - count 2 Active in mainframes - 2(ID) - count 3 Pending - 3(ID) - count 4 Cancelled - 4(ID) - count 7 Now I need to create a graph with Active, Pending, Cancelled in X axis and in 5 ,4, and 7 in graph. Basically need to group 2 status in one and show the sum of count. And then on drilldown we need to show the records associated with them in grid. How can I achieve this. Thanks

Hi guys, Have question that we are having user login through SSO, also set-up the SAML. So when the user first time login, Appian will create this "New User" also add them to the group. So the issue is we also need update DB, just wondering is there anyway we can trigger a PM to update user DB once we have a new user or a group got update? Or it can be set-up via SAML? Any suggestions appreciated.  Thanks in Advance. 

I'm currently working on a functionality that involves view with huge dataset in Appian and I am planning to replace it with record relationship. I have a situation where I'm using a left join with a table and implementing a self-join with three conditions using the AND operator. Here's the view that I want to replace. SELECT `snapFrom`.`id` AS `id`, `snapFrom`.`material` AS `material`, CAST( `snapFrom`.`FCFinalTotal` AS DOUBLE ) AS `FCFinalTotalFrom`, CAST(`snapTo`.`FCFinalTotal` AS DOUBLE) AS `FCFinalTotalTo`, `snapFrom`.`snapshot` AS `snapFrom`, `snapTo`.`snapshot` AS `snapTo`, `snapTo`.`FCFinalTotal` - `snapFrom`.`FCFinalTotal` AS `diffValue`, CONCAT( SUBSTRING_INDEX(`snapFrom`.`calWeek`, '.', -1), '.', SUBSTRING_INDEX(`snapFrom`.`calWeek`, '.', 1) ) AS `calWeek`, `m`.`basecode` AS `baseCode`FROM ( ( `Appian`.`SOE_STAGING_FORECAST_WEEKLY` `snapFrom` LEFT JOIN `Appian`.`SOE_STAGING_FORECAST_WEEKLY` `snapTo` ON ( `snapFrom`.`calWeek` = `s

hii all, i have a interface to request for Range Reset in retail organization , once the required details filled user going to submit the form here , for each RANGE RESET i have set of tasks to complete , whenever user clicks submit button 12 tasks should assign to 4 owners along with the task completion time lines , task owners are  1.reset manger 2.assistant buyer 3.buye 4.merchandiser , how to achieve this , each should assign 3 tasks per head

is there any data flow from appian outlook add-in to appian cloud application. This is related to Task Viewer Add-in for Microsoft Outlook.

Hello, I have a problem with a form interface where users are supposed to be able to drop a file with a a!fileUploadField, but if the user tries to detach the file before submitting form or to detach it by updating the record, I have this error : Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error [evaluation ID = U7CHV] : An error occurred while executing a save: Expression evaluation error: Cannot update List of LIH Attach; length of assign value list (0) does not match length of the list to update (1) I have already used this in another interface and it worked, the only difference is that the value and saveInto are using a relationship this time. Here is the code : a!fileUploadField( label: "Pièce jointe", labelPosition: "ABOVE", placeholder: "Placez la pièce jointe ici", target: cons!LIH_GET_ATTACH_CONTRIBUTION, maxSelections: 1,

I'm developing a custom connected system plugin with related integrations. 1. Does Appian use Spring Boot? If not, then the next question is mute. 2. Does Appian scan for @Component (or any other class annotations) so that these classes are managed by Spring Boot, autowired for dependency injection, etc.? It would be nice if classes developed within a plug-in were Spring managed. TIA, Eric

Hi All,  One of our process report is not showing correct data, it was working fine few days back but suddenly it is removing few data.  In process report performance details have got this error: Comparison (Evaluation of Status) (EVAL:@reason=rank)  What does this error means and how to resolve this. Thanks.

Hello Everyone , I am facing a problem with  AX_SupervisorForm When i try to approve a vehilce error massage showing this 

Hi Everyone, I am facing an issue with News Feed, My requirement is whenever I am posting a comment I should not receive any email, I tried disabling the Email notifications for News but it's not working. My scenario is, I have 2 users (Initiator and Approver), when initiator submits a case to the approver there will be post added to New feed Now Approver gets a task to approve the Case, at this point whoever(Initiator or Approver) comments the post, that user is not receiving any email But after the Approver Approves or Rejects the Case(the case will go back to Initiator if rejected), then in both scenarios Initiator is receiving an email if Initiator is posting comment in News feed Entry and Approver is not getting the email if anything is commented to the post. Please help me resolve this, I should not receive email notification for Initiator in any case. Thanks

Hi, I am developing a custom java RPA module .While setting up developing environment I am facing issues with getting below parameters . 1. appian_username ,maven_API_key . This is to configure maven. Setting.xml<server><id>jidoka</id><username>appian_username</username><password>maven_API_key</password></server> Appina veersion : 23.4I am following below link to setting up environmentdocs.appian.com/.../maven-setup.html Could you tell me how to solve it.

Hello everyone!!I need help doing an integration in appian with a SOAP API. I have to make a call with a security token that is the public part of an encrypted digital certificate, but I don't know how to include this token in the component.Thank you very much in advance

On the click of a button, we are populating values from the process model back to the interface. This is working perfectly for some users. But for some users, its throwing expression evaluation error even when the data is same in both cases. Could this be related to any permission or security issue?Update : This is occuring for users who only have access to site page.Thanks in advance

i have two tables TPS Interchange and TFM Trinary. Primary key of TFM Trinary is foreing key of TPS Interchange which is Trinary_id . TFM Trinary contains key Column which has some text data like TESTCALL, TESTEMAILalso created a record type TPS Interchange  and record type TFM Trinary . Now i want to create an custom field  like if   'recordType!TPS interchnage.Trinary_id = 15 then it showsTFM Trinary .key= TESTCALL if 'recordType!TPS interchnage.Trinary_id = 20 then it showsTFM Trinary .key= TESTEMAIL otherwise Default nullHow to do this ?

I have problems when configuring the process model component called Invoke SAP BAPI.The result is the following error.... The scsExternalSystemKey is configured like this... Finally, what would be the SAP data corresponding to Client Number and System Number? I understand these are ClientNumber = Mandante and SystemNumber = ID de Sistema (in Spanish) PD: The credentials are the same as those used to enter SAP through its interface

Hi, I am having a requirement to show 80 columns exported to excel. I used export datastore entity to excel smart service in my process model.Since the smart service does not allow more then 50 columns,I generated 2 spreadsheets,(1st excel is having columns 1-50 columns and 2nd excel has data for columns 51-80). I used Merge excel documents smart service but the resultant spreadsheet is not concatenating columns horizontally. . Can someone please let me know if there is any alternate approach to  fulfill this requirement OR Any leads to fix the merge excel documents issue can be helpful. Thanks In Advance! Akhila

We are looking for a full time Appian Developer. At this time we are not interested in hiring a consultant or consultant group, in-house only. Please apply via the link below: phg.tbe.taleo.net/.../viewRequisition

Hello all, We are retrieving a row data from Database using query entity.  In query filter we have a condition to get a row data. Example  a!queryFilter(field: "name",operator: "includes",value: ri!status) Database having status value as "awaiting_info" I need to get the row data irrespective of case sensitive like (ri!status= "awaiting_info" or "AWAITING_INFO" or "AWAITING_info" or "awaiting_INFO") . On the "status" fields in the postgreSQL data base side applied the  case_insensitive COLLATION .But wherever we have applied the case_insensitive COLLATION, those colums are not supporting the  "include" operator from the query entity from Appian expression rule. Any suggestion on this !!! 

can we give limited Admin access to external organization accounts to create users for their entity?

I have one array and want to run startProcess() for each value in the array. I have implemented the following, but I get an error (Non-Save Reactions should be unwrapped individually and not processed as a list)localVariables( local!array:{"1", "2", "3"}, . . . . saveInto:a!forEach( items: local!array, expression: a!startProcess( processModel: cons!AAAAAAA, processParameters: { value: fv!item, }, onSuccess: { a!save(ri!result,fv!processInfo.pv.result) } ) ) ) )