Foundation

how to find difference of minutes between 2 time parameter. For example i have StartTime: 6:00 PM, and EndTime: 7:30PM.

I created an expression rule for a summary view of a record. I have an expression rule calling all the information needed within a view DSE constant. When prompted with the error, after clicking "Okay," nothing happens. Is there a way to edit this rule without drilling into the record?Here is the modal:

 Hello, I created a post-deployment process model in the Dev environment and deployed it into a test and my deployment status is failing. Is there anything I have to modify the code before deploying into the test, I followed the configure post-deployment in the documentation.  Can anyone suggest to me the steps to follow for post deployment.

Hi, i am using multidrop down field , i want to update my new values into local variable first then i want to update into my rule input without effecting the rule input  values when it is in editable condition and i have tried using the local variable but it is not getting store, can you guys guide how to solve this a!multipleDropdownField( label:"Pets", placeholder:"select a value", choiceLabels:index(local!pets,"petsNm",null()), choiceValues:index(local!pets,"petsId",null()), value:if( ri!isEditable, ri!pets.petsIdFk, local!pet ), saveInto: if( ri!isEditable, { a!save( local!addition, a!forEach(

Why we are using .@attributes.@anyAttribute._recordRef in the below rule and what is the need for using it in that rule. cons!COM_ENV_TXT_SITE_URL & cons!CLM_TXT_RECORD_URL & a!recordLink( recordType: cons!CLM_RECORD_REQUEST_DETAILS, identifier: ri!requestId, dashboard: ri!dashboard).@attributes.@anyAttribute._recordRef & "/view/" & ri!urlStub

Hi folks , I have a look up  table named "gender" , I want to develop a interface using which i can see,  add add, update , delete values in table without going in the appian cloud directly instead we want to perform this from the interface . For example i have genderId and gender column in lookup table , where there are two entries male with id 1 and female with id 2 , how can we add another gender in the table  directly or delete male row  from the table or update it. I hope you guys understood my query . Thanks in advance. 

Hello, As mentioned in the title, I have an SQL table that has a JSON type column. When I query it using a!queryEntity() in an expression rule, the resultant datasubset returns all the fields EXEPT the JSON field.  Do I need to take special measures when I deal with a!queryEntity() when it comes to JSON fields?  Thank you,

I am using a!recordLink() inside Editable grid row configuration : a!gridRowLayout( contents: { a!linkField( links: a!recordLink( label: fv!item.ID, recordType: cons!REQ_RECORD, identifier: fv!item.ID ) )} After clicking on the ID column link field I am getting below error: An error was encountered while processing your request. Could you please help me how can I configure the a!recordlink() field inside the editable grid row configuration.

Some of the nodes of process model are getting stuck . 

Is there limitation to add viewss on appian records? If i add more than 30 views on appian records it will affect on the performance?

I have a form has 5 rule inputs as follows:     1 CDT variable, 3 Text variables, 1 Integer variable.     According to best practices, how many process variables are required in the process model to Input Task?

Hi All I am working on version 21.2. I have a requirement, wherein if my process takes an exception flow, I need to send an email notification. This email should have a link to this process instance. I think a process task report should be made which should have one of the columns as below: Kindly let me know if this is the appropriate way of doing it, then how to proceed further. Also if there is some other way of achieving the requirement, kindly let me know. Thanks in advance!!

Hi, I have a requirement where i have to calculate the Business Day of a particular Date in a Month. The calculation happens from 1st  of every month. Basically my requirement is  opposite of workday(), in workday() business day is passed and it provides the date. Here i have the Date and the Business day has to be calculated. Thanks in advance

Hello, I would like to implement a "set" data structure in appian.  My use case prefers a "set" data structure as opposed to a list or dictionaries, because a set only contains unique values, or in my use case, unique sets.  I tried to search in the documentation, but to no avail. 

Hi All, is it possible to create a close button on a record page to close current browser window tab? or is it possible to do something like " window.open('', '_self', '').close(); " at Appian UI page? thanks, Gaurav

Hi I have an interface with load and with, when a user updates a value in the interface I need to return a boolean value and I am using that in another rule. In the load I have a local variable in which I am saving the old value and in the with I an doing a isnull(symetricdifference9oldval,newVal) and assigning this to a local variable and passing this to the other rule.  I am having an issue in setting the boolean value please advice me here.  Thank you. 

Hi Team, We have created Dashboard using Angular , user can view task summary and an Appian task link is available to user to work. we have a requirement to display closed task details and status of the instance to user.  Please can you suggest how to create and get a closed task link at Appian. Thanks, Gaurav

Hi, In our application users have initiated actions many times to upload a file due to some integration issue for file upload. Issue has been resolved. Now the support guys have been asked to trigger the instances from Monitoring. Now the problem is if we trigger blindly without seeing we may end up running multiple instances for same file upload and it may lead to file duplicate issue in the integrated system. Could someone tell easy method to trigger only one instance for the same request?(I do not want to open each instance and see and then run. It will take time) Thanks Faisal

Hello, Is there a way in appian where I can search a list of dictionaries for any item in that list that meets a specific set of properties For example, say I have the following list: {{storeNum: "003", taskCode: "A", numOfTasks: 1292}, {storeNum: "003", taskCode: "B", numOfTasks: 5}, {storeNum: "003", taskCode: "C", numOfTasks: 8}, {storeNum: "003", taskCode: "D", numOfTasks: 5}, {storeNum: "004", taskCode: "A", numOfTasks: 208}, {storeNum: "004", taskCode: "C", numOfTasks: 2}}  Now, I want a function, that when I feed it a storeNum and taskCode, to return to me the numOfTasks if it exists in the list, and returns 0 (or any indication) when no dictionary items with the specified combination of storeNum and taskCode exists in the list.  for example, if I call function(storeNum: "003", taskCode:"A") it will return 1292 Ho

Hi Team, We have usability styling requirement from client like Read-only grid header row should have some styling like backgroud color, font etc. Is there any way we can achieve through the latest Appian version. -Thanks in advance

Hi All,     What is the best practices for Interface and CDTs?

Hi, i have created external data source by using appian admin console. post creation i trying to create CDT for the existing postgre SQL Data base table. below warning are populating due to data type miss matched. can some one suggest me how to overcome this problem ? we are using external DB(PostGres Databae)

When you are trying to copy the value from the output of the expression editor the screen will sometimes scroll up to the top of the result set. I know this seems petty, but it makes it really hard sometimes to grab a value and requires multiple try's.  Pics posted as an example.

Hi all, Our main GUI team member is concerned about the icon that shows up next to the selected usergroup when it is picked from the Group Picker.  It appears to be a group of silhouettes, representing that there are multiple users.  We are looking for a way to remove this picture or icon. If it isn't possible, we would prefer to use the group icon that Designer mode uses: There isn't a call for our application to configure individual groups' profile pictures or special icons. So are there any alternatives to the silhouette icon? Thank you!