General

Is it possible to create a dynamic Excel in Appian? Let me describe the challenge I am facing. I need to create a dynamic Excel in Appian that would have 10 different tables, each of which is displayed based on dynamic input (list of IDs 1,2,...10), possible scenarios a) If we pass 1,2, and 10 the tables with serial numbers 1, 2, and 10 should be displayed, b) if we pass all numbers, all 10 tables should be displayed,  c) If we pass numbers from 1 to 5, only the first 5 should be displayed and so on. An example of the code we used to generate the Excel: local!dictionary: cast('type!{www.appian.com/.../2009}Dictionary', {}), local!dataExport: a!forEach( items: local!labelValue, expression: reduce( fn!insert(_, _, _), local!dictionary, merge( index(fv!item, "data", null), index(fv!item, "value", null) ) ) ), 'type!{urn:com:appian:ps:excel:types}ExportableDataSubset'(fieldLabels: index(local!labelValue, "label", null),fieldNames: ind

adding if condition in the label parameter of grid column, if local!docids are not available then column should be blank and otherwise Uploaded documents. Can you please help on this. Thanks for your thoughts on this.

I have developed an Appian application in my environment (release 24.4) and I want to import it in an older environtment (release 23.x). I supose that the newer objects will crash but the old ones will run? Thanks in advance.

Hi , Recently i came across an interview question like how you will save and display different questions for different group of users in UI ? So have two doubts regarding this question, as follows Is this kind of use case exists in real time? Is there any best practice/way for achieving this? Requesting suggestions from everyone. Thanks in Advance, Pradeep

Hi All, One of our requirement is to merge the data from two applications into one. Both of the applications are created in same Appian instance and database is Appian cloud.  One of the application uses default Appian schema whereas other one has it's own schema under Appian cloud. This schema is already added to Admin console. Now we need a way to connect this two schemas to be able to merge the application, is there any way to do that?

Hi People,   I have input task USD 12345789. I want to put comma between the amount based on currency and I want output like USD 1,23,456.89. I tried several logics but not worked and output is USD1234,567.89. Can anyone help me? Thanks in advance. 

I am working on a process model where I use an integration to call an API. The API contains about 82,000 records, but it returns only 100 records per request. To retrieve all the data, I use a loop. After each API call, I save the 100 records using a record type. Does this slow down the environment if I delete the instance after every successful run?

I have to build a new application that is similar to another one so I wish to clone the application with another name in the same environment. How can I do it? Thanks

I have all admin rights. On process modeler if I try to edit any node on "edit process view" I only have the "node properties" option. If I try the same with other user I can edit it with no problem. I tried on incognito mode, clearing cookies, different computer, change to basic and again to admin rights... I can only solve the problem creating a new user... but that would not be the right things. Any suggestions?

What does memory used % represents in the Appian cloud support site? We have 3 servers in prod and one of them is having around 68% memory used. But in Appian health check report, its showing as 1500MB which we are assuming its pointing to RAM. If only roughly 2gb is occupied by instances, what does the remaining memory is taken up by? We have 75 gb ROM memory for each server and 32gb memory for RAM. Any insights will be helpful

Hi Community, I am considering installing Appian in Self-Managed environments (AWS/Azure/GCP) instead of using Appian Cloud. I would like to know which features are not available in Self-Managed environments. I have learned that AI capabilities, Process HQ, and Portals cannot be used in Self-Managed environments. However, are there any other features or functionalities that are also unavailable or restricted compared to Appian Cloud? I would appreciate any insights or official references regarding the limitations of installing Appian on AWS, Azure, or other cloud providers. Thank you in advance for your help!

According to functionality whenever someone initiate the process then we have schedule work order task in which we need to provide the issues with the property and assigned them to the vendors/technisians,After scheduling the work order if your price is above then 500 then that task goes for approvals(We have to completed 5 approvals to pass that task to the vendor). But in task report when i assigned the task for approvals then it is showing list of taskassignees name but according to my requirements i need to show group name. So i have created a condition as per the task, but my question is can we add this below code in the task report or not. a!localVariables( local!getScope: rule!TSW_getScopeByID(SCOPE_ID), if( index(local!getScope, "Status", {}) = "Approvals", a!match( value: rule!MP_getRequiredApprovalLevelByProjectTypeNID(SCOPE_ID), equals: cons!TMP_APPROVAL_ROLE_LIST[2], then: cons!TMP_APPROVAL_ROLE_LIST[2], equals: cons!TMP_APPROVAL_ROLE_L

Hi All, I have two APIs right now. POST webAPI and GET Webapi. --POST API is taking two query params as input, doing a start process and returning some url in its body. --In GET Api i want to fetch that url from POST APIs body. How can I pass the params to POST Api from my GET API to fetch the url as response in GET API? Here is my current implementation in GET API: a!localVariables( local!httpRequestBody:http!request.queryParameters, local!FormId: if( rule!GEN_IsNull(local!httpRequestBody), null, local!httpRequestBody.FormId ), local!formToLaunchParameters_txt: if( rule!GEN_IsNull(local!httpRequestBody), null, local!httpRequestBody.formToLaunchParameters_txt ), if( or( rule!GEN_IsNull(local!FormId), rule!GEN_IsNull(local!formToLaunchParameters_txt) ), a!httpResponse( statusCode: 500, headers: a!httpHeader( name:"Content-Type", value:"application/json" ), body:a!toJson( {

Hello, I'm facing an issue while exporting the package, it's showing as in progress since a long time, Has anyone encountered the same issue before? pls let me know. The package has a single object to export. Thank You!!

Hi Team, Appian seems down for me https://us.appian.community/ Getting below maintenance Page, would be helpful if you can help ETA for restoration

Hi everyone,I’m signed up to the Appian feed on Sprout Social https://advocacy.sproutsocial.com/feed (formerly Bambu). It’s been a great source for Appian articles. However, I have no idea how I signed up originally and no idea how to have a colleague of mine sign up as well. In my personal settings I'm not an admin, team lead, or anything like that.Please could someone assist in the steps to have a colleague of mine sign up, so that they too can access the Appian feed on Sprout Social? Or is as simple as creating a Sprout Social account and searching for Appian?Many thanks.

log file name where all user data exist which contains when user got created and deactivated.

How to get an Active and Inactive users in appian .. also what was the time when  they got deactivated.

Hi  Team, I am trying to generate the excel with 100 columns in the same sheet. Since there is a limit of 50 columns per sheet I am trying to use the same service two times so that I can generate the required columns. But the issue is it is either generating the remaining 50 columns in the separate sheet or replacing the first 50 columns with the second 50 columns. Is there a way where i can generate all the columns in a single sheet? Thanks

It has been a missunderstood because I scheduled the exam for today 12 AM but in my country 12 AM means at the morning, not at the evening so my boucher is no longer valid to take the exam anymore. Do you know if is there any solution to reschedule the exam to another day with the same boucher? Right now, the state of my exam is "Not show" and is not longer valid. Thanks in advance.

im executing a process that is returning this i dont understand why there is a comma before the result of the map which is returning errors in other nodes how can i fix this?

Hi All, For any reason I can't imagine, if you run this instruction in a rule; fn!extract("<a>some text</a>","<a>","</a>") you will get {"some text"} as a result, which is what I expected. But if you run this one fn!extract("<p>some text</p>","<p>","</p>") you get nothing as result. Another example of this strange behaviour: fn!extract("<l>some text</l>","<",">") returns {"l","/l"}, which is fine fn!extract("<p>some text</p>","<",">") returns nothing, which is inexplicably to me Any idea on why is that happenning?. I've tested that on Appian v25.1 Regards!

We used type! to create local constants in case of CDT, but is there something similar for record types?

I have requirement to export a view to excel such that one of the fields (request ID) should be having a hyperLink to Appian record. Data to be exported is stored in a view. How can I achieve this in Appian? Note: We need to send the exported excel via email every week. Thanks in Advance.

Hi All I am working on version 24.3! My scenario is, in the SITE provided to the users there is an Active Tasks page where user is shown the tasks as a link. On clicking the link; at the backend we have used a!startProcessLink() to start the appropriate Process Model with the required parameters.  We send a customised mail to user using Send E-mail smart service whenever a task gets assigned to them. The user wants the functionality that in that customised email, a link is provided for the task such that on clicking the link a task gets opened just like it gets opened from the SITE. I understand that a!startProcessLink() actually returns a Reaction Tree which Appian internally reads when we call the a!startProcessLink(). Wanted to check is there a way to handle the same scenario from the email such that on clicking the link in the email; the corresponding process gets started in Appian just like it happens from the SITE. Thanks in advance!!