Discussion Categories

Based upon the previous approval and reject status we need to predict and make the process autoapproval. We have three forms which user has to be filled and submit based upon this data the reviewer will approve or reject. Based on the previous data and approval& reject status the flow has to be automated. How do I achieve this..??

Hi, Do anyone know why I am not seeing the number of results instead its showing of results.

Hello, Relatively new to Appian. I am wondering is there a way to programmatically / automatically export record data to an excel in csv format? I know there is the out of the box export link/button on record type, but that is a manual process. We want something that happens automatically. Thank you

Hi Experts I have to delete extra files from request folders. Request folders were created at the time of request creation. Extra files means , when I was trying to migrate the files from legacy environment to cloud, PM fails. So, I Re-migrate the files that's why those request folders have some extra files. Now, before deleting those files I need to take a backup of files and folders, How to do I do this , because when I take backup and reupload backup, the doc id and folder id changes and I don't want IDs to be change. Taking backup is more important because we can't except any important files to be delete.  If any solution is possible please explain step by step. Thank you guys in advance

a!gridLayout( labelPosition: "COLLAPSED", headerCells: { a!gridLayoutHeaderCell( label: cons!CR_APP_LAB_STAND_VS_NONSTANDARD_FIELDS[2] ), a!gridLayoutHeaderCell( label: cons!CR_APP_LAB_STAND_VS_NONSTANDARD_FIELDS[3], align: "CENTER" ), a!gridLayoutHeaderCell( label: cons!CR_APP_LAB_STAND_VS_NONSTANDARD_FIELDS[4], align: "CENTER" ), a!gridLayoutHeaderCell( label: cons!CR_APP_LAB_STAND_VS_NONSTANDARD_FIELDS[5] ) }, columnConfigs: { a!gridLayoutColumnConfig(weight: 5), a!gridLayoutColumnConfig(weight: "NARROW"), a!gridLayoutColumnConfig(weight: "NARROW"), a!gridLayoutColumnConfig(weight: 8) }, rows: { a!forEach( items: ri!crAppStandVsNonStand_cdt, expression: a!localVariables( local!choiceValue, local!SingleREFStandardVsNonStand_cdt: index( ri!crRefStandVsNonStand_cdt, wherecontains( fv!item.questionId_int, tointeger(

Hi, I am trying to write data into DB using record type which is multiple. Process variable had data correctly but when it is writing into db the data is writing as  null though source fields and record fields data type is same and structure is same. Can someone help me on this?

I am using a!fromJson to convert a JSON string into an Appian value. However, I encounter an error when handling document types. This is the current format I am using: in ER:  """" & fv!item & """:[" & substitute(if(rule!GLB_isBlank(local!data[fv!item]), "", local!data[fv!item]),";",",") & "]",OUTPUT: "fieldName":[[Document:115497], [Document:115501]] but It's giving error 'The json Text parameter was not valid JSON'

Hi As I am trying to connect with gmail account with the help of "Gmail Connected system".The Gmail Connected system is connect successfully when it comes to integration I am getting "GMail Integration Error"The screenshot below:-Please let me know what I am missing.

hi Team, How to change the background color of the coding screen into black or dark theme?

I have CDT within the cdt feils name tableDetails(text), Text like [{"column1":"value1","column2":"value1"},{"column1":"value1","column2":"value1"}] how to display in gridlayout. give me the suggetion on this..?

What is the correct way to give private RSA key to docusign connected system,the RSA key pair obtain from Docusign console (the created app in app and key tab )  is not working ,I am getting Following Error

Can anyone please hep me in this? I want to sort below mentioned data. I was trying to sort data using queryentity and it worked. But I have to use rule input ri!employee(Type: Data Type). Please assist. Need to sort data by these fields: sort: { a!sortInfo(field: "empcode", ascending: true()), a!sortInfo(field: "type", ascending: true()), a!sortInfo(field: "amount", ascending: true()), } joinarray( a!forEach( items: ri!employee, expression: concat( "", "", union( { fv!item.empcode }, { fv!item.empcode } ), "", "", if( rule!GLB_isBlank(fv!item.barcode), {}, a!localVariables( local!code: union( { fv!item.barcode }, { fv!item.barcode } ), local!newcode: split(local!code, "_"), local!newcode[2] ) ), "", "",

I got this error when none of the interfaces or expression rules mentioned use the load() function, they all use a!localVariables(). Does anyone know why this error could still be appearing? "Interface Definition: Expression evaluation error ... The load() function cannot be used within rules called by looping functions other than a!forEach(). Pass the necessary variables via rule inputs or use a!forEach()."

Hello All, I'm experiencing a strange error with an API object when making a POST request. This is the request body:  { "project_id": 4, "participant_id": 1, "strata1": "New York", "strata2": "9"} I'm receiving a 302 error with the following error message: Error processing integration response error-result-guidance The response body could not be converted to an Appian value The jsonText parameter was not valid JSON. Received: <.... I have verified that the API key and endpoint are correct. I am able to get a 400 error using PostMan. Has anyone encountered anything like this before?

Hi All, We have  recordtype actions configured as dialogs for create and update of record. In the popup UI, the dropdown component not showing the drop-down values on the press of enter key when 508 tool ANDI is enabled. and the buttons (close or create) is not triggering in the case of the dialog format UI. Could anyone suggest what can be the approach to resolve the 508 issues? appreciate the suggestions. Thanks in advance for same. Raj

Hi, I am trying to experiment with Appian Co-pilot and I have encountered few issues. 1. I have set up my chat completion model in admin console. https://azure-open-test777.openai.azure.com/openai/deployments/gpt35-model/completions?api-version=2023-09-15-preview   : this is Chat completion endpoint in Azure If i Paste it in the admin console under AI services it's giving error, but if I add chat/ in endpoint as suggested by Appian then it is successful, please refer attached SS. Even if I give different deployment model name the connection is successful HOW??? 2. I am trying to upload simple PDF after successful connection (refer SS highlighted in yellow color), i am unable to get the expected interface. PDF:   

I have 2 rule inputs one is prevData and another is UpdatedData . I want a rule expression that will compare the two rule inputs and return the different fields and values from prevData rule input . And the I need to add the fields and values to another rule input which will be a input for write record smart service . Can anyone help me with proper steps ,please !

We are planning to use the Organization SSO instead of Appian authentication for our Appian cloud instances. I have one doubt, what happens to the administrator account post SAML enabled .

Hi , I am stuck with some logic here in color code, I need to represent variance column in amber colour ,if the varience is dropped to 50%. than actual value, Now this variance column is calculated with formula (actual-cov.threshold)/actual*100 so getting value is.How would I calculate that?I have used richtextDisplayfield a!richTextDisplayField( value: a!richTextItem( text: fv!item.varience_txt, color: if( fv!item.varience_txt < 0, "NEGATIVE", if( fv!item.varience_txt > 0, "POSITIVE", if( (fv!item.varience_txt) < (fv!item.actualThreshold_txt * 0.5), "#FFBF00", "" ) ) ) ) )&nbsp;&nbsp;

Hi all, I was researching about publishing processes as web services in Appian and the use of WSDL, and I would like to know if there are any limitations in the definition of XSD types. In a schema defined in the WSDL, can one schema reference another schema within the same WSDL? Are there limitations with the data types? Thanks!

I&#39;m seeing a white space below my footer in the site. Is there a way to remove it?

I have 5 columns configured in Kanban field, when I moving the upper tickets in &quot;TO DO&quot; column it works,But when I am scrolling down to the bottom parts to move further tickets in &quot;TO DO&quot; columns it doesn&#39;t work,reason because the container for &quot;TO DO&quot; column is too short(if their is less tickets in columns ), and not extended till max length of the column. If anyone can help me with the solutions. Thank you.

Hi,&nbsp; So I have a process model that sends an email and that email has a link that should redirect to that particular case summary page. Now, my Site has 4 tabs and in one of the tab we have 3 tabs and one of which has the record list of&nbsp; some XYZ table. In the record list,when clicked on the link of a particular case redirects to the summary view that is an interface created separately which takes the identifier as the input. Now, I am able to get the tempo url but what I need is the site url. Is it possible to get the site url. I tried substituting but didn&#39;t work for me. Let me know any kind of solution. Thanks in advance&nbsp;

Hello Everyone, I have a question with the GMail Connected System Integrations. messageIds is array in the rule input, but the test does not succeed if value is more than one. Could someone help me out to fix the issue.&nbsp;

Interface Definition: Expression evaluation error at function a!gridField [line 212]: Invalid field identifier: &quot;#&quot;urn:appian:record-field:v1:f93971d1-a676-475d-bcde-b5eb7ffea268/66d74798-e23e-48d6-8801-b307250c1052&quot;&quot; I am getting data from external system and mapping it into Appian. I am mapping it to appian record since will be storing it using write to record. I wanted to do sorting on all the columns&nbsp;using code below but getting this error when trying to sort: