General

Hi Everyone,  I need help on the below issue :  We have a dependency between two screens, so  in the first screen we enter an XYZ fields and save it and depending on the Role what we select in the second screen we get the XYZ fields of first screen what we entered and then save it. The problem here is , after saving it, when we navigate to the first screen, XYZ fields values are not displaying. It will display after refreshing it or if we wait for few secs. Kindly let me know is there any way we can display without refreshing the page.

Hi Team, I was not aware about the archive task thing, I lost many tasks . I need those task back or see them. Any way to do that?

local!a:toInteger(20),document(local!a,"id") works, but when Replcaed local!a with ri!Table_Name.docId getting error, How to fix? a!linkField( label: "Link", labelPosition: "ABOVE", links: { a!documentDownloadLink( label: "Document Link", document:document(6802,"id") -->replced 6802 with ri!Table_Name.docId gets an error ) } )

Hi All,        I am getting the below mentioned error in Grid field when i try to submit the form. Expression evaluation error [evaluation ID = N63DMP1Y] in rule 'A' (called by rules 'B' > 'C') at function a!gridField [line 62]: key. Request to provide reason for this error occurrence. Thanks in Advance Pradeep.B

Hello, I have the following list of strings coming from a query:  List of Text String - 4 items"user1"(Text)"user2"(Text)"user2; user3"(Text)"user4"(Text) How  I can sort that so the final result will be list of strings of only unique values:  Result:"user1"(Text)"user2"(Text)"user3"(Text)"user4"(Text)

Hi All, Is there a way to edit / update / modify the text inside the word doc template in Appian by the end user apart from the parameters passed. Any help is appreciated. Thanks, Pramod.

Hello community, Is it possible to add values from a list of string of string to fields where string 1 of the list maps to field 1 of the CDT, sting 2 to field 2 of the CDT etc.When I pass the list of strings to the CDT as a parameter in the expression it passes al the strings to field 1.I want to make the expression dynamic, so for example looping through the list of strings and add them to CDT field 1, next CDT field 2 etc.I do not know how to set the values of the CDT fields based on their index. All the fields in the CDT are of type text.To illustrate for example CDT Alphabet with fields Letter1: "", Letter2: "", Letter3:"".List of String{("A"),("B"),("C") etc.Now I want for the length of the string, adding A B C to Letter1, Letter2, Letter3 using a Loop. (is it possible to use index of CDT field instead of fieldname?)My second question is, is it possible to just add the whole list as a parameter when I cast it to a certai

Hi everyone,I apologize if this question has been asked before, I just got started with Appian and have been tasked with implementing the web API with our PHP website. I looked at the documentation but English isn't my first language and I find it hard to follow. Are there practical examples of web api with PHP I could see? It would be really helpful.Thank youBlumenversandMihail SchweizerZürich

Hi, i have written a query filter which is working fine and displayed that in interface. Now i need to download Excel which is also working fine but i need not have to include option: best Suppose i have a drop down field which contains values: Good, better, best. But when i download Excel i should not see best option in Excel(instead it should be blank ) ..but the value in complete row should be downloaded.  applyWhen: {rule!AAP_isNotEmpty(ri!Status),remove(ri!Status,wherecontains("best",touniformstring(ri!Status)))} Can someone help with what change i should do in code

How to define the expression rule for site accent color? what should we consider for decisioning? As per the system,  The accent color is used to highlight key interface elements. Avoid grayscale colors (black, white, and gray) that are similar to colors used for interface elements and green/red that are similar to colors used to indicate positive/negative values If I want to conditionalize the colors for links, grid row highlight, etc, how should we define the conditions?

what does rv!identifier is ? when and how to use it. Please give me an example.  I am not able to understand in the documentation

Hi, I'm facing a performance problem on a queryEntity.The query is done on a DSE mapped to a view in an external SQL Server database.When connecting to the DB through a client, a SELECT query with a couple of WHERE conditions takes less than 5 seconds, but when done through the queryEntity, it takes more than 10 seconds and causes a timeout in Hibernate. The environment is in cloud, so the timeout can't be overridden.I'm looking for ways to debug this discrepancy in timings.Here's the code (in reality there are 5 filters). I tried setting fetchTotalCount to false to improve performance, the result does not change. a!queryEntity( entity: cons!EXTERNAL_VIEW, fetchTotalCount: true, query: a!query( pagingInfo: topaginginfo(1, - 1), logicalExpression: a!queryLogicalExpression( operator: "AND", ignoreFiltersWithEmptyValues: true(), filters: { a!queryFilter( field: "field1", operator: "=", value: ri!value1

My users want an email link in a UI, that when clicked opens Gmail.com in their browser, and if signed in to Gmail already, opens a draft email window with the email address from the link.Currently I am using safelink, and it opens the default mail application on the user's computer.  However, they want it to always go to gmail.com regardless of the default mail app. Is this possible?Here is an example of the code I am usinga!safeLink( label: "example@example.com", uri: "mailto:example@example.com" )

Hi All, We have requirement where we need to reassign a task from One user to another user in Bulk? How we can achieve this in 18.3 Version? Any help will be appreciated. Regards, Sarvesh

Hi All, We have requirement to remove list of users from All the groups whichever they belongs to. How we can achieve this in Appian 18.3 version? Any help will be appreciated. Regards, Sarvesh

I have an ID.  It's currently an integer. I want to know if there's a Document with that ID, or if there's a Folder with that ID.  Why?  Because if I guess and try to put it in the document() function, it will crash if it's a folder.  If I guess and try to put it in the folder() function, it will crash if it's a document. I've tried plugins, but the plugins have a super fun tendency to throw lots of Java errors destroying our logs whenever we try to find out if this stupid thing is a Document or a Folder. Is there a way to do this out of the box?  I want a rule that receives an integer and outputs the word "Document" or the word "Folder" or the word "Neither" and DOES NOT PINK BOX no matter what integer is.

hello,   I need to upload file by make submit : true() , for submit button . but i do not want to refresh the interface. is it possible? 

Hi All, Could someone answer my all the below questions/doubts? Ques 1: At what phase Import Customization File are clubbed while performing Compare and Deploy (Not Manual)?Because I did not see any options for the same as I can see for objects/database scripts  and pug-ins. Ques 2: When a stored procedure is used or when views are used or when Materialized Views are used in Appian and why they are used? Need scenario Based examples!. Ques 3: What is main reason we need Reports and Records separately in Appia (Because can display data)? Ques 4: When we have duplicate rows in a DB except their Primary Ids, then how can we return a complete Unique Row using a!queryEntity() function or any other functions. Ques 5: What happens to the pending Process instances if the current Process Model version is changed to newer version? Ques 6: What are the differences we will experience or when the system migrated to cloud from in-premises? Ques 7: What impact will be on running processes if w

Hi , Can we update Appian userid of the user? Thanks

Hi All, Hope you all are doing well. There are two user accounts in Appian :- 1) aamir_khan 2)aamir.khan So when aamir.khan updates his profile picture ,from change profile picture in his account , The picture gets updated for both the account .The aamir.khan and aamir_khan  both will be having the same picture. Can someone please guide further to rectify or look further into this issue , it will be very helpful. Thanks in advance. 

Hi,  I'm trying to create an email template for outlook using the following code snippet,  a!safeLink( uri: concat( "mailto://", ri!email, "?subject=", "Random Text", "&cc=", "abc.com", "&Body= Hello", ) ) I have to add the company logo in the signature of the email body, can someone please let me know if this is possible? If so, direct me on how to do implement this.  Thanks in advance. 

local!vehicleBaseLocations: append(local!vehicle,"ALL"), I have written a rule and called that in local!vehicle(i am fetching data from DB). Am calling that in local!vehicleBaseLocations,I need to add ALL option also, I have used append to achieve it but its throwing error "  Could not cast from Text to AB_location. Details: CastInvalidCould not cast from Text to AB_location. Details: CastInvalid  Can someone help what exactly am missing

Let us say I have array of dictionary    {{id:1,name:"Faisal",department:"EEE"},{id:2,name:"Hasan",department:"E&E"}, {id:3,name:"Faridi",department:"E&C"}} and I want  to return id and name only based on department="EEE" How can this be achieved using functions? I have tried the below but not able to get the result and from this query I am able to return only one field. a!localVariables( local!employees:{ {{id:1,name:"Faisal",department:"EEE"},{id:2,name:"Hasan",department:"E&E"}, {id:3,name:"Faridi",department:"E&C"}} }, a!forEach( items: local!employees, expression:if(fv!item.department="EEE",fv!item.name,{}) ))

Is it possible to add attachments to 'mailto://' while generating email popups for Outlook?

Provided the getdatasubsetdownloadlinkfromrule plugin is no longer available, do we have any alternatives to export datasubset into excel