Discussion Categories

This is an issue that was initially reported on a Site and I could not replicate it when testing in any browser, until I thought to test on a separate monitor (not my laptop screen). When testing on the monitor was able to replicate in Chrome & Edge through the Site, through the top-level parent interface, and through the interface that contained the dropdown (although for the customers instead of a refresh, it was causing the entire page to turn grey). Can only replicate the issue on my laptop screen through the interface, not through the Site. I have reached a resolution for the issue (updating/deleting rows in the database or logic on local!choices to replace nulls with "Unknown") but sharing since I was not able to find anything when I had searched online. Believe the issue was caused by a user deleting some of the data for a couple rows before using the "Delete" icon/button that had been set up. The case was the query pulling in the data did not have a

Hi Team, Looking for a function which can provide hours and minute difference between two date and time considering business calendar. calworkhours() only provide hours plus it rounds off it to nearest hour. Looking for below calculation : Start Time : 20/04/2023 10:00 AM End Time : 24/04/2023 11:30 AM Output -  hours : 17 , minutes 30 Calworkhours output - hours : 18

I need to get the admin group in an specific app where the app name is going to be a rule input. Any suggestion? is there anyway to achive it?

Hello,  The custom javascript plugin being hosted in an extra domain.... it cannot forward back to appian the authentication information coming from the parent. So http calls made by the custom plugin cannot be authentified in appian. Is there a way to use an  appian webapi,servlet from a custom javavascript plugin with authentication included ? Thanks in advance  David L.    

Hi All, To display wait time which is waiting for more than a day. We are converting createdDate(date time format) in days and hours. Now, ask is to display the WAIT TIME only when it is more than 1D 0H.But, queryFilter field is createdDate(date time format). In that case how can we display this.Query Filter which I'm using at present  (I know it's not correct), could anyone help me in getting this expression correct.

Hi , I am getting below error the attached code when there I don't pass value for ri!gLLs. Can someone please help in resolving this. "Expression evaluation error at function 'remove' [line 67]: Invalid index (0) for list: valid range is empty" a!localVariables( /* Appending logged in user with GLLS from LUContacts if logged in user is GLL */ local!isLoggedInUserGLL: rule!APN_distinct( if( rule!APN_isEmpty(ri!gLLs), {}, if( and( not( contains( touniformstring( index( a!groupMembers( group: cons!RGRACSLBL_GROUP_AGLL, direct: true(), memberType: "USER" ), "data", {} ) ), touniformstring(ri!loggedInUser) ) ), or( contains( touniformstring(

Hi Guys, Our client checking the node timings for each step in the process in that time we noticed the simple expression rule took around 1 to 1.5 seconds, however the same rule checked in direct expression rule it took only 1ms. Can any one facing this type of issue? Any solution for this. Please find the below examples, Example: Obj: Sharing simple example below which i done for testing perspective. Expression rule logic: elapsedtime(now(),now()+52) => took 1ms Call the rule in process model(without activity chaining) => took around 500 ms. Thanks, Pradeep Sridharan

Hello, How can we get value after an operator for the value which we separate using split function. Eg. 249.5832 Using Split for 249.5832, we can get 249 and 5832. But, I want value after split. If I index with 2, it's getting 5832, but I have to use this for a!forEach for the below expression. For below expression, getting the result as in the image local!calP1days: a!forEach( items: local!P1, expression: if( a!isNotNullOrEmpty(fv!item), split(fv!item,"."),{} ) ) , local!calP1days)

Hi, I was able to pull list of users from the group call "AA ADMIN" by using a contact "AA_ADMIN". Now, is there a way I can pull the email addresses of these users. Any advises please. a!localVariables( local!listOfUsers: getdistinctusers(togroup(cons!AA_ADMIN)), local!listOfUsers )

Hi team, I am Exploring Excel RPA , docs.appian.com/.../actions-excel-license-required.html I want to get values into Excel cell as columns  which are stored in DB, i have a CDT name resources with fields EMP-ID and Name, i Added some values in DB creating record actions. then Using Write into Excel Action in the value Array I  tried using both record type and CDT  recordtype!resources.name / 'type!{urn:com:appian:types:ERP}ERP_Resources'(), But when i use CDT I am getting the fields in the CDT like EMP-ID and name ,but not the values in the DB. as shown below i came to know that we have to give the List of CDT's  in value array , but I don't know how to do it to get the values under Name column . Help me in Finding more resource to know more about the Excel RPA configurations. Thank you  J Vinay

Is there any log which will tell which object is causing the exception ? 

Hi All, Our customer wants a functionality in Appian where let's say they took screenshot or snipped an image from anywhere and they should be able to paste into Appian without saving it to folder in their computers. basically they do not want to use File upload field which source a documents saved in the computer instead just snip an image and paste into Appian. Is something like this is possible or exists in Appian? Thanks

Recently I tried to configure Appian on Kubernetes for desktop development but was informed that I needed to have a license for Self Managed accounts. This is confusing to me as I have been able to download versions of Appian since 2018 and install on local servers with no issues, licenses have been granted every time I make the request. In my opinion, these downloads and installations are self managed as Appian surely does not maintain the servers I have my installations hosted on. Can anyone help me understand the difference between the ability to download and install (what I call on premise) Appian environments and what are called Self Managed environments? It really makes zero sense to me and hoping someone can shed some light on this. Apologies if this is duplicated anywhere, didn't really see anything directly related.

Hi Team, Can we download the list of users present inside a user group in a specific app on Appian.  What is the best way to get the list of the users that have access to specific app on Appian.

process model

a!forEach( items: local!milestonedata, expression: { a!gridRowLayout( id: fv!index, contents: { a!paragraphField( value: { fv!item.milestone }, saveInto: fv!item.milestone, characterLimit: 1000, required: true ), a!dateField( value: { fv!item.milestoneDate }, saveInto: { fv!item.milestonedate, a!save(fv!item.projectId, local!data.projectId), a!save(fv!item.phaseId, local!data.phaseId), a!save(fv!item.isActive, true), if( isnull(fv!item.projectMilestoneId), a!save(fv!item.createdOn, now()), a!save(fv!item.updatedOn, now()) ), if( isnull(fv!item.projectMilestoneId), a!save(fv!item.createdBy, loggedInUser()), a!save(fv!item.updatedBy, loggedInUser()) ) }, required: true ), a!dropdownField( label: "", labelPosition: "ABOVE", placeholder: "--- Select a Value ---", choiceLabels: rule!PLT_GetReferenceDataStatus(parentId: cons!PLT_ParentId[6]).Name, choiceValues: rule!PLT_GetReferenceDataStatus(parentId: cons!PLT_ParentId[6]).referenceId, value: fv!item.statusId, saveInto: fv!item.statusId, se

expression rule

Hi Community Team I have a query, I need to configure the formlayout buttons. Like Approve and Reject 1. When I click on a Submit button first time, a textfield needs to be populated. It is populated then I click on the submit second time, It Needs to store the textfield field data  into the DB. But, here I'm facing issue, When I click on Submit Button Firsttime.. tn the Process Model the action is completed.. Unable to add data to the textfield. In DB is showing Empty. For the textfield I applied ShownWhen: ri!Cdt.Status = true(), 2. When I click on the Cancel button first time, a Textfield needs to be populated. It is populated then I click on the cancel button again, No actions were taken. I want it to complete the action. Needs to store the textfield field data  into the DB. Similarly, here also For the textfield I applied ShownWhen: ri!Cdt.Status = false(),  Status is a boolean fie

As you know, there should be an email address link at the bottom of the screenshot for sending email by click on it. But I cannot see it now in both 22.1 and 22.2, does someone have any idea about it?

What does the outputs represents? How to get a process model variable into the RPA's local variable? Is there any way to send process model variables into same RPA from where it was triggered?

Zuuuuuuup people ! So, I'm trying to create a screen to upload files,, between 2 interfaces. Since I need to send files to process model, I need to set rule input. But, When I try it, the following message is poped up: Is it possible to send those files without using rule input ? I've tried to set rule input at button submit click, without success.

Dear all, I'm facing an issue regarding the full sync of a RecordType via Smart Service, which contains a field with Unique constraint This is what I'm trying to implement: First, a large amount of data (several thousand rows) is uploaded to my database table. In that process, first the old data in the database is deleted, because appending the new data would violate the Unique constraint. After the new data is in my database table, I want to do a full sync on my RecordType The problem is, the sync via Smart Service results in an error due to a violation of a Unique constraint. The source data does NOT violate this constraint. I'm pretty sure the issue is that Appian still holds the old data in the RecordType. So when trying to sync the new data, Appian compares old and new data with the same Unique field, which results in the error. This error does NOT happen when triggering a full sync manually. I guess to make my approach (syncing via batches and Smart Service) possib

I'm using "Copy document" and "Export  Data Store entity to Excel" smart services in a process model to generate a excel sheet. While the sheet is generated when the contents are displayed, the cells don't fit to the width of the contents within them. In excel we can generally expand according to the width of the contents by selecting all rows and columns and double clicking in the middle of any two columns. But that is after generating the file. So, I want this columns to be auto adjusted or expanded while generating itself. how do I make this happen? Now, How I need it to be, Thanks, Shravan

I created my service account in google cloud console and gave the account owner role. When i create the connected system and i test the connection it works good but when I use it on an integration it crashes. I used to do this by my own with a normal connected system and it worked good, but now I need to build it with a service account.

So, I have a relationship between these record types. I'm trying to put the value of the record type's data field into a value and saveInto parameters. It just doesn't work on the integer fields, only successfully on the text fields. I'd appreciate any feedback regarding this.  The field is correctly an integer, as is the data type in the record field.  recordType!ASK Request Item.relationships.dsSNR.fields.serialNumberQuantity a!columnsLayout( columns: { a!columnLayout( contents: { a!dateField( label: cons!ASK_TEXT_LABEL_NEED_BY, labelPosition: "JUSTIFIED", value: ri!request.needByDate, saveInto: ri!request.needByDate, required: true, validations: { if( today() > ri!request.needByDate, cons!ASK_TEXT_VAL_INVALID_DATE, ""