Discussion Categories

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.

I followed this documentation for adding new calendar https://docs.appian.com/suite/help/22.4/Process_Calendar_Settings.html but i'm getting error com.appian.komodo.api.exceptions.SignalException: Invalid TimeZone

Hi all, I'm having an issue with aggregation and i've not been able to find a good answer.I have a dataset that is made up off a number of collection of records. Something like id   groupid  value   updatedOn   1    1             xx        19/01/2021 10:002    1             xx        19/01/2021 10:003    1             xx        19/01/2021 10:00 4    2             xx        10/01/2021 10:005    2           xx        10/01/2021 10:006    2             xx        01/01/2021 10:00 7    2             xx      &nbs

How to maintain color codes for each iteration for different color in audit log

lets say I had a word "Appian"  now I need to covert into a list expecting a result like below( Letter - (Number of times that particular letter is being repeated in the given word)) A-2 p-2 i-1 n-1 Please let me know logic to achieve this

I want to bold a particular word in a text when using a a!richtextitem. when I use the "Style" as "strong", it's making the entire text bold.In my case, I only want a word to be bold as shown below. Can someone please help a!richTextDisplayField( value: { a!richTextItem( text: { "We recommend ABC method.",}, style: "PLAIN",) } )

Hi All, We have an application where we use application action to trigger the process model and am able to see the action on tempo(DEV environment). Whereas I couldnt see it on TEST environment even though am part of same group as in DEV environment.  Could you suggest any ways to troubleshoot this issue. I have Checked application security Checked process model security Additional Information: TEST is on latest version compared to DEV now. Thanks in advance

Hi all hope someone can help. I am working on an integration in a process model and I want to pass some variables to the integration step I am assigning a recordtype value to the inputs in the data tab all works for division for example where I assign pv!record.recordtypexxx.division but it doesn't work when I assign the relationship data for example departmentid has a value of =pv!record.recordtypexxx.relationshipxxx.fieldoftherelationship It seems that the relationship values are not being passed? If I create an interface to display the data everything is there as expected both in the main record type and the looked up data from the related record type is there and correct. So the relationship works. Then why when I call the relationship data in the inputs in the integration it doesn't pick it up??????