Discussion Categories

Would like to see Appian add a feature where we could setup an audible validation.  For example, we have a data collection application where the user uses a handheld scanner to scan a part number, which returns the item description and unit of measure then they can scan a qty for inventory.  It would be great if you could set it up to play a tone if the part number was not found.  I have it set up to display a message, but if the user is not looking at the screen after each scan then they won't see the message. I am looking into the scanner hardware to see if there is a function I can use, but doubtful.

Hi All, I am trying to create an editable grid interface. But the column width for "ICON" is not working. Below I attached the screenshot of the code and the UI. Anyone having solution for this?

Hi All, I am trying to create one expression rule to get count of records created by  Tester_Group. In table, we have CreatedBy column. Requirement is to display the count in UI by using a!gaugeField(). Please help with some ideas. Regards,Sandeep

Hi, I have a table having 15 columns(Primary key constraint Id Auto increment) and my process is inserting 11701 rows, write to data store is taking 6 minutes to insert these rows. Is it fine or what i can do to fix it. pls find attached process node details.

Once the user submits the portal form, we have to show the case Id with the message " FORM SUBMITTED "  which the user submits Appian portal form.

hi Community! I would like to test my skills and do the AW2022 Live Build Challenge. Should I create tables within db that is behind My Community Edition Site or there is a way to get access to environment where db is ready and I can just start my development?

Attempting to use the records' export to Excel feature to export 50,000 rows.  Is there a method to speed up the performance because the download is taking longer than usual? There is no sorting of the data that was downloaded. We'd appreciate any advice. Thanks, Jasmitha

Hi there! I am trying to have createdBy updatedBy and updatedOn section reflect current changes in the record list when updated for an internal tool. So for instance when a user creates a new question or updates a question, I would like the record list to display that users info in it's own respected column. As of right now I am using loggedInUser() and now() but it is only showing my information all throughout the questions. So really what I'm asking is what do I need to change in the display tab of the records list to have this action work properly. Any help is appreciated!

Hello, Let's see if this is possible, I have a record type with a list in an interface showing the download in excel button. Once per day, on an auto-launched process, I need to send the excel generated to an email address, and also send the file through an FTP directory once per day. There is any way to generate the excel inside a process and work with it? If not, there is any workaround? Thank you!

Hi I want to add a uniqueness validation on a particular data for eg. as a user, if i enter "AbCde12" so it should check that existing data should not contain this value in case insensitive form. How to get the list of all permutation an combination of this value "AbCde12". Thanks & Regards Shweta

Dear I would like Appian RPA Robot to read/write to DB in "MS Access".So, I am trying to create custom Java code. Issues Below are wexing me now.1. How to pass values from process model to custom Java code.2. How to execute the query statement against MS Access.3. How to return query execution results from java custom code to process model Regarding 2, I think I will use UCanAccess which is one of JDBC.If you know a better way, could you tell me it. Regarding 1 and 3, could you share a sample code ?

Hello , I am not clear in which case it is more advantageous to use queryrecord instead of queryentity, I understand that the greatest benefit is when I have many related records, but if what I want is to make functions of a single entity with several calculations to later use in the processes, which is better ?

In a column status I have 6 values repeated, but in pie chart I want to show 3 values percentage. How to do this?

I am trying to use a!cardChoiceField but need capability to adjust the size of the cards, specifically make them wider. The documentations says to put the card choices component in a columns layout with a specified width to control the number of cards in each row. How do I do it?

Hi there. We have an issue we have been unable to resolve with Appian's default task notifications. We want the "View Task" button from the notification email to send the user to the task on one of our sites rather than through Tempo. We have been able to accomplish this in a couple of our environments by setting the default user start page to: "">our-environment-name.appiancloud.com/.../our-site-page" with a couple others sites set up for specific groups. We have tried the same thing for another one of our environments, but no matter what we've tried with specific groups and default sites, all the task notifications are sending users to the tasks in Tempo rather than the site. We've tried comparing settings across the environments to spot the differences to see why it is working in one place but not the other, but we haven't been successful yet. Is there some other setting that we've missed?

so lets say clothesType is declared as string in db. in a rule, i am iterating over this variable using for each loop. the problem is i can't declare the clothesType as an array as it would affect existing functionality. If i could, it would solve the problem. So, are there any built in appian functions that i can use to run a for each loop over a value that is accepting one value only?

I would like to include Navigation bar as it is described in Navigation Patterns. To make it flexible and to be able to assign particular navigation entry to different users I would like to store in table A all NAV Section (id, name, icon and rule name) and in Table B - userToNavigation mapping. In table B i will store userid, tableAId.  I don't want to list all Navigation sections and then all rules/section as it is in example. I would like based on userToNavigation mapping display proper interface. In other words i need Appian to understand rule saved in table as text to be recognized as proper interface (rule!interface) https://docs.appian.com/suite/help/21.4/navigation-patterns.html

Hi, The requirement is to compare document with its previous version of the same document ID in appian. Is that a possibility and if so any plugin or function that to be used?

I'm trying to manually create a related action for a record type (the auto generator didn't work). I need to create an expression rule that returns an individual record based on the record ID (according to the documentation), but there doesn't seem to be any documentation on how to actually do this. I've posted what I have currently that is not working, could someone let me know what I'm doing wrong? Thanks in advance! Expression rule: a!queryRecordType( recordType: 'recordType!{5e8d63c0-430d-4636-9dfe-e5e4c67aefc5}SH survey data', fields: {}, pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 1 ) ).data[ri!identifier] Context field in Related Acton configuration: { record: rule!SH_getSurveyRecordById(rv!identifier) /* SH survey data */ }

Can anyone tell me the procedure to follow, so that I can have on-prem solution on my device. P.S, I tried following mentioned on the Appian website but it is of no use as when I try to go on the Appian Forum, it redirects me and shows error 404. So can anyone guide me?

Hi All I am working on the Appian portal and trying to upload more than 1 file at a single time, I used maxSelections in file upload field but its not working I am using record Type and local variable because we can't use rule inputs in the portal. Below is my interface code and CDT .

Hi everyone, I need to track my company distribution list (contact group) on outlook email. It should work this way: Sombody sends an email to my distribution list. Receiving the email to my inbox is an action that triggers appian process with parameters extracted from that email. The distribution list that I need to monitor has company domain and it is not on appian cloud. I checked the Receive Message Event documentation but I am still not sure how to approach this task. Thank you in advance,Marcin

How To Remove Unwanted fields in pie chart.

Hi all, I am trying to build a selectable editable grid, but everytime I select a row it keeps selecting the entire grid. I saw previous comments that each row needed to have an identifier, and my data does have one, but its identifier status must be getting lost somewhere if a selection on my grid keeps selecting everything. Here is my test code: a!localVariables( local!data: rule!query_case_summary(show5YrAvg: false), local!header: {"age", "gender", "smoker", "amount", "fiveyravg1", "fiveyravg2", "fiveyravg3", "fiveyravg4", "sum5yrChange", "annual5YrChange", "currYrChange", "priorVal", "currVal", "recVal", "reviewStatus", "lastReviewedBy", "userRecVal", "comment"}, local!selectable, { a!gridLayout( headerCells:{ a!forEach(local!header, a!gridLayoutHeaderCell(label:fv!item)) }, rows: a!forEach( items: local!data.data, expression: { a!gridRowLayout( contents:{ /*

Looking to find out how many times a interface is clicked into or initial loads to get rid of interfaces that are not clicked into. The Sail_Detail.csv should do this but for some reason the internal code is empty. Does anyone know a plug-in that can find this information or a different log?