Discussion Categories

Hi Team,I have a constant which holds array of data store entities, In a interface I need names of those entities from constant.for example: cons!xyz is my constant, if I just simply use this in interface I'm getting something like this(internal representation) [Data Store Entity:"29c9c1bd-6809-486b-8da1-f993cd872bbc@867691"] [Data Store Entity:"95bb55be-5347-4ea3-9713-b78870bbf7e3@867691"]instead is there any way to get name of those entities like "employee","education" ,something like that.Thanks in advance [mention:126a676c85024855948336691b0a7b92:e9ed411860ed4f2ba0265705b8793d05] 

Hi,  I have a excel sheet in which the Excel sheet headers start from different row (example: row-8). In a process model, how can I read it from row 8 using Import excel to database smart service.

Hi everyone,  New to Appian, and have been working through the Appian Developer learning path. Today I ran into an issue while following the instructions for the second process model. When I click start process for debugging, I get this error message in the popup window:   I decided to continue following the steps and figure this issue out after. After creating the related action, I got another error with a bit more information: I'm not sure if both of these are caused by the same issue, but it seems like there's an issue with the Vehicle Details View. Here is the expression:  When I first created the Vehicle Details View, I got another error. After googling for a bit, I added a!documentImage() around the link to the image, but when I took that out it broke the view again. Any advice on how I might be able to fix this would be amazing. 

I want to refer to the information on the right when filling out the form on the left. I want a new page to be displayed on the same interface when I click the product name on the right. How can I achieve this operation？

There is an app in appmarket called marketplace which is free. So,how to deploy it in my community environment?

We are using an editable grid, we have a requirement where we need to display a textbox when a particular value (Other) is selected from the multi dropdown list other wise it should not display textbox.  Please find the attached screenshot for requirement reference.

a!dropdownField( label: "Deposit Amount", labelPosition: "ABOVE", placeholder: "--- Select ---", choiceLabels: a!forEach( items: rule!CD_QE_Get_Amounts().data, expression: fv!item.amountFrom & " - " & fv!item.amountTo ), choiceValues:a!forEach( items: rule!CD_QE_Get_Amounts().data, expression: fv!item.amountFrom & " - " & fv!item.amountTo ), value: {local!DBben.Amount}, saveInto: {local!DBben.Amount}, searchDisplay: "AUTO", required: true, validations: {} ) Hello All,  I am facing this error "has an invalid value for "value". All selected values must be present in the choiceValues array, but value was -∞ and choiceValues was 100000 - 500000; 500001 - 1000000; 1000001 - 2000000;" any advice ?

Hello, The categories of column char showing one 1st at its index. The column chart is as follows: series: local!columnSeries:a!forEach( items:local!months, expression: a!localVariables( a!chartSeries( label: fv!item, data: a!localVariables( local!count_usage:where(local!months=cast(typeof(local!months), fv!item), 0), if( length(local!count_usage)=0, 0, index(index(local!localCbProcessess.data, "id_count", {}), local!count_usage, 0) ) ) ) ) ) Column Chart field: a!columnChartField( categories: local!months, series: local!columnSeries, xAxisTitle: "Months", yAxisTitle: "Usage", stacking: "NONE", colorScheme: "CLASSIC" ) categories data sanp: the chart is not sho

How to populate a dropdown list of years between 1990 to 2023 using enumerate function

Hi I'm using import excel to database plugin to export data from excel sheet into database. I'm not facing any issue in the process model and data is not saved into database. Then I dig in the logs and found out below error.  Could you please let me know, how to resolve this issue.  Caused by: javax.naming.NameNotFoundException: Name [[Data Store Entity:"1460e773-36a5-4c3a-afad-04711683a7cd@5528"]] is not bound in this Context. Unable to find [[Data Store Entity:"1460e773-36a5-4c3a-afad-04711683a7cd@5528"]].

In Advanced rich text editor, i want to save a image, then how to save the source code of that image which is view in menu bar into a variable?  I want to save below source code into a variable:  But, When I pass a variable in richTextSaveInto, it save like below:  (length of characters: 247454) which is too long to save into DB. So, I want to save the source code which is view in menu bar  Please anyone suggest !!

I didn't see datasource in Component Configuration pane

I got one point in docs, i.e  Using the Write Records web API template, define an API that lets you create more than one Employee with a single request. link is - Web API Tutorial - Level II - Appian 23.3 so, please anybody help me on that, how to create or implement that? Thanks in advance.

I have a process model that has multiple sub processes for a project. Each sub-process references the project name that was created at the beginning of the process. The project name is retrieved by calling a rule that then saves to a process variable. At a sub-process further down the life-cycle, there is a user task (a) and the process is waiting for the user to complete the task. Outside of this process model, anyone can go and update the project name. The name is then updated in the database. My issue is that at this point (a) while waiting for the user task, the project name is not being updated even though the database has a new name and  the process variable being reference is calling a rule to get the project name. All further sub-processes after (a) gets the updated project name. Only at (a) where the task was waiting to be completed when the name change occured, is not updated.  Does anyone have any idea of how to resolve this?

Does anyone know if there's a maximum document size restriction for the Send File Over SFTP smart service?

Hi team! I have created a Robotic Task for automatic input in RPA, and it works fine when I test the Robotic Task, and when I run the process with Execute Robotic Task in the Process Model, the Robotic Task works fine as well. However, when I go to the Operation Console and click on Test Connection in the Manage Connection of the robot running the Robotic Task, the following error occurs: Error: Active user sessionUnable to sign in because the resource has an active session. Sign out from the active session and try again. Troubleshooting does not tell me how to sign out from the active session exactly. My understanding is that if I can sign in with this, the robotic task will start automatically. Can anyone help me with a solution?

We are experiencing an intermittent problem with Send Email node in a process. On the front end, the error is 'Failed to send email'.  On the stdout log, it is stated that the error is caused by: 'jakarta.mail.AuthenticationFailedException: 535 Incorrect authentication data - https://community.mimecast.com/docs/DOC-1369#535'.  According to the given Mimecast web-page, error 535 is due to 'Incorrect authentication data'.   The sender and receiver in this instance was the same as multiple other instances in the same day, which worked as expected, with email going out and being received successfully. Any ideas? Thanks for taking the time to consider this.

Hi All, What is the best way to create multiple appian users from a list of usernames from the database (Each record has the necessary information for the user, name, last name, email etc) ? I'm just confused of how to set up the create user node for multiple users in this case. thanks in advance

The Health Check for my application, for process sizing, has 3 process models that are all taking up about 16GB and 32,000 # of instances.If I reduce the archiving from 3 days to 1 days on each process, it should cut out 10GB and about 22,000 instances.  Would doing this have any positive impact on the applications performance as a whole? Would it free up resources or processing engines in any way where I could see improvements on process models?Right now, I'm seeing sometimes my write to data stores taking .90 ms in some cases and then in other cases, taking up to .300ms (which is too long)  For context, my prod environment has about 853,000 process a day (585,557 completed, 183,000 active)

Hi Team, I have requirement to run on scheduler to create case based on configuration and export some transactional data in the excel file, send an email. In the excel there is one column with datetime type is one of the columns and in the excel always it is exporting as the usertimezone. Example: This scheduler PM always run around 01:00 AM CST and last published designer time zone is GMT.As this user is administrator across platform level, so don't want to change user time zone to CST. Please find below items for reference. 1. I have run the PM in the CST timezone,Stil in the exported excel file taking the last published Administrator account time zone (GMT). 2. I can do it in data base, but i don't see any dynamic function to convert automatically handle daylight savings (Without hardcoding +06:00 hours..etc). Can you please help me out to export excel the column data datetime as CST timzone. Thanks and Regards Venkatesh Suram

I want to calculate number of working days between two dates (record field) and use the output as a custom field in the record. Getting stuck while trying to use calworkDays in a!customFieldDateDiff function. Can anyone please help

Hi All, Getting an integration error :  AppianRPA returned a KO invocation result. we have double checked the below for troubleshooting but still error persists : User has no permission to view or access the robotic process The executionId is invalid or missing The executionId is not in the correct format An invalid API key was used to make the request please help !! 

Hi, I am making an Interface in Appian where I have to show RPA Recourse Status(I.e. If Bot is online then: Online, if Offline then :Offline, if Disabled then status will be show Disabled ).Is it possible to fetch the resource current status and display ?

Hello Guys there is a problem with my Process Model, Below is the Image of error in PM, 

Hi Team, while running unattended automation, Bot/resource frequently going in disabled mode & we have to manually check, make it enable then its goes to running mode again.we are not able to rectify why Bot/Resource is behaving like this and our bot/Resource is not running in fullest unattended mode Thanks Manish