Foundation

Hi, I am a newbie to Appian and i have been exploring the various functionalities. I have an Interface (lets' call it Interface A) that uses "Dynamic Link" to add/remove rows in a editable grid. The interface works fine when i test it out in Design/Expression mode. I also have a record type with several views. I added the above Interface A as a view to this record type. I then opened the view by going to the site but for some reason i could not add any new rows. Not sure if i am missing anything. Thank you for the help.

Does Appian application support branching, labeling, merging features using Appian versioning Manager? For ex. we want to go to previous release and meanwhile we have added new artifacts into application, will it be possible to move to actual previous application while working with Application versioning manager with Git.

Hi Community, I have a case that I add new row (Add new Goal) to my grid as the image below shown: This action is work perfectly in the interface design as the image below shown: But when I open the application, the add button don't give result. Anybody know why this happens ? Thanks in advance.

I've a requirement to make available a number of PDF documents within our UI, that the users can download as and when they wish.Initially I sorted this by saving those docs in Appian KC, along with an associated DB table that stores amongst other things the docID. At run time I simply make a call to the db table, get the doc id's and then generate the list using a!documentlnk. a!richTextDisplayField( value:{ a!richTextIcon(icon:"newspaper-o", color:if(fv!item.priority="1","NEGATIVE",{}) ), a!richTextItem( text:" "&todate(fv!item.updatedon)&" "&fv!item.message, link:if(toboolean(fv!item.islink)=true(), {a!documentDownloadLink( label:"download",document:fv!item.doc) }Works great.However I want to expand this to capture which of the docs are being downloaded and are true FAQ's vs ones that simple dont need to be taking space. Ideally I thought to use an a!saveinto and write the pertinent into to another d

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?