Foundation

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.

I am having difficulty with adding a Start Process smart service to a Process model.  My scenario is that I have a process model that runs an interface that gives the user an option of 3 things and enters their selection into a rule input, ri!userinput, then I have an XOR that amaryllises the value and directs them to the  smart service they selected and I want that to start the process model for the selection, like one is an "Customer Maint" interface, one is a "Contact Maint" and one is an "Create Event" interface. I wanted to do this via the Process Model instead of the interface but is it even an option or should I just complete in the interface?

Hello community, is it possible to set/change the value of a process variable in a scripttask/expression for example when a condition is true other than node output is stored as. I know how to set a value of a processvariable in the node output, but can it be done in like setting the value of a localvariable?example:if(pv!fruit="Apple",pv!color:"green","") Kind Regars, Erik

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

Please help me to figure oute the error - Expression evaluation error: Syntax error. Details: Expression evaluation error at function a!columnLayout parameter 2 [line 33]: Missing right parenthesis in expression, found COMMA { a!columnLayout( columns:{ a!columnLayout( contents: { a!richTextDisplayField( value: ( a!richTextIcon( icon: ri!icon, size:choose( "LARGE", "MEDIUM_PLUS", "MEDUIM" ), color:cons!DU_CHART_COLOR_HEX_CODES ), ) ), a!richTextItem( text: " " & ri!label, size:choose( "LARGE", "MEDIUM_PLUS", "MEDUIM" ) ) } ), } a!columnLayout( contents: ( ri!extraComponent ), width: if( ri!isSectionFullPageWidth, "WIDE", "NARROW_PLUS" ), showWhen: not( isnull (ri!extraComponent )) ), a!columnLayout( width: "NARROW" , contents: { a!richTextDisplayField( labelPosition: "COLLAPSED", align: "RIGHT", value: ( a!richTextItem( text: ri!linklabel, style: "STRON

The available options on escalation are : reassign, change priority, send alert and send message.  I cannot see an option to execute a script in the same process model.  is the only way creating a different process  (and send message) ? 

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 all, I Need to display static value in the text field and same value should save into one more variable , Please advise. load( local!getTexfieldValue, { a!textField( value: "abc", saveInto: { a!save(local!getTexfieldValue,save!value) },),a!textField( value: local!getTexfieldValue,)}) Regards Pallavi N

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

Hello Everyone, I had a requirement that I had a requirement of transactions like (to transfer amount to one account to another account) I am able to do the transactions in Interface but How can I save that Values to the particular field in another record. Can anyone help me with this? Thanks in ADVANCE a!localVariables( local!result, a!formLayout( label: "Transaction", contents: { a!columnsLayout( columns: { a!columnLayout( contents: { a!floatingPointField( label: "Available Balance", labelPosition: if( ri!readOnly, "ADJACENT", "ABOVE" ), value: ri!COB_Applicant.kycid.transaction.availableBalance, saveInto: ri!COB_Applicant.kycid.transaction.availableBalance, readOnly: ri!readOnly, disabled: false ) } ), a!colu

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 Team, Could you please help me in converting the following code into Foreach() if( isnull( local!region ), if( rule!APN_isEmpty( tostring( index( local!userlist.data, "regionId", {} ) ) ), if( rule!APN_isEmpty( tostring( index( local!userlist.data, "lobId", {} ) ) ), if( rule!APN_isEmpty( tostring( index( local!userreg.data, "regionId", {} ) ) ), {}, local!distuserregname ), null ),

Hi Team, we have modified a field (lobId) from normal to an array type (highlighted below) In an interface, I'm getting the following error: The error I'm getting at the following code. line_of_business: if( isnull( local!line_of_business ), if( rule!APN_isEmpty( tostring( index( local!userlist.data, "lobId", {} ) ) ), {}, tostring( rule!CTR_QE_getLineOfBusinessById( lineOfBusinessId: tointeger( tostring( index( local!userlist.data, "lobId", {} ) ) ) ).data.line_of_business_code ) ), local!line_of_business ), If i send the values manuall

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  I have observed two issues with hierarchyBrowserFieldTree. Any thoughts/suggestions are helpful.   1- if we want to narrow down the data by applying some filters, Its not refreshing the nodes but the nextNode counts are getting updated. 2- in the hierarchyBrowserFieldTreeNode attributes, showwhen attribute is not doing its job when we want to set false based on some condition, Interface is throwing an error. It can be tested easily with appian given example. a!localVariables( local!path: {5,2}, a!hierarchyBrowserFieldTree( nodeConfigs: a!hierarchyBrowserFieldTreeNode( showWhen:not(tointeger(fv!nodeValue)=0), id: fv!nodeValue, label: "Node" & fv!nodeValue, description: "Description for node " & fv!nodeValue, details: "Details for node " & fv!nodeValue, image: a!documentImage(document: a!iconIndicator("PREVIEW")), nextLevelCount: fv!nodeValue ), pathValue: local!path, pathSaveInto: local!path, nextLevelValues: en

 When I select the items in the grid and click on the button in the background the process model should trigger, and it must complete successfully, But when I click the button instantly twice or thrice immediately another process model is triggering the items which have selected becomes duplicate in next section. So, Here race condition occurs. Actually, we tried to restrict that button not to click it a second time by the user. The problem is before writing to the DB by the first process model in the fraction of seconds processes model also. In the interface, we are passing the selected items through the start process and try to capture the output. But nothing works. Let me know is there any way to stop the race condition either in an interfcae or process model

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.