Foundation

I have an app for site surveying equipment that produces a task which is going to be completed primarily on mobile, often offline. Since the task could take multiple days to complete I added the 'Save Draft' button to the interface from the process model. On desktop it works as expected, I can hit the save draft button, exit the task, then go back in and pick up where I left off with all the previous data still there. However, on the mobile Appian app, when I hit this button the data is saved properly, but the task then closes. Since I experience the occasional app crash with the Appian mobile app, I would like to be able to save my work periodically without having to exit the task each time. Is there a way to prevent the 'Save Draft' button from closing the task in the mobile app? Thanks in advance!

Hi Readers, Needed an insight regarding the below. I need a variable holding a single value, which can be updated through an action when a form is submitted; But it need to be visible in the form but as read only. What i have tried: I have kept a read only grid to make it as read only, instead of a temp variable i have queried the data from a table and made only single row is visible so that the last updated value is visible. But i do not want the value to save  in a table and query it to make it visible on the form, instead i just need a temp variable which holds the last updated value as read only. Elaborated: I Am trying to create an application which has a read only variable on the form called wallet balance(); Application: There will be an interface/form which has wallet balance, current value and operation and a submit button; We enter the wallet balance by seeing it in the read only grid, we enter the value which need to be added/deducted from wallet and an operation(+ or

Hello, I am implementing an excel sheet to appian forms where the excel workbook is having two sheet (sheet1 and sheet2). To replicate this, I have created form1 and form2 with individual table for each form. I am passing 2 CDT as record input from form1 to form2 and then to form1. The Main form (Form1) have link to open Form2 where the user will input data on the fields and click on the  "go back to form 1", then when submit is clicked on Form1, the data in both the CDT will be stored in to DB tables. I have kind of achieve this and the data is also saving as expected but the problem is it opening new session of form and the old is still opened in the background. I am using linkfield and startProcessLink to pass CDT data and open new forms. Please help me to close the form before calling the next form. Code and screenshots below. Current Scenario: Record type (Add Record Link) --> Form1 (Fill data and click Open form2) --> Form2 (Fill data and

Hi Readers, I have a normal form as an interface which when submitted the data need to be stored in a database. I have done everything and the form and database is also working fine now, but when i start the process debugging and initiate the process with the form which i created the data is getting inserted in to the database but the color of the nodes are not changing; but  when i press cancel button the node colors are changing Could you please provide your insights or my mistakes or any checklist that is used to check and fix this issues  NOTE: The application is working fine, i mean the data is inserted into the table and is queried for another report purposes. When clicked on submit/cancel while process debugging get below

how to give action to the Icon, such that onclick it should add the card layout above the icons column layout?

I have process with multiple approvals. Manager approval i had to give condition in XOR  that the tasktype is modified and particular field is changed then it should go to   Admin approval.Otherwise it should skip the Admin flow. i have given this condition in XOR:  if  = and(pv!approved,or(pv!tasktype=con!MODIFY_TASK,pv!segemnt.serviceDate - true -goto-AdminApproval, Else if =pv!approved-true-go to join else if no rules are true - go to - accontant. Thanks 

Hello all, Is it possible to customize a dropdown list of values with Group name as some header values and group members listed seperately withi the dropdwonlist  as shown below? In this eample, user will be selecting only the vehicle model(group member) and not the vehicle type(Group name). Appreciate any help in getting this solved, thank you!       Select a Vehicle SUV    RAV4    Model X    CRV    X5    GLA Sedan    Model 3    Camry    Civic    E-Class Hybrid    XSE    GT-Class    X5 PHEW

I am new to Appian. Still learning the basics. I have two tables 1. Attachments - for adding attachment relate details like fileId,fileName, fileExt, fileSize etc and 2. AttachmentDetails - for description, comments etc Below is the requirement - When i upload a document I save them to the attachment table with attachmentDetails primary key (attachmentDetailsId) After the documents are saved in the attachment table I need to save the attachment tables primary key (attachmentId) to the attachmentDetails table The problem is i am not sure how to update when there are multiple attachments. For Example - If i  upload 2 attachments and update attachmentDetails Attachments Table attachmentId fileId attachmentDetailsId 1 123 1 2 234 2  Attachment Details Table attachmentDetailsId Description attachmentId 1 Evidence 1 2 Tracker 2 I will first save the 2 attachmentDetails (array) to the db first. (at this point attachmentId will be null and I will have the attachme

dependent and precedent errors in exporting application

Hi,  Am using Send email smart service to send email from process model. Have inserted a web image along with some text in the body of the email. Have the following issues: 1. While configuring the process, the image is displayed correctly but when an email is received the image is not being displayed correctly. 2. Instead of using Web Image, is it possible to use image stored as an Appian document ? Thanks in advance. Vikrant.

Hi we have a textfield where we perform validation  by calling a webservice query.  validations are working fine when i test it from interface in designer mode. When i test from site, it throws below error. An error occurred while executing a save: Expression evaluation error in rule at function 'webservicequery' [line 13]: Could not parse WSDL inside saveinto of the textfield a!save(local!result, webservicecall), validation:if(local!result,"","Please enter valid date") CAn we call webservice query in saveinto? Please advice

Hi Team, I am getting special character i.e ";" in empty field, how to remove the special character and save the value? Already tried stripwith() and it is not working as expected.

Hi Team, I have an excel template in which i need to map values to the particular cell positions like {B2,B3,B4,E2,E3}; that are being retreived from a table. I am getting all the data in single row currently even after giving the cell keys. Any suggestion? Thanks Anandita

Hi, I updated multiple records at the same time, I test "Rule!" it working fine. I also "enable activity chaining", but it did not update username properly but updated as "Appian Administrator" do you have any suggestion? Thanks,

Is there a way to query up who is assigned to a particular task? I've got a process report, but I'd like to somehow pull the assignee for a particular task out of that for use elsewhere. What is the best way to do that? 

As you can see on this attachment a scroll bar is appearing when displaying a rich text edited field.  If I go in and remove a couple of lines of text the scroll bar goes away.  Does anyone know why this scroll bar is showing up?  It does not matter how big the area field is in it always shows up. For example, I can remove the last sentence and the bar goes away.  So it seems to be tied to a character count.

Noticed something strange when using the datetext() function on dates near the end of December.  Using datetext() on dates December 27th or later display the next year rather than the correct one.  Example below... a!localVariables( local!dateDec25th: date(2021, 12, 25), local!dateDec27th: date(2021, 12, 27), { dateDec25th: local!dateDec25th, dateText25th: datetext(local!dateDec25th, "M/d/YYYY"), gmtThe25th: datetext(gmt(local!dateDec25th), "M/d/YYYY"), a: "********", dateDec27th: local!dateDec27th, dateText27th: datetext(local!dateDec27th, "M/d/YYYY"), gmtThe27th: datetext(gmt(local!dateDec27th), "M/d/YYYY"), aa: "********", toDate25th: todate(local!dateDec25th), toDate27th: todate(local!dateDec27th), gmt: todate(gmt(local!dateDec27th)) } /**** The above returns... dateDec25th: 12/25/2021(Date) dateText25th: "12/25/2021"(Text) "********" dateDec27th: 12/27/2021(Date) dateText27th: "12/26/2022"(Te

Good afternoon, We used the node Send File Over SFTP (com.appiancorp.a2.process.runtime.activities.sftp.SendFileOverSFTPwithSCSUsernameAndPasswordV2) Later we updated to version 2.2.1(Send File Over SFTP (com.appiancorp.a2.process.runtime.activities.sftp.SendFileOverSFTPwithSCSUsernameAndPasswordV3) and since then, passing the same values ​​in the input inputs, the shipment no longer occurs and gives us the following error: Does anyone know if anything has changed? A greeting and thanks in advance

Hello, I am trying to achieve below 2 things and need your help please. My form consists of 5 fields (ClientName, SubmittedBy, SubmittedDate, isSaved, isSubmit) which will be save into to DB table. 1. Form is having 2 buttons save and submit. On click of Save, it should save all the 5 fields with isSubmit=false in the database and the form should not be closed. On click of Submit, the isSubmit=true and the form is closed. 2. How to create a reusable function which is called from both Save and Submit button. That function should have the a!save code which will save the fields accordingly. The below 3 lines are called in both the buttons and based on from which button is called, it should save fields.                              fn (isSubmitClick) {                                              

in my database i have time in 24 hours format for example "8:00". when i create a query for this datetime what i receive is   a result with four hours difference how can i achieve to get it in the same time zone  as the database

My scenario is to check the date past 45 days.  todate(now())-local!creat_dt return intervals(days to Seconds). How to retrieve Days from it. Or is there an other solution to find?

Hello, I am getting the below error when querying a particular table from the application. The entity I am querying is a nested CDT.  Expression evaluation error in rule 'dcm_getproductbycaseid' at function 'queryruleexec': Error evaluating function 'queryruleexec' : Error converting query output (rule: [DCM_getProductByCaseId], type: [DCMCaseProductDT3274], objects successfully converted: [0] Server Log file Caused by: com.appiancorp.suiteapi.common.exceptions.AppianRuntimeException: com.appiancorp.suiteapi.common.exceptions.AppianException: Error converting query output (rule: [DCM_getProductByCaseId], type: [DCMCaseProductDT3274], objects successfully converted: [0]) (APNX-1-4164-025) at com.appiancorp.type.external.teneoimpl.QueryRuleExceptionHandler.handle(QueryRuleExceptionHandler.java:50) at com.appiancorp.type.external.teneoimpl.TimedWorkRunner.run(TimedWorkRunner.java:62) at com.appiancorp.type.external.teneoimpl.TeneoQueryExecutor.execute(Te

I am a beginner working on the Appian Developer course and while creating a process model had an issue with a Write to Data Store Entity node.  Details of my error: "An error occurred while trying to write to the entity "AX_Maintenance" [id=a715498b-834b-4663-914f-c2b5b2246cf3@3764, type=AX_Maintenance (id=3832)] (data store: AX Data Store). Details: org.hibernate.PropertyValueException: not-null property references a null or transient value: AXMaintenanceDT4982.vehicleID Data: TypedValue[it=3832,v={<null>,<null>,2022-01-28,0,test,Scheduled,<null>,<null>,<null>,<null>,<null>" Process Model: It looks like the issue is leading back to the AX_Maintenance Data Type that was created as part of Exercise 9 in the Appian Developer course - same exercise where this process model is later created. Instructions: This Data Type is used for two interfaces and connected to a Data Store as well. Status says problem with task.  

Hi Readers, I have a idea to make an user interface with a form and a read only grid at top right needed insights and what would be required to do this,  The form contains a box to enter the value(int) and a drop down with two variables sum and sub, the read only grid has some value let the initially value would be 0 for suppose. when i enter the value as 10 and select sum and submit then it need to be added to the value present in read only grid and change it to 0+10 -> 10(read only grid value),  when i enter the value 5 and select sub and submit then it need to be substracted from the value present in the read only grid and change it to 10-5 -> 5(read only grid value) Just wanted to know how we can do this happen and what all needed to do this happen. Thanks readers, will be waiting for your insights/ideas/answers

How to send Interface rule input value to the Expression Rule?