Discussion Categories

Hi, I want to display the difference between today's date and created date in record type as an integer value. Further, I want to show the value in certain colors based on condition (like if the values is less than 3 then green color; if the values are in between 3 and 5 then yellow; and if the values are greater than 5 then red). This values will only come when the status is not completed. Can somebody guide me?. Many thank,

Hello All  I want to add a field that accept only 21 digits of number I tried to use a!integerField but is not allowed to enter too long numbers 

Hello all, I have an array of 3 items. local!array:{  { id: 1, deleted: true, activeStep: false },  { id: 2, deleted: false, activeStep: false },  { id: 3, deleted: false, activeStep: false },}, Now I want to concat text based on index. for index 2 concatenate "Active" and for index 3: " orderid" Eg: local!array:{  { id: 1, deleted: "Active true", activeStep: "orderid false" },  { id: 2, deleted:"Active false", activeStep: "orderid false" },  { id: 3, deleted: "Active false", activeStep: "orderid false" },}, How can I do this. Thank you in advance.

I am able to successfully sent files via the FTP node, but I am unable to open those files.  For example when I attempt to open a PDF that has been sent it tells me "There was an error opening this document.  The file is damaged and could not be repaired." JPG, PNG files open with just random pink on white. Word Docs "Word found unrecoverable content." Thoughts?

Hi, Is there an existing function on Appian to convert this value for example 100,000 to 100k? this goes on by million or billion. Thanks2

Hi All, I have a query regarding checkbox. There are three checkbox in interface as shown in snippet below, but only one of them should be selected at a time.  Can anyone please help me how to achieve this?

Hello everyone, Got an new error in an interface that existed for a while. It is a simple interface that takes several CDTs of data and displays it as well as taking some text input from users and passig it to a process, it does not have record headers or actions in it. This error refers to 'Headers' and 'body' that aren't used anywhere in code for that interface, so could anyone please help me make sense of it? Also, strangely enough it pops up only ocassionally and/or for different users, with same data.

Hallo All, We do have the following requirements. We need to share some CSV exports from the Kiwa Appian environment to a remote file server using SFTP. However, the SFTP file server must be accessed through an SSH key pair. I'm trying to use the "SFTP Functions" plugin from the Appian marketplace. Since we need to use the SSH key pair to access the remote file server. I was looking Appian community for help and found the following discussion thread useful and tried to follow the instructions. Appian Community But to proceed further, I have a few questions about the shared approach and need your support on this. Is it possible to communicate SFTP file server using SSH key pairs from Appian? Could you please share any Appian documentation for this? In the discussion, It mentioned that I need to configure third-party credentials, could please mention what will be the credentials field names and values? I tried to configure third-party credentials with "username"

Hi community members, Because of a new feature, I added a xor gate and a new path in a process model. The form is some where after the XOR gate and new path. The issue is now when I clicking the save button, the form unexpected closed (no error message). The previous correct behavior is clicking save button and then clicking submit button, which means the form is stay open after clicking save and before clicking submit. Now I have to go to the process model and click the form node to view the form again then click submit. I didn't change anything in interface/UI. What the possible cause for this issue and any suggestions? Thanks!

Hello folks,  I created a record action and showing the record type grid  with the record action as the landing page on site,  by default the record action is coming on the left side..Is there any option to shift it to the right side 

When I put Start Form in start node in debug mode it show like below image This is My Process model

Hi All, will appian integrate something like a reporting services?  A tool like SQL Server reporting services o Jasper , useful to easy design pdf or excel or any other file format, map data from database fields to these documents in order to download them dynamically via web API Thx

HI  I am trying to duplicate a field in database table along with data Can any one suggest me how to do this?

Did Appian remove sortintegerarray() ,sortdecimealarry() ,sorttextarray().       function 

i want to use youtube videos in appian, any possible way  Is there any plugin or utility for this youTube

A user has a direct URL to access a record view.Which configuration(s) would allow the user this access? A. A combination of user filters, source security, and record type security are required. B. Source security is all that is required. C. A combination of data source security, record type security, and default filler configuration (if it is set) are required. D. Record Type security is all that is required.

a!localVariables( local!singleDropDownValue, local!multipleDropDownValue, { a!dropdownField( label: "Single Dropdown", placeholder: "Select", choiceLabels: { "Jane", "Jack" }, choiceValues: { 1, 2 }, value: local!singleDropDownValue, saveInto: { local!singleDropDownValue }, validations: "Error..." ), a!multipleDropdownField( label: "Multiple Dropdown", placeholder: "Select", labelPosition: "ABOVE", choiceLabels: { "Jane", "Jack" }, choiceValues: { 1, 2 }, value: local!multipleDropDownValue, saveInto: { local!multipleDropDownValue }, validations: "Error..." ), a!buttonLayout( primaryButtons: a!buttonWidget(label: "submit", submit: true) ) } ) Expecting validation to trigger only when the field value is not null. It works for multiple dropdown, but why not for dropdown?

The size of  a folder is showing 69 GB, while the sum of size of all document in it is less than 20 GB. Due to this, Disk Utilization is increasing . Is there any way to correct this and decrease the disk utilization?

Hi All, When trying to filter using a dropdown, getting below error: Do not see any error in the backend, data store is published successfullyalso there are less than <10 records in the database so dont think of performance issue. please advise in which logs can I check this error to debug: Expression evaluation error [evaluation ID = abc7a:61357] in rule 'rmo_rule_getticketqueueview' (called by rule 'rmo_frm_ticketqueue') : An error occurred while retrieving the data. Details: Unexpected error executing query (type: [RMOVWticketQueueDT29056], query: [queryentity expression], order by: [[Sort[implementerStatusPriority asc], Sort[isSameDayImplReq desc], Sort[cutOffTime asc], Sort[urgency desc], Sort[ticketTypePriority asc], Sort[slaDateTime asc], Sort[ticketId asc]]], filters:[((status in TypedValue[it=103,v={RS20}]) AND (isWithdrawn is null) AND ((isGLConfirmed is null) OR (isGLConfirmed = TypedValue[it=1,v=1])) AND ((isConfidential = TypedValue[it=1,v=0]) OR ((isC

Hi, I have a record type whose structutre is: Start: local!RecordA ( - field 1, - field n, - Relationship: Record b1 ( --- field 1, --- field 2 ) Record a --> b 1:m relationship. After some manipulation, I want record a to become: End local!recordA ( - field 1, - field n, - Relationship: { record b1 (field 1, field2), record b2 (field 1: null, field2: null)} How can i go from start to End? Could you help me? I hope the aim is clear. Thanks a lot

Hi Everyone, I have a requirement where I need to generate a pdf from html.  To achieve this I am using Html to Pdf (Page Number and Custom Fonts) but it is Faling due to java.lang.NullPointerException. Can someone help me on this?

why my appian is not working

can we use this record sync history to display in interface?

Hello,Is there a way to automate taking DB back up from Appian Cloud? We do take back up manually from Appian Cloud before PROD deployment every month.However, we now are looking for automating the process before every deployment.Please suggest if you know of any good way to take Appian Cloud DB backup without the intervention of Appian Support.(I know of "mysqldump" plugin but do not want to use it since it's not maintained for the latest versions of Appian - https://community.appian.com/b/appmarket/posts/mysqldump)

My requirement is as below: I have a set of Ids, and using an integration I am getting all details of the records of those Ids. After certain manipulation of the dataset, i am displaying the dataset on a grid. Now I want to download the same grid to an excel/csv document. Please note, I am not saving the data in any table so I can't use export to csv from DSE option. What I have tried is using an document WebApi where I pass my Ids and get the details and download the document.  The problem with this approach is: 1) I have to call the integration again and do those manipulations again 2) The Ids I am passing as query parameters. When there are more than 1000 ids, the url is becoming too long and the API is failing. Can anyone please suggest an alternative approach to resolve this issue TIA