Discussion Categories

Hi Community,    I need to create a record type based on an external Airtable table. AirTable provides a REST API for querying the data, so I decided to create a Web Service based record type.  I already created a connected system and confirm that is returning data.    The issue here is the paging (due to the expected number of records) - Airtable does not accept a page number as (query) parameter, only the page Size.  In each response, beside the record list, there is an attribute called "offset" that should be used in next request (send as a query parameter) to get the next page (and so on).  When we get the last page, the offset attribute will be empty. Additionally, there is no way to know (in advance) the number of records in the Airtable.    As the Appian paging is based on batch number, I do not have any idea how to proceed.   Hope that somebody knows a way how to handle this type of paging.  Thanks in advance

I have a question regarding the ACD101 exam session. At the exam before last (August 9, 2024), I participated in a session using the "Go to" system from my browser, but the proctor told me to download the "Go to" app.When I was confused and couldn't figure out how to do it, a "Zoom" meeting link was sent to me via chat, so I continued the exam "Zoom" meeting. Therefore, for the last exam (August 17, 2024), I downloaded the "Go to" app in advance and participated in the session.However, I couldn't connect to proctor and ended up deleting the "Go to" app.After that, I accessed the "Go to" meeting link sent via chat and was finally able to speak with the proctor. Has anyone had a similar experience? My PC's communication environment was perfect, so I don't know what measures I should take next time I take the exam to be able to successfully enter the session.(I feel like I can access it from the browser

Currently, after submitting a form, a new form appears with the previous values for some of the fields , how to fix this issue

Hi everyone, I'm seeking guidance on best practices for handling a specific scenario in Appian. Here’s the situation: I have two records: Record A, with a primary key column named A1. Record B, with a primary key column named B1. There is a one-to-many relationship from Record A to Record B. I'm retrieving data of Record B using the 'relationship/related record data' from Record A, in both interfaces and expression rules. I've also defined the reverse relationship in Record B as many-to-one from Record B to Record A using the same column. However, when deploying, I encounter an issue with missing objects. Could you advise on the best course of action or Appian best practices for managing this type of relationship? Is there a recommended approach to avoid such issues in the future, or is there an alternative method for defining relationships? Thanks!

Hi, I wanted to know that how we can expose/embedd our Appian functionality/action to other application which is not of Appian ex: A Java built-in app, so the user using the application can perform an action which is build of Appian.

Hello Team, can you help me with this here, please? I have a form (parent record), which relates to more or less 15 different tables (records). Most of these tables have a 1-1 relationship with the parent record and, in about 3 of them, the parent record has a 1-N relationship. Knowing that all these tables are filled in the same form, and everything occurs in the same process. What is the best approach in this case? Thanks

Hi Team, I have a group Picker field and there is a condition that if mkv = 'mk-3475' by default it should select a group called Keytruda writers. The users who is working on this interface cannot remove this group but they can add more groups along with this.  Can some one help how I can achieve this. a!pickerFieldGroups( required: true, label: "Assignee(s)", helpTooltip: if( and( or( ri!lrrf['recordType!{a8fd253d-0e45-428b-af5f-cdd4c2b27a87}RGRACSLBL LRRF.fields.{57e16ccd-ed38-46b5-9fb7-8f5cfca177c9}reviewType'] = cons!RGRACSLBL_LRRF_REVIEW_TYPES[1], ri!lrrf['recordType!{a8fd253d-0e45-428b-af5f-cdd4c2b27a87}RGRACSLBL LRRF.fields.{57e16ccd-ed38-46b5-9fb7-8f5cfca177c9}reviewType'] = cons!RGRACSLBL_LRRF_REVIEW_TYPES[2] ), ri!lrrf['recordType!{a8fd253d-0e45-428b-af5f-cdd4c2b27a87}RGRACSLBL LRRF.fields.{2ebc42d8-fe25-490b-879a-dcf755894066}country'] = cons!RGRACSLBL_EUROPEAN_UNION ), cons!RGRACSLBL_CONS_LRRF_GLL_HELPER,

Hi, I have a process model with an Export DSE to Excel smart service and it exports to an Excel file stored in a  folder dedicated for this functionality in my application. During QA testing, 2 different basic users who are in the same parent group and the group has Viewer access for the folder security. One user can successfully download the exported Excel file, while the other user's process instance gets the folder security error "The specified Save in Folder doesnt exist or you do not have enough privileges to access it ". I resolved it by setting the Export DSE to Excel smart service's assignment to "whoever designed the process model" but still would like to understand why 2 basic users will see different behaviour in the process when that node is set to "whoever started the process" as the assignment. TIA

Hello, I have the following validations on a file upload. When I upload a wrong extension for testing, it is giving me a completely different validation message than what I have in my code and I'm not sure where it's getting it from. Also, it looks like each time I upload a new file, the earlier validation message does not get replaced with the new one and I have no point of reference to see where this is happening, if anyone knows how to fix these two issues I'd really appreciate it. Here is the code. For reference, the constant being used (cons!GF_FILE_EXTENSIONS_UTILITY_PACKAGE_ARTIFACTS) has an array of all valid extensions (pdf, jpg, png, etc.)

Hello Appian enthusiasts, I am trying to improve an internal deployment process, and one thing that pop up is the need to update "Group Attributes" in every environment, because we are using SAML Sync. I know Stefan already published an awesome article proposing a solution (SAML Group Sync – Appian Rocks). However, it is for applications starting from scratch. In my case the pieces are already setup. Then, I couldn't find in the documentation a way to use the Customization File for that (Managing Import Customization Files - Appian 24.2). Is there a way to update the group attribute during the deploy or am I asking too much from the Customization File capabilities? Thanks in advance for all!

For the following table of records, I need to be able to calculate the total of the highlighted columns, (Bid Amount & Principle Balance) so that I can utilize that information to create a list of metrics listed below the Picture. Balance Underwritten Sum of Principle Balance Balance Bid Sum of Principal Balance (Where Bid Submitted? = Yes) Balance Won Sum of Principal Balance (where Bid Won? = Yes) Bid to Underwritten % Balance Bid divided by Balance Underwritten Win to Bid % Balance Won divided by Balance Bid Win to Underwritten % Balance Won divided by Balance Underwritten

Hi Everyone , I am getting an error in write to record node in the process model. we had relationship between two records, the table name of the parent  record was modified and it was throwing an error in Process model. telling: table does not exist  "The table name(old table name) " ,later the parent record was removed from application ,and the relationship is also removed. Even now I am getting the same error. when I am not even referring that record ,I am getting an error saying the older table name does not exist ,the table name is modified and record is removed ,why am I facing the error still? Pls let me know the solution

I want to edit the group's membership rules dynamically from Appian UI, do we have any smart service/function available to achieve the same? Thank you in advance.

This is my recordtype: This is the interface's creation rule input. EPT_Order_Status_RT is a Recordtype and it is showing up.

Greetings I am trying to use Document Extraction AI Skill to save information in a Commission Statement. The Commission Statement has standard details (Statement Number, Statement Date, Total Commission Paid, Production Cycle etc. It then has a breakdown which has Commission Line Items (Client Name, Surname, Policy Number, Policy Type, Amount, VAT).  I have created a similar process model to the one in the Tutorial: https://docs.appian.com/suite/help/24.1/create-skill-doc-extraction.html I therefore have a Table that speaks to Commission Statements and a Table that speaks to Statement Items. No the problem here is that the Commission Statements record Type gets updated with relevant data from the Document, however the Statement Items information following the Reconcile Doc Extraction results does not populate into the Statement Items record type. I have created the One-To-Many relationship between the Commission Statement and Statement Items Record Type and left the Writ

It's common practice to store the Appian username to the database for the createdBy, updatedBy, assigned, and similar fields. It's easy to handle in Appian to support search and filter capabilities when referencing those fields in a record type. But occasionally an associate has a name change, which subsequently causes their Appian username to change, since it's often their email address or something similar. That change disrupts the different features that depend on the username to match in Appian. At my current client, we're trying to mitigate that disruption by storing the UUID for each user instead. It's easy to use the People Functions plug-in to derive all of the user's information from that UUID. But, search, filters, and sorting will use the UUID. I tried remedying that by creating a custom record field, but it doesn't allow the user() function (or any plug-in function) to be called from the expression. How can I do this without resorting to a CDT an

After upgrade, while create or modifiy Process model and reports are giving error 404. Anyone faced similar issue?

Hello! Our integration with DocuSign just stopped working on August 29th at around 2:30 eastern.  We spent the morning with DocuSign techs and were not able to resolve the issue.   DocSign came back with "This would indicate that the mechanism relaying your auth token is either not properly relaying it or the token itself is being cut off. The messaging would indicate that it's not being included at all, and that the CORS related error I was seeing was a red herring related to attempting to send envelopes without a registered IntegratorKey.  We have put in a support ticket, but is anyone facing this issue?  And if so were you able to resolve it?

hi,  I have a record list from  excel sheet which will be uploaded from interface Excel sheet record1 : id:1,name:"A" record2: id:2,name:"B" record3: id:3,name:"A"  Database :  record1 : id:"A01",name:"A" The record list in the excel has to go to the data base with new updated id , based on validating existing record in the database.  Updated list should be like  record1 : id:"A02",name:"A"  -> increments because this name already exists record2: id:"B01"name:"B"  -> starts with 1 because , it is not available in the database yet record3: id:"A03",name:"A"  I am trying to lay out a design with out using loops for the records in the excel sheet as they might be huge. Can you provide any optimized design solution for this ?

Hey ,  Is it possible to update a constant with a array value using update constant smart service ? If yes ,then how ? Thanks , Bisheswar

Introducing Appian UX Design Lab, a new YouTube series where you can get live feedback from Appian UX design experts. Submit your interface for a chance to be featured in a live review, or simply join us to learn from our experts as they provide actionable UX/UI design feedback. The first episode will air on October 17th, and will focus on building information-dense dashboards and case summary UIs. These UIs are crucial for app users to find the right information quickly, so it’s important to design them intentionally. Sharpen your dashboard skills by submitting your UI for a live review! What’s in it for you? Submit Your Design: Create or replicate a sample dashboard or case summary UI in the Appian Community Edition, and then share the link to your UI at https://ap.pn/3X2HQRZ. Get Expert Feedback: Selected designs will receive a live UX review from one of Appian’s UX experts, with opportunities to ask questions in chat. Earn a Badge: All participants will receive t

I want to validate a website URL that goes as an input, requirement is to start with https://www. and with {.in, .com, .net}Please Assist, Thanks in Advance

hi,  I am currently incrementing a counter based on a the count of similar records in the database.  counter should start from 001. it defaults to 1 for me , when I am simply setting the counter to 000 and increment by 1.  Expectation is 001 and not 1 any help is appreciated.

We would like to be able to access many schemas in Appian when creating a record type from a sql server table. I have the table created on the server that is in or datasource in the admin console but when I got to select the table in the record type I only see tables that exist in the dbo schema

Hi Everyone, I have 3 tabs in the application interface, when the submit button is clicked on the third tab it moves to first tab. Is it possible when submit button is clicked it should remain in the same tab?