Foundation

Hi sample Input : {a,b,c},{100,200,300} sample output : a-100,a-200,a-300,b-100,b-200,b-300,c-100,c-200,c-300

I have a condition where i wanted to do null check if either of the IDs are null it shoudn't write to database. I am using this code in task output. remove( wherecontains( or(a!isNullOrEmpty(pv!primaryId)), a!isNullOrEmpty(pv!selected) rule!NV_constructCDT( formId: pv!form.FormId, primaryId: pv!primaryId, secIds: pv!selected, ), )) Do you have any ideas to optimize this implementation? Thank you

Zuuuup, people ! So, I'm trying to execute a process in background when a user does click a button, for example. Wanna execute it without leave the page or open a new one. For now, we're using a startProcessLink and this behavior leads user to a page that goes back to home page. Any idea to manager this situation?

in an a!imageField() is there a way to remove the white border that is put around the image when it's put in the interface? 

Previously we were using a hyperlink as a record link to open up a summary view,as per the  customer's requirement the design has been restructured (not using record and record link)and currently we are using dynamic link as a hyperlink to open up a summary interface.The Problem here is that,when we use appian's inbuilt export functionality, as we are not using the record link as a hyperlink,it is just appearing as a text instead of link.Is there is any other suggestion you would give here in order to get back that link in the exported data?

As the subject line says, I've noticed recently that default in Data Input fields in different smart service nodes, the "Save Into" fields are now disabled, and this is not how the behavior worked in the past. I'm creating this thread here today because I finally noticed a place in our system where this is a bit of a blocker.  There are nodes where this was configured in the past and is now not even changeable. As you may be able to tell from the above screenshot, the "new process variable" control is NOT disabled here (but the output-selector dropdown arrow is, even though you can't tell visually).  Clicking on New PV allows you to save that input's value into that new PV, but then that output target is stuck and not changeable again (unless perhaps by adding a redundant new PV again). This really seems like a bug - if this was an intentional change then I certainly don't remember seeing any announcement for it, or mention in any of t

The task priority for the User Input Task must go to the correct outflow. But it keeps on going to bottom one ( the High Priority one ), even though I set the priority to Low. How do I configure this so that once the script task has executed, it goes to the correct outflow? Is my output correct? And this is my interface : 

I am using the Write Records smart service in a process model to take the results of a stored procedure (using the Execute Stored Procedure smart service) and update a record and the source table. When I run the process model I get the error "The input "Records" cannot contain multiple records of the same type with the same identifier". In a separate expression rule I have called the same stored procedure, tested the data and verified that there are no duplicate ids created by the expression in the id field. Can anyone tell me why Appian is giving me this error? I have attached the contents of the Records input field in the Write Records smart service.  pv!equipDataModified is a list of map with fields "equipNum", "serviceDays", and "serviceDaysPast" Thanks in advance!

HI, I am working on a daily log kind of project. So i need to 1. Take the start time and end time and calculate the number of minutes between them. eg. 6:15 am  to 8:15 am -> 120 minutes. I tried using the function  minute( todatetime(endTime)-todatetime(startTime) ) but this works only till 60 minutes. i.e. 6:15 am to 7:15 am ->0 min.  Should give 60 mins Also 2. is there any way i can only take the time as input? I have to use a!dateTimeField() Where as i dont want to get concerned with date.  Once the datetime is entered, i can use totime to get only the time. But i want the input itself to be time and not datetime.

up on a click of a button I am generating CSV file , that generated CSV file is being saved in a folder, now up on a click of another button  here I want to download the CSV file that is recently generated which is present in a folder, so How to get the document from a folder, to use in a!documentDownloadLink(), so that I can download the recent generated document

My client's requirement is to have multiple cascading filters for grid field and record doesn't support passing filter values from one user filter to another, so we are using manual filters. Hence, using OOTB record is not possible in my scenario and they want to implement the "Save Filter As" like in record as well. Please guide for efficient possible approaches available.

I'm trying to figure out the differences between Form Layout and Section Layout. Mainly, is there any reason to use a Form Layout over a Section Layout? I've been using Section Layout because I seem to be able to do everything I need with it. I understand the notion of "well, if it works for what you need, then use it". I also understand that we have the ability to nest Section Layouts (which is one main reason why I use them), but not Form Layout. However, I still continue to wonder what the actual purpose of Form Layout is for. If there is a downside to using Section Layout in lieu of Form Layout.

Hi guys, I would like to create a graphically beautiful interface for sending emails with recipients, subject and body. I don't know which object I can use for "TO:" having more than one recipient.Can anyone share its interface? I need ideas to make it happen thank you

Hi Can you guys help me with the code I am trying to give validation for the condition so for  Add client  Dropdown there should be only one active status if same occurs it should throw an validation error. The issue is I tried using whercontains but add client and is active ....data type are different so it is not working

Hello. I currently have a database table with thousands of news from different dates. I would like to create a query that brings me the news by days and by month, but not by year. For example, the news of July 4 from different years. Thank you for your help.

hii all, i have a requirement to store a request in draft , usually if i filled a form and given submit then only one request id will generate , before submit the form i want to save the form in draft mode , how would i achieve this please help me im new to appian. thanks in advance  b ramesh

How do I go about saving a file?I have the followingWhat do I need in the process model?I would have thought that this would automatically come when I press the submit button just like any other input.Is there any documentation on how to save this?I found this https://docs.appian.com/suite/help/22.4/File_Upload_Component.html, but it does not explain what you need in your process model or how to set up your database table(s)/field(s).

Hi, I have a rule input with multiple rows of data and I also have a local variable with few rows of data. Now I want to find the difference rows of data into a another local variable. Is it possible in appian.  Any inputs please.

Team, We have a start process which gets data from third party and process is scheduled to execute in every 5 minutes. If Appian is down during that period , we observed that when Appian comes online it start n numbers of same process for the time it was down. So let say Appian was down for 25 minutes , once appian comes online we see 5 process instances are getting triggered for the same process and leads to data duplication. We want to make sure that at any time only one process executing and not multiple. We thought of using timer to wait next to start process and assign random seconds to each instance but that fails if instances are more 25. Any other solution?

Hi All, i want to replicate the below section in another interface manually.  Which SAIL component can i use? 

I have a question regarding the visibility of UIT in tasks. I have tried assigning the task using process variable, individual users and also through groups. All the users and groups are part of the application and have viewer permissions. Also, I made sure to run multiple instances(one for each assignee). All the assignees are receiving the tasks but when they open it, they get a blank interface. But the same task, when opened by me is working fine.   I tried the troubleshooting mentioned in the documentation: https://docs.appian.com/suite/help/22.4/Testing_and_Debugging_Problems_with_Process_Models.html and nothing worked. The user input task in not been configured as quick task and the assigned users are part of the application and has basic user permissions(viewer). (I am new to Appian. I hope I was doing it correctly. Any help is appreciated.) Thank You. 

Hi  Expression i used is: if(todate(ri!vehicle.vehicleNextMaintenanceDate) <todate(ri!vehicle.vehicleLastMaintenanceDate), “The nextmaintenance date must be after the last maintenance date.”,null) Below message is the error i got while working on interface. Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error at function 'if' [line 59]: Invalid number of parameters, function 'if' a minimum of 3 parameters (condition,true,false), passed 1.

Hi All, I scheduled my L1 certification on a wrong time zone (Indiana) by mistake where as I live in India which follows IST. I was blocked from taking the exam since the Indian Standard Time(IST) is 10 hours and 30 minutes ahead of Indiana. Is there anything I could do to retake the same exam or Is there any other alternative for the same? Thanks in Advance!

Good morning everyone I am trying to filter the day from a recordtype that has the whole date time in the db. When I put this expression in it shows 3/19/2014 800pm edt. I just need it to show the day. How do I accomplish that? contents: { a!richTextDisplayField( value: a!richTextItem( text: fv!item [rcordtype], color: local!textcolor, size: "MEDIUM_PLUS" ) ) },

Hi, I have an interface where I am loading the data in a read only grid using a recordType and also I have a "ADD" button to provide a new item to add. Now, when the user is trying to save a text fields data, I would like to compare text fields data with a recordType fields/columns.. Can someone advise on how to compare user enter data in a text field with a recordType or Read only grid column. If user is trying to enter same data, I would like to return a validation message. Thanks.