Discussion Categories

Hello Team, Does Appian have any documentation for creating services in Linux? I have recently setup a distributed installation, and I am looking to create Appian services and have them start automatically on system reboots and also stop gracefully on system shutdown. Any suggestion will be appreciated. Thanks

Hi Experts, What all point need to be taken into consideration while Moving Application from version 17.1 to 21.4. What all are the pre-requisite on the admin console side as well as at object level.

Hi Experts, I have implemented readOnly grid with RecordType as a datasource. Search options was only working for the the columns which I have configured in the gridField, so for search to filter on all the columns I have added all the columns of the cdt/table as gridField column with showWhen as false. Will it be having any impact of performance? I tried to lookinto the performance matrix of the UI but in both the cases performance is almost identical. Q: Question that I have up in my mind is weather the performance will get deteriorated with the increase in amount of data pulled through record or will it behave as it is ? Q: Since all the data is already coming through record , showing it in grid will have considerable impact on performance or not ?

I am trying to export data store entity into CSV via smart service "Export Data store entity to CSV" and for tables more than 50 columns, am receiving the following error. Kindly help out in this regard. "Unable to export. Maximum number of columns exceeded: 50 "

Hi Team, I have new requirement to add few fields in the interfaces for which i updated the existing interfaces and data types. But there are many active instances available in production which might cause issue? In One Scenario i want the latest changes also to be included after the deployment and in another task i want the hide the latest changes for few tasks. Can you please guide me to the list of steps that i need to take care while moving the changes to Production. Please let me know if any further information is required

as per the requirement, I have to convert user texts into DB date format  Required format: YYYY/MM/DD expected date inputs: Date with Month Name   March 20, 2023 DD/MM/YYYY 02/12/2022 MM/DD/YYYY 12/20/2022 D/M/YYYY 3/9/2022

Hi Team, We Often get the requirements from the business to Skip the flow and to complete the case. so we are cancelling the tasks and making the backend database changes when the user is unable to complete the task. Does it has Impact on the performance on the environment and what is the best way to handle this kind of Changes. Thanks In Advance

Hi Everyone, I have a database field whose value needs to be reduced by 1 every day. Can anyone please suggest how to achieve this in Appian? Thank you!

Hi everyone! I´m doing an interface using Recordtypes from scrach. I´m making a grid in a form to sum some quantities from de employers. I´m having some problems with the dynamic link to add new rows of employeers expenses and also having problems to summarize the fields with the quantities. I´m providing part of the code. Could you tell me what i´m doing wrong please? Thanks a million in advance! a!sectionLayout( label: "Gastos", contents: { a!gridLayout( totalCount: count(local!articulos), headerCells: { a!gridLayoutHeaderCell(label: "Fecha del Gasto"), a!gridLayoutHeaderCell(label: "Descripción"), a!gridLayoutHeaderCell(label: "Tipo de Gasto"), a!gridLayoutHeaderCell(label: "Importe del Gasto"), /* For the "Remove" column */ a!gridLayoutHeaderCell(label: "") }, /* Only needed when some columns need to be narrow */ columnConfigs: { a!gridLayoutColumnConfig(width: "DISTRIB

There is a request to have a notification section in Application . This would be things like a document has been shared, an approval for an action, etc. Basically anything we currently send a system notification email, but this would be within Application. A notification count show up on the user profile image at the top right corner, like we would see on a smart phone. If we click on the notification icon, we could then see all new notifications, like viewing the emails on a screen in Application . Is it possible to achieve this functionality.

Hi guys. I'm new to complex queries with records and I've got a question about how to execute a query based on records when there is no key based relationship between two tables. Imagine a situation where there are two tables 1. Executed jobs table Jobs       Id Summary Employee Hours Timestamp 1 Pipe change johnb 3 10/12/2022 12:34 2 Cleaning andyw 5 08/12/2022 10:22 3 Installation johnb 2 03/12/2022 09:12 4 Destruction johnb 4 02/12/2022 18:34 2. Hourly rates of employees Rates         Id Employee From To HourlyRate 1 johnb 01/02/2021 30/11/2021 12 2 andyw 01/03/2021 31/01/2022 8 3 johnb 01/12/2022   14 4 andyw 01/02/2022 31/12/2022 11 5 andyw 01/01/2023   14 In result I need to list executed jobs with their cost. But the join between these tables is based on employee name and timestamp of job fitting into rate of employee at job execution time. Using SQL I could perform a join on multiple fields

Hello Everyone, I have a requirement where I need to get the Precise Location details based on Latitude and Longitude. But when I am using Google Maps Plugin and using the Operation "Get Geocoding Information", It is returning a list of locations i.e list of dictionaries with location names. The resultant locations are not accurate. Is there any possible way or plugin that has other parameters such as Horizontal accuracy and Vertical accuracy. Here I am capturing the location details from Process Model "Capture location on submission". Where I get 5 Values 1. Latitude 2. Longitude 3. Horizontal Accuracy 4. Vertical Accuracy 5. Altitude Here's an example of the Outputs/results that I am getting based on my Latitude and Longitude values. Would love to have any kind of suggestion and also alternate possible ways to achieve this. Thanks in advance.

hi iam using richTextFieldWithTables component where i cant add validations that i have enterd 6 charectes name and clicked on enter it is showing count of 11  but i need to writea condintion if a user enters 4000 charectrs he should not procede further how can we give validation bcz on chage of size of text or on click on enter or by adding tables charcters count is getting count i had used strip html fucntion but it dosent help me any suggestions please 

Hi All, We have built an application wherein user inserts some records in excel and upload it to appian. We then parse those information and display them in appropriate appian controls. One issue that we are facing currently is related to Date or Date&Time entered by the user. As user can enter date and time which may or may not be accurate in terms of how appian wants those data. Hence, It results into an error.  Is there any way to figure out whether the date is valid or not as per appian? If its not, We have decided to show them in readonly textfield. Any help here will be appreciated.  Thanks in advance

Document Id is generated from the process model, I need to show document in the interface how to link process model to interface.

I'm having issue with my certification as I still have expiry date for certification even though it is showing as Inactive, please see the attached screenshot. I have also completed the Appian Developer Videos again in the community. Do anyone know the reason behind this inactive certification even there is expiry date available? Please suggest if anyone knows anything, that could help me a lot.

Hello Appian People, Is there anyway i can show the error message if textbox is empty when clicking the button, without setting the submit field of the button to true() ? Well, at first its kinda easy to show if the textbox is empty when the submit field = true in button.  But I want the process where it will not set to true and still if it was clicked the empty error message will show if textbox is empty. Is it possible? Currently this is my sample process, however seems its not working.  UPDATE: Its okey now guys, i figured it out.  Thank [emoticon:6d505171faa4497c85c5ca27290c555d]

Hi team, I was following the document  https://academy.appian.com/#/online-courses/fc14c3d1-0eb3-4d9d-8ae2-fc0149ae7585 asking me to select Template from the toolbar and then select 'Import Template' but I do not find the import template icon on my community edition.  I can just see the default ones.. When I see the Appian documentation at https://docs.appian.com/suite/help/22.3/rpa-8.5/templates/rpa-templates.html I can see the import template icon on the top right in the doc. Can someone pls help is it just me or do I need to update something somewhere to get the import template icon ?? for now while I wait I have raised this to support team as well thanks jaideep

Background: Using integrations I have called several endpoints and pulled the data into a map with nested maps.  I now need to move values from the nested map to the parent, as they are all 1:1 relations. a!localVariables( local!CDT: a!map(id: 1, name: "Walt Disney", demographics: a!map(age: 73, gender: "M")), local!CDT) This returns:  Map id1(Number (Integer)) name"Walt Disney"(Text) demographicsMap age73(Number (Integer)) gender"M"(Text) what I am in the need of is: a!map(id: 1, name: "Walt Disney", Age: 73, gender: "M")

I make a call to an integration and receive an output like above. I have a requirement where i need to append every dictionary that comes under cells with the corresponding row ID in the top and save it in table. how do i do that ?

Hello good evening, I need help, well, it turns out that I have a problem, for example, when I want to omit certain special characters, I use substitute, all fine for example if I only want to omit the symbol "&", but when I put another symbol, for example "%", instead of replacing it, I get a blank space, I have already used substitute, stripwith, a regex, and I can not find a solution, I attach my code. a!localVariables( local!subs:substitute(ri!name," & "," "), local!formatB: cleanwith( local!subs, cons!GT_CONS_Clean /*1234567890qwertyuiopñáéÃ%ADóúÃ%81ÉÃ%8DÓÚQWERTYUIOPasdfghjklASDFGHJKLzxcvbnm-ZXCVBNMÑ_ */ ), if( length( local!formatB ) = 0, "attach", local!formatB ) ) I have already tried these functions and I can't get that.  regexreplaceall("\s\W", local!sub, "_") stripwith(ri!name," &#$%&/|¡? ") For example, when I try to test this string, instead

Hi Experts, I have a requirement where we have to get the input from user for the time fields, User want the time to be entered in HH:MM:SS in 24hrs format where SS is optional. Below are the input with expected stored output Input1: 23:55:55      Output: 23:55:55 Input2: 10:32           Output: 10:32:00 Input3: 23                Output  23:00:00 Input4: 231000        Output: 23:10:00 Input5: 2359            Output: 23:59:00 Input6: 23               Output: 23:00:00 Kindly suggest for the feasibility of such expression as how can we achieve this.

Hi there, could anyone let me know what's the problem here, in the following expression rule, if the condition is meeting, it will return the records which meet the condition, if there are no records meet the condition, I just want to return 0 item, but here it returns 2 "0 items". replacing "{}" with null does not work either. what I should do? regards Lin

THE primary key is generated automatically when data is stored in database. Now how to display primary key when the data is forwarded further to supervisor?

When trying to upload a blank file getting a validation message  But, when replaced with a proper file, that validation message still shows  On testing the interface also, this validation message still persists. Only on, screen reload it goes. Need help regarding this.