Foundation

Hi Experts, Is there a way to retrieve inactive members of a group? I attempted to fetch all inactive users from the Users record type, but couldn’t find any direct function that provides group details for those inactive users.

Hi Team, I wanted to give a link in Editable grid ,on clicking of it it will open a task, I have tried with start process link, but its is not working in editable grid. Note:Editable grid is again placed in a related action. Let me know possible ways to configure the link. Thanks

Hiii, I want to add the Total Cost . It show the data in below format. I am using sum function to add the data but it is not working. List of Dictionary - 7 items Dictionary Total_Cost19000(Number (Integer)) Dictionary Total_Cost18000(Number (Integer)) Dictionary Total_Cost15000(Number (Integer)) Dictionary Total_Cost7000(Number (Integer)) Dictionary Total_Cost9000(Number (Integer)) Dictionary Total_Cost13000(Number (Integer)) Dictionary Total_Cost1500(Number (Integer))

I am using appian version 24.4 and made a user filter for a record that is populated by a lookup table. I deleted a couple of rows from the table because they were unwanted, but they still show up in the filter. If I look at the table in the db or the record for the lookup table, both show that the entries are missing, but no matter what I do, the deleted rows show up in the dropdown.  This is the table: This is what the dropdown shows: "In draft" shouldn't be there and there is a duplicate which was removed, but both remain. I saw a similar post Here but I am not sure it's the same bug or not and the post seems to suggest that this issue was solved with version 24.1. Any help would be appreciated 

Hi community, I have a question about a functionallity that appears on the SAIL Design System Documentation. https://docs.appian.com/suite/help/25.1/sail/ux-site-branding.html#dialog-shape In this page, we can see a section that says that the dialog shape can be configured, but not how to achive it. Could someone guide me? Thanks in advance.

Hello All, I have a 2 column layout. in left section I have a tree with multiple node like shown in below. Category1 Interface1 Interface2 Category2 Interface3 Interface4 Interface5 In right section I have to display the selected node's interface. For example if "Interface1" node is clicked then it should call an expression rule which returns the interface name to be loaded for that node. Now as expression rule returns string value, I am not able to render that interface in right section. Please note  - Each node has associated interface and entire list is maintained in records. On tree node click that expression rule finds the interface name for selected node. Kindly help if there is any other way to achieve this? Thanks in Advance.

We have a column in the Appian database table with data type as 'long text'. We want to facilitate storing and retrieving string around 8000 characters size in this table column. This will be a master data and will not be fetched in interfaces. (Also it may not always be 8000 in string length) But we will fetch this column in the expression rule for some evaluation and running rules. We are noticing that this column with long text is getting truncated in the expression rule when we retrieving the data. Our Record Type does not show any option to select "Extra Long Text" when creating a Record Type from this database table. This documentation indicates that we should be able to map the varchar or text to 'Extra Long Text' https://docs.appian.com/suite/help/25.1/about-data-sync.html Am I missing anything here?

Hi all, I am using the function a!startProcess() to trigger a process model from my interface. Is it possible to use the onerror parameter to show a custom message on the screen when the process fails to start or breaks for some reason. If it is possible can you please guide me how to achieve it ?

I have(had) an issue with a Selectable Editable Grid and I don't know if this is a bug or not. BUSINESS USE CASE I actually have two grids.  The Use Case here is to have the user assign a speaker to a parish for a parish event. One grid shows unassigned approved speakers and the other shows parishes that do not have a speaker.  There are two local variables that are loaded with this data; speakerEvents and parishEvents.  The user selects the Speaker, then selects the Parish before submitting the data. Here is the JSON for one of the grids. a!gridLayout( label: "Unassigned Approved Speakers", labelPosition: "ABOVE", emptyGridMessage: "There are no Unassigned Approved Speakers for this Event.", headerCells: { a!gridLayoutHeaderCell(label: "Speaker"), a!gridLayoutHeaderCell(label: "Type"), a!gridLayoutHeaderCe

Hi, I am trying to generate a CSV file from HTML(convert HTML to CSV plugin), but in the plugin's smart service, there is a parameter called 'CSS query' (text type). I am confused about what to put in that. Can anyone help with this? You will see this parameter in data --->input section

I want to generate an excel document by using "JSON To Excel Converter" in process model. Even though I am passing JSON correctly I am getting the below error error:

A task is assigned to a group.One of the user from the group accepts the task and be idle (do nothing, performs no action).After one hour the task should be reassigned back to the group.Please help here on how to acheive this?

I have two or more dropdown component and I hope that these dropdown components can share one choice list. For example I have a list like {choice 1, choice 2, choice 3, choice 4,...} In dropdown 1 the choice list should be  {choice 1, choice 2, choice 3, choice 4,...}, when I choose choice 1 in this dropdown, the choice list of other dropdown should be  {choice 2, choice 3, choice 4,...},  when I choose choice 2 in dropdown 2, the choice list of other dropdown (expect dropdown 1 and dropdown 2) should be {choice 3, choice 4,...} Can appian do like this?

Hi there! I am using this process. When CSv file is generated, it starts from row number 2. Can anyone please guide me how to set row 1?

I need to start a process using an email trigger. Is there any way to configure this process model using the Process Model Properties dialog? Thanks in advance.

Sure, here's a clearer and more structured version of your text: Hi Everyone, I have a requirement involving two tables: Tyre Data Table: Columns: TyreID (Primary Key), PartNumber (Foreign Key) Country Restriction Table: Columns: ID (Primary Key), PartNumber (Foreign Key), Country Name, IsActive (Boolean) These tables have a one-to-many relationship. For example, if we have a tyre with TyreID 1, there could be 150 entries in the Country Restriction Table for this tyre. Let's say for TyreID 1, it is active in India and the US. In this case, the IsActive column would be 1 for India and the US, and 0 for all other countries(all remaining rows). Export Requirement: We need to export the data in the following format: PartNumber Country1 Country2 … Country150 12345 1 0 … 1

I'm currently using embedded interfaces with Appian on cloud, but I will migrate to on-premises. Can I keep using them after the migration?And to migrate my applications from cloud can I simply export and then import them on premise, or is not that simple? Thanks!

Can we send hidden process variable data to sub process?

Hello, I have this interface where there is a grid that shows uploaded attachments and a button to refresh the grid whenever there is a new attachment uploaded. I am running into an issue where if the user clicks on "Refresh existing attachments" when the grid is empty, then uploads an attachment, the refresh button no longer refreshes. But if they upload an attachment and click refresh after utilizing the action, it functions as expected and the attachment shows on the grid. I am trying to cover this scenario in case a user for some reason decides to click refresh before uploading and the grid is empty. Thoughts?  a!localVariables( local!readonly: a!isUserMemberOfGroup(loggedInUser(), cons!FRR_viewerGroup), local!existingFolderId: if( isnull(ri!requestId), null, rule!FRR_GET_requestFolder(requestId: ri!requestId) ), local!existingAttachments: a!refreshVariable( value: if( isnull(local!existingFolderId), null, folder( l

Hi Do we have any plugins for below requirement, Tyre Data Table: Columns: TyreID (Primary Key), PartNumber (Foreign Key) Country Restriction Table: Columns: ID (Primary Key), PartNumber (Foreign Key), Country Name, IsActive (Boolean)These tables have a one-to-many relationship. For example, if we have a tyre with TyreID 1, there could be 150 entries in the Country Restriction Table for this tyre. Let's say for TyreID 1, it is active in India and the US. In this case, the IsActive column would be 1 for India and the US, and 0 for all other countries. Requirement: We need to export the data in the following format: Part Number|Country1|country2|.......country150 12345 | 1 | 0 |................|1|

I have requirement where I need to export data of the editable grid but issue here is I will be able to it in read only grid with help of parameter showexport but how to do it in editable grid.

Dear Team, I am writing to request assistance with configuring Content Security Policy (CSP) in the httpd.conf file for our Appian application hosted on an Apache web server. We aim to enhance our application's security posture by implementing a robust CSP to mitigate risks associated with script-based attacks such as Cross-Site Scripting (XSS). Below is the  CSP configuration  which i get on the application  Content security policy : report-uri /suite/rest/a/logging/latest/csp/report; report-to report;  is there any way to mitigate the issue 

We have a structure in db with an id, INFO, fatherID, level I have to given an ID, have to reconstruct all the Hierarchical Structure under the Given ID The Structure is a Three                                                                                           /------------ID1------------\                                  ID2[fatherID:ID1]                                                                               ID3[fatherID:ID1] ID4[fatherID:ID2] -/&nbsp

One of our customers has a requirement to send messages to students. Currently, we use AT&T's email-to-text feature to send these messages via email. However, AT&T is deprecating its email-to-text and text-to-email services, which means we’ll no longer be able to send or receive SMS messages using email. We're looking for alternative approaches to achieve the same functionality within or alongside Appian.Has anyone faced a similar challenge or implemented a different method for sending SMS notifications from Appian? Any guidance would be greatly appreciated.

HI , I have a requirement where I need to pass Sting values with separate Line to API . here is the  List of Sting with 4 items. “28978937982932090” “28978937982932091” “28978937982932092” “28978937982932093” I want to send it as single string with line break to API  “28978937982932090 28978937982932090 28978937982932090 28978937982932090” Can you help me with this scenario. Thanks in advance