New to Appian

Hi, I have a code like below where I am getting a list of text strings into a local!leadIDs. When I try to use contains() function to check whether a specified string exists, then I am getting an error like  Expression evaluation error at function 'contains' [line 11]: Invalid types, can only act on data of the same type (Any Type, Text) Can someone advise, how to fix this. a!localVariables( local!leadIDs: index( rule!getLeads(key: null()), "id", null()), contains(local!leadIDs, "AB12345")) Expression evaluation error at function 'contains' [line 11]: Invalid types, can only act on data of the same type (Any Type, Text)

a!localVariables( local!emails, local!invalidEmails: if( isnull(local!emails), {}, joinarray( reject( isnull(_), a!forEach( items: split(local!emails, " "), expression: if( validateemailaddress(fv!item), null, fv!index ) ) ), "," ) ), local!validation: if( isnull(local!invalidEmails), {}, "Invalid email at " & local!invalidEmails & " position(s)" ), a!textField( label: "Enter emails", value: local!emails, saveInto: local!emails, validations: local!validation ) ) I want my email addresses validation each mail should be in one line otherwise throw an error and email format should be correct other wise throw an error. ( test@test.com test2@test.com test3@test.com )  can someone help me with the code and how to store this email address in line by line in db

I am unable to request to restart my community edition site. After clicking on the Restart the site, if check for the status i am getting the same page with restart, get new site, upgrade to paid version. After requesting for a restart i am getting this And if i click the check status i am again getting this instead an any mail.Can anyone help me out..?

Hello All, I have a requirement to display record types in an interface. We have around 20 record types and I should display in an interface in tiles. When we click on each tile respective record type should be open in same tab/Dialog box and perform the record actions. When cancel its should comeback to the home page. Please find the below screenshot for reference. Thanks in Advance

My process has Start form setting 3 fields, Script task adding few more fields. but after the data is written to DB, Properties is limited to id only, other data is removed from Process variables. No error in process model and data is written to DB as well. Anything missed from my side ?

Hi Everyone, I have three fields in interface field A, field B and field C. I need to display the field C values only when the field B is checked. The values in fields are being populated using for each loop. Can anyone please help me on this.

hii all, in a editable grid i am fetching backend data by selecting a product name ,if i have selected product name then in next field the respected product description should come , after filling all the fields in editable grid i am going to submit and updating a data base , here every field  of editable grid is storing except the product description, respected product description is showing in the grid layout but its not storing in to data base ,but if i edit that product desciption and  submitting then its storing in the database . please help me  my requirement is to fetch product description by selecting a product name in grid and storing it in to the database thanks and regards, b ramesh babu

I am trying to return some values in a web API of mine where I call an expression rule that maps the vales that are wanted. The thin is I used index() function to cast the values like this  childId: rule!A_QE(index(fv!item, "id", null()))['recordType!{record}Record.fields.{record}.childId'], where the item is going through an iterative loop to fetch each list. in the web API it is getting returned as:  "childId" : [ 777 ], which i do not want it in this form i need it to be returned in the following form: "childId" : 777 , I tried to add at the end of the index, [1] and it is still returning the same form..

Hi, I noticed that, in my current Appian environment, the document ID of the file uploaded via a!fileUploadField is the same as when it is saved in the destination folder eventually.  Is this to be expected?  I was under the impression that a temporary ID is generated when the file is uploaded and the document ID is only confirmed when it is successfully saved in the destination folder. Also, is this document ID unique only within an environment?  I would like to capture the ID of the document uploaded and saved, and use it for future retrieval (via a download link). Thanks.

Hi All, I have the requirement, where on click of a button in interface the text box pop up should appear to enter text and then submit it. Can anyone please help me how to achieve it?

it does not have any English language course to work with. if there any option tell me share me its link please.

Hi everyone, I am new to Appian, and this is my first question!  What is the difference between "Create Folder" type and "Knowledge Center" type under "New" -> "Create Folder" at Build tab of Appian Designer? How to decide which one fit better for an application?Thanks!

from appian application , i will send some emails addresses to  3rd party application , that 3rd party app needs to verify those email addresses and sends the email addresses ids back .  do i need use webapi or integration for this scenarios

I have created the ETP_SyncTreatmentNotes_Cloud9  Robotic Task on the dev environment and deployed this bot to the UAT Environment but I am getting an error.I have added a robot and updated the API key in the UAT Environment and permission tags.Error: Problems (1):roboticTaskDesignObject 53537fbd-9bfd-381e-808c-a345d855df37 "ETP_SyncTreatmentNotes_Cloud9": An error occurred while creating roboticTaskDesignObject [uuid=53537fbd-9bfd-381e-808c-a345d855df37]: java.lang.RuntimeException: com.appiancorp.rdo.client.invoker.ApiException: {"timestamp":1702553011435,"status":500,"error":"Internal Server Error","message":"com.appiancorp.object.remote.rtdo.rpa.CaughtException: The robotic task [uuid=656d7a2d28c21722eacbf58d] cannot be imported because the following required precedents are missing: content [uuid=656d7d3c28c21722eacbf590] cannot be found.","path":"/rtdo/DesignObjects/IX/ObjectImportSuppor

Hi All, I am facing this issue when trying to delete a row from a table in db. Is this error caused by foreign key ?

Hello Team, I have filter the date based on the function eomonth(today(),-1) i.e last day of previous month but the fitler has type of date & time where as this function will return only in date format.I have tried to add the time to the function but couldnt able to achieve the requirement as it throwing error of miss comparison types.please help.Thanks in Advance.Error : Expression evaluation error at function a!queryRecordType [line 3]: Cannot apply operator [LESS_EQUALS_THAN] to field [createdDate] when comparing to value [TypedValue[it=3,v=11/30/20236:08 AM]].    a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "createdDate" /* this is type of Date & Time */ operator: "

Is there a way to customize the transient message, Action completed, after a form button (Cancel, Save, etc) is clicked?  For example, can we change the message to "Action canceled" after the Cancel button is clicked? Thanks.

I have an interface where there is a grid to display tasks, one of the columns is based on status (complete in progress and new) and I want to be able to filter the grid by having only In Progress and New being shown. So in other words, if the status is Completed, I would like the entire row to be removed from the grid. I thought I would have to add a new a!queryfilter but I'm not sure if that is correct or if I'm structuring it wrong. Here is the basics of what I wanted to do. Is this the correct method? Or how should I change it so it can actually accomplish what I want

I am trying to call an external URL from the record actions so that it will open up in a new tab

Hello All, I am passing data to gridField using local variable local!taskData. This local variable local!taskData is updating from the startProcess which is configured on button.Now first time I select the few records and reassign button then the data is updating into local!taskData and able to see the updated data on grid now immediately selecting another records and clicking on reassign then the values where not updating untill unless I refresh the data manually. Is the onsuccess is considering only once ? Is there any way to consider and run the a!save() everytime on clicking on the button. a!startProcess( processModel: cons!PM, processParameters: { reassignData: local!UpdatedData }, onSuccess: { a!save( local!success, fv!processInfo.pv.success ),

I will have the input like this in paragraph field ,each email per line .test@test.com test@appian.comtest@I want to validate this emails with regex function and also to check only 1 email in linecan someone help me with this

Hello all, I hope you can help me. We are regularly facing an issue with the assignment of a tasks within a process model. This happens when the process starts and, at that moment , at least one of the assigned users has its Appian account deactivated.  A real example: Process Instance started the 26/11/2023. The process is “stuck” at a task.  That task is assigned to the users within the process variable “assignedUsers”:  This variable had two values (usernames).  One of the two users was not active by that time (26/11/2023), since it was deactivated the 25th of october 2023 and created again the 13th of December 2023.  This lead to a problem, because the 1st instance of the process had no assignee. We had to run again the task, and only after we manually start it, it would have the valid assignees:  Is this a known issue by Appian? We face it a lot. This is not really convenient

After clicking on  authorize and then submit , this authorization forms disappear and original form appear I have the above interface ,i want to change this submit button to 'refresh' link like in below pic(2) .I have changed the code but in the process model it is getting stopped at that user input form. In this new interface ,after clicking on authorize and then refresh ,the authorization forms doesn't disappearDoes user input task (authorization) doesn't get submitted until submit value needs to be provided?for user input task to get submitted it should have only button not link?can someone please help

I have a main page ie; Initiating request page>In the initiating request page, we have three box layouts each boxlayout is from different interface and different datatableThree Box layouts has: 1.Request info interface (Stored in seperate DBtable - Main table for initiation request(AutoGeneratedPrimaryKey)) 2.Request type info interface (Stored in seperate DBtable)- The Auto generated Primarykey value should store for each request type row 3.RequestStock info interface (Stored in Seperate DB table) > Submit of the interface which has all the three info details In the Request type info(2), we can add multiple types like 1,2,3 for single request Initiation,Same for Request Stock info(3), we can add multiple types like 1,2,3 for single request Initiation But After submitting this page only the Auto generated ID will generate for main db table, In this case how can we add this Autogenerated it to other DB table rows(2),(3).

Hi everyone,  New to Appian, and have been working through the Appian Developer learning path. Today I ran into an issue while following the instructions for the second process model. When I click start process for debugging, I get this error message in the popup window:   I decided to continue following the steps and figure this issue out after. After creating the related action, I got another error with a bit more information: I'm not sure if both of these are caused by the same issue, but it seems like there's an issue with the Vehicle Details View. Here is the expression:  When I first created the Vehicle Details View, I got another error. After googling for a bit, I added a!documentImage() around the link to the image, but when I took that out it broke the view again. Any advice on how I might be able to fix this would be amazing.