Foundation

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 ?

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 !!! 

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) } ) ) ) )

I have a very simple application that is just based on one record type that comes from an integration. Making the edit/view interface was a piece of cake. Now I need to make the create new record functionality, for which I can re-use the same interface for edit/view. The issue is that I am unable to find a way to do this without creating a process model. I don't need all of the complexity of a process model. I can call the create integration from the save into in the interface. There is no work flow and I don't need to launch any kind of other process. Having a process model is WAY WAY overkill for this case. How can I simply open the same interface with a blank record from the record list (via action or similar) with out needing the overkill of a process model? Thanks

I have an interface that opens for a single record passed in via a rule input from a REST integration GET call. The interface opens as read-only be default. There is a button at the bottom labeled "Edit". When the user clicks this button, interface becomes editable. When the interface is editable, there is a button labeled "Cancel" at the bottom. When the user clicks the "Cancel" button, I need to discard any changes the user made, and revert back to the original copy of the record. I have attempted to do this by calling the integration which is the GET by ID in the saveInto of the Cancel button. The value is successfully fetched, and I can view it when I put the result into a paragraph field, but when I assign this result back to the rule input, the fields of the interface are not updated and the user changes are not reverted. Is there an easier way to discard the user changes and go back to the original record? NOTE: The goal of the Cancel button is

Hi team, i have requirement to implement a donut style of pie chart. everything is fine expect the data labels. it is not showing complete label name in the legend. a!pieChartField( label: "Employee Credential Status", labelPosition: "ABOVE", series: { a!chartSeries(label: "off boarding or termination of client", data: 1374, color: "BLUEGRAY"), a!chartSeries(label: "making account to non billabale", data: 343, color: "AMBER"), a!chartSeries(label: "updated accouts to check pay", data: 97, color: "RED") }, height: "SHORT", seriesLabelStyle: "LEGEND", colorScheme: "CLASSIC", style: "DONUT", showTooltips:true, showDataLabels: true, showAsPercentage: true ) The requirement is to show complete label in the legend. 

Can anyone let me know the difference between a escalation and an exception in a process model.

I'm encountering an intermittent issue when using a!startProcessLink within a a!richTextItem in a task. The process model being called is fully chained from Start to End and works fine when called from a Record as a Record Action. But in this case where I am calling from a Task, once the process ends, I sometimes get the error message: "The Task Could Not Be Submitted. The task has already been submitted." This occurs sporadically. Any insights into why this might be happening and how it can be resolved? Thank you!

Hi All, I have two interface, A and B. When a button in interface A is clicked all the components in B should be refreshed. Is it possible to refresh all the components in interface B without passing parameters in all components in interface B?(I am passing the refresh variable from A to B, but not from B to components in B)

When I select CDT  in datastore. I got this type of error. Error: "An error was encountered while processing your request. Please try again." what should I do with this.

Hi All, Is there any way to control the size of text in dropdown values?

Hello, I keep getting the this error in my process model: "Error: Work Item Cancelled (Data Inputs)" on a Create Group smart service node. I read that this is often caused by the assigned user being deactivated, however the lane assignment is to an active user and all notes as assigned in the lane. What else could be the issue?

Hi , we are trying to access Appian by using mobile apps and we receive an error "An unknown error has occurred". By using a browser we don't have that problem. Any idea how to proceed will be much appreciated. BR,Natasa

I've done some searching on this topic, but it's been awhile since this question has been asked/answered so looking for some updated info.  What is the best way to send a text message  to external cell phones.  And to include some custom text and possibly an image in the text. Any insight into this would be super appreciated.

Hi Experts  Is there any limit for the length of the name of any object. For example: an object name could not be more than 27 characters, Is there anything like this ? Thank you in advance 

Hi Team,I am trying to use Export Data Store Entity to CSV smart service where DSE fetching data from view. Failing Node Error: Details: An error occurred while accessing the datastore entity: View1Contact a system administrator for additional data.  Could you provide any suggestions on how to resolve it? Thanks in Advance [mention:126a676c85024855948336691b0a7b92:e9ed411860ed4f2ba0265705b8793d05] 

I have a form layout with a save button. Validation executes on button click in preview when designing the form, but when the form is opened via link on the record list and and summary view opens, the validation does not execute on button click. I am at a loss to understand why this is happening. I don't see any settings on the record view that would disable validation. Any ideas why this is happening?

Hi I need someone help!! I was trying to filter relationships in record data using record type in rule input, but could not filter. When I tried to filter the relationship of record data using text datatype in the rule input, i was worked. My question is why I couldn't  Filter when using recordtype. I don't know what is wrong.

インターフェイスに複数の PDF ファイルをアップロードします。各PDFファイルの名前と一致するフォルダーにファイルを保存したい。

Hi All,I'm getting these lines in any charts that are closed like column,bar,area,pie charts, Can anyone help me to avoid these.Thanks

Hi All, Can Anyone guide me on how to show preview or actual document inside a grid? I have a grid of documents , documentID number, name, but with the document ID is not enough to show the actual preview of document, does anyone know or can advise me how to achieve this? thanks in advance

Hi community members, So in a process model, I added a XOR node. In the condition I put "=a!isUserMemberOfGroup(loggedInUser,  a!groupsByName("Test group"))". The purpose is if the user belongs Test group it will go to path A. If not it will go to path B. So I'm sure the loggedInUser belongs to Test group, however when testing, after this XOR node it goes to path B. Did I make some mistake on that expression? I tried "=a!isUserMemberOfGroup(pv!loggedInUser,  a!groupsByName("Test group"))" and it was not working too. Any suggestions? Based on suggestions,  I created a constant for the group and use the expression a!isUserMemberOfGroup(loggedInUser(),cons!TEST_GROUP) . However it still didn't work as expected in the XOR node (not outputing "true"). But when I test the expression outside of the process, it outputs "true". So I'm wondering what's potential

Hi, I want to schedule ACD201 Senior Developer Certification, For Which Voucher Code is required,   Kindly let me know how I can get it. I am ready to pay for it.     Thanks, Shree Krishna Tiwari  

I am generating pdf document but document  may contains special characters like (’,>,<,*,",) so i am getting error, is there any way to resolve this ?