Discussion Categories

Would be nice to have the Indeterminate state  on column heading on selectable grids where only some of the rows have been selected /resized-image/__size/640x480/__key/communityserver-discussions-components-files/13/Screenshot-2024_2D00_10_2D00_18-at-11.08.00_2F20_a.m_2E00_.png

Hello, I need to create rule that takes an array of dictionaries in input and if multiple of these elements have the same "id" value, I want to take only the first one in a separate list: ri!list: { {output: "OK, id: "abcd", description: "hello"}, {output: "OK", id: "abcd", description: "hi"}, {output: "OK", id: "yxz", description: "bye"}, {output: "OK", id: "yxz", description:"goodnight"}, {output: "OK", id: "opt", description: "ok"} } the output should be the following: local!output:  { {output: "OK, id: "abcd", description: "hello"}, {output: "OK", id: "yxz", description: "bye"}, {output: "OK", id: "opt", description: "ok"} }

Hello Appian Community, I have access to forum.appian.com, but I'm unable to access the License Management Application to request licenses. Specifically, I need to request both the k3.lic and k4.lic files for my Appian installation, but I cannot proceed due to this access issue. Can anyone guide me on: Alternative methods to request both licenses (if License Management Application access is restricted)? How to register a developer instance with Appian? Any insights or step-by-step guidance would be greatly appreciated! Thanks in advance for your help.

Hello, I have a use case where I need to download multiple documents from SharePoint. Currently, I need to do this in a process model and the only way I have found of doing this is by creating a loop within my process.  Unfortunately, I need to activity chain this process and by having this loop, I risk breaking the 50 node limit. My question is as follows: is there any way to download multiple documents from SharePoint using a single node within a process? Thank you

There is a database table where user can write into. I need to generate a dynamic template using the data from the table. Meaning I have a button or a link, whenever user click it, the latest template should be generated and downloaded. 2. And I want one of the column to be populated with a dropdown and user can only choose value from the dropdown, which also means the excel should be protected. Can we generate protected excel with only specified cells that can be edited How can I implement this?

Hi All,  I wanted to ask if there's a way to determine the peak and average number of user logins during a specific time period. This information is needed to help scale the infrastructure in an on-premise environment. Thanks in advance

Hello folks, I am generating PDF file on click of button. The issue is the text output in the PDF converted a hyphen to a number symbol.  For eg: "year-end" to "year#end" This will only happen if I copy and paste text along with hyphen. Can someone suggest?

Hello, I am trying to add a document link to an interface. I found the a!documentDownloadLink function and it tells me to create a constant to point to my documents but I am a bit lost. This is an interface where a supervisor will approve or deny a request so the document link in the form should be attached to the specific request. What do I need to do in the cosntant to point specifically to that value? The value is store in my recordType as an integer and it is added to the record through an attachment component in a record action.  any help is appreciated

I want to know the internal mechanism of local variable refreshing in an interface. When a local variable is refreshing, what is the underlying logic of the behavior? Is all code re-executed? Can you give me a conclusion and provide a demo to prove the conclusion.

I have two tables with a one to many relationship, an owners table and a pets table which are connected via the Owner ID. The owner can have many pets. I am trying to add an action under the owner summary view for the user to be able to add a new pet that belongs to the owner but I am struggling with how to connect the two records. I have created a related action under owner that points to the add / update pet but I am struggling to connect the owner ID to the pet being added, any help would be greatly appreciated! 

I have a group, group type is business group, now I no longer need this group. How can I deprecate/remove it. It has been deployed to higher env like prod. I need to remove it from all env

I created generated some sample data through ai but I have a problem with one of the fields. The createdBy field shows full names but when I add data through a record action it shows a user. I wanted to show only users. Is there a way to delete that data or change so it displays consistent information? I tried to edit those rows but the system does not let me.I can only edit the rows I did through record actions. Here is the column to show the issue: thank you

Hi All, I am calling the data from db through expression rules and gave batch size as 100. I need to use this data in interface inside grid, is this only 100 records will be displayed in interface or I can display whole data from table.

Hi, I need to have a document upload form like this package import form, and have a validate button like inspect button, but I need to disable the import button before the document is validated successfully. I need to validate the document's content and format, so it's not just a validation for the size and type How can I do?

Trying to walk through the tutorial for the Acme Auto (SA) Application. When I click any vehicle I get the error below. When I add a vehicle, it does not get added. Obviously I'm new to Appian. Any help appreciated. Error Evaluating UI Expression Expression evaluation error [evaluation ID = I0L6P] in rule 'w1847aa_cmpt_vehiclerecordevents' (called by rule 'w1847aa_dash_vehiclesummaryview') at function a!eventHistoryListField [line 3]: Error in a!forEach() expression during iteration 1: Expression evaluation error at function a!queryRecordTypeFunction [line 58]: An error occurred while retrieving the data for "W1847AA Vehicle Event History". Details: Record type is marked as synced, but its data has not yet been synced or its existing synced data has been invalidated. Contact your system administrator. (APNX-1-4198-000)

am getting this warning

Hello, I have added new columns in the views and updated CDT and published data store. However, when trying to update the record type I'm getting below error. Note: The updated fields are reflecting in edit list after resetting the list but getting error in preview.  Expression evaluation error at function a!gridField [line 51]: An error occurred because the record types source is currently unavailable, or the query reached a timeout or memory limit.

I am looking to gather details on all objects that been modified or updated in our Appian environment over last 6 months. Specifically,1. How can I obtain a list of all modified /updated objects during this period? I know, we can manually check each objects versions for the changes made, or last modified but was wondering if there is consolidated a report at object level2. Is there a way to track which users made these modifications and when?If anyone has experience with this or can point me to relevant resources or methods, I would greatly appreciate your insights!Thank you in advance for your help!

Hola, Sr Administrador, . Cuando estoy tratando de probar el flujo del proceso: W0747SA Solicitar mantenimiento. Me sale el mensaje que copio más abajo y no puedo seguir. Me podría decir que debo hacer ? El sistema ha encontrado un problema ¡Lo sentimos! Se ha producido un problema al procesar la última solicitud. Póngase en contacto con el administrador del sistema para obtener más información.  

We would like to use Smart Service to delete records from the DSE (Data Store Entity) and create records according to the input received from the screen.In this case, will the Delete and Write transactions be separated?For example, if Write after Delete fails for some reason, I would like the Delete transaction to rollback. Please let me know if there is a way to execute Delete and Write in the same transaction on Smart Service.

Hi, sometimes I have to go back to the basic rules of Appian. I have an editable grid with REQUIRED fields to show in a page of a Site. To make this validation work, I have to put the interface in a start form of a process and then add this process in a site page as Action, otherwise it won't work. Is that correct? Thank you

Not able to create a new Record Type from scratch in Community Edition I am unable to create a new Record Type with a new database table i.e. not getting "I want to start from scratch" option. Is it a known restriction or a bug? Community Edition: Standard Tier: Please let us know your inputs if any.

Hi, I'm using readexcelsheetpaging() to read an excel, it has a blank row so I want to set stopReadingAtFirstBlankRow: false But I got following error: Expression evaluation error at function 'readexcelsheetpaging' [line 26]: The passed parameter(s) are of the wrong type. Received the type com.appiancorp.common.xml.JaxbConversionException: JAXB was not able to produce a value for typed value TypedValue[it=26,v=0] as java class java.lang.Integer. But when I removed stopReadingAtFirstBlankRow it works fine.

Everytime that I try to open links for learning paths and courses in Appian I need to login (which I already did) and when I put my credentials, I see this error message:

Hello, I have a process for parsing data, and in one of the nodes, I'm checking whether the respective alert exists for a specific event. The script task has one output, which uses a QR rule to retrieve the alert based on the event's alert ID. The retrieved alert is then stored in another variable. The QR rule returns a single alert, which works as expected in all other environments, but in production, the result is null in the process model. This issue has also occurred with other processes using the same rule and having multiple outputs, but when we split the logic into two subtasks, it worked fine. However, for this process, the problem persists. Could you suggest what might be causing this issue?