Discussion Categories

The total number of sync rows with the web source is 136,614 but in the Record List there are only 82,874. After each sync with the web source the number of rows in list are different (80,000 - 90,000).What could be the reason?

Team, I'm following the 'User Centered Design Practices' course on Appian academy which mentions the UX Design Guide. I'm unable to find a link to it in community. Is it found under a different heading now?

How to create list of unique 3 character alphabet code. If i pass "AAA" and 2, it should return "AAB", "AAC". 2 unique codes after "AAA"

I am a bit confused about the differences between the old and new pricing models and would appreciate some clarification. From what I understand: The old pricing model was based on the number and types of users. Each type of user was priced separately (e.g., Standard User at $75, Infrequent User at $9, and Input-Only User at $2). There were also minimum criteria (100 minimum users and 500 minimum Input-Only Users). All plans were fully featured. The new pricing model, however, seems to be feature-based. It appears they are charging based on the features you need, as they not mentioned about users (correct me if I am wrong). I want to clarify : Does the new model still differentiate between types of users like Standard User, Infrequent User, and Input-Only User? Or do they now only consider one type of user for billing purposes? Is there a minimum number of users required to be purchased in the new model, similar to the old model (e.g., the 100 user minimum) or not? I

Hello All, I am currently working through the developer training for Appian and am experiencing an issue trying to add record events to a record type. It worked fine last week for the Vehicle record type, however when I logged back in this week to continue my training, i'm receiving the below error: I felt like that was odd, so I checked security on the application and I'm in as an admin, so the error isn't making sense to me: I had added record events to the vehicle record type last week, and it had worked fine. I just went back to check and it is now showing the same error as well: Finally, checked to see if somehow there were missing precedents and nothing shows: Is there anywhere else I should be looking to resolve this issue, or did something change with the data source over the weekend? I'd like to move on with the training, but need to complete the exercise first!

I have a RecordType STG with multiple Records in it. I need to have that data inserted/copied to another RecordType TARGET. Both have the same columns and data types defined in them. With the exception of Unique Identifiers  (ID Column) in both the Tables, I want the rest of all columns data to be moved from STG to Target. Can you please advise on how we can do this. I was thinking Script Task in a process model, but need some guidance on this.

Appian Community Team, I need to have an Expression Rule that does the below: Takes 2 Rule Inputs: 1. reviewID (Number data type) 2. file (Document Data type, this is Array holding list of documents) I need to write an Expression rule that iterates through the Rule Input file and then outputs a list of Record Data ReviewDocument, this ReviewDocument record will have data points from both Rule Input reviewID and File. Can you please advise on sample code for this.

Data is residing in DB but is it possible to show encrypted data in UI instead of actual value?

We have two variables aslocal!legacyData {"OTHER", "Number Block Request", "OTHER", "CRIS3-AB", "CRIS3-AB", "CRIS3-AB", "CRIS3-AB", "CRIS3-AB"}, local!legacyOrderValue {"JADE844610514", "76944", "SR-01028013", "I4166196233", "I3433620146", "I3433570105", "I6139550170", "I3432220101"}As of now we are getting data in below format But we want to display data in below format

I have a usecase where there are two arrays : one is empty and second one has some values Array1 : {"",""}, Array2 : {1:1,2:2} After removing null or empty values from Array1 using filter function filter(a!isNotNullorEmpty,Array1), I have got empty array which is of List of Varient type Now I want to apply difference function difference(Array1,Array2) Since both are different data types, im being thrown error as invalid types. If I have any values in Array1 like {1:1}, it would be of type List of Dictionary, but now here it is List of Varient since nothing there in the Array. How can I perform difference function operation now? Is there any workaround to convert list of varient to list of dictionary ?

How to get the memory occupied by the knowledge center documents in Appian server? Tried with Admin console -> Monitoring, and it is providing size for the list of documents uploaded/downloaded? My requirements is get the actual space occupied by the knowledge center documents in Appian cloud environment.

We are getting the expression evaluation error that start index must not be greater than total count. We got the scenario from the user when this issue is occuring. For example, there are 25 tasks in a grid. In 1st page, we will show 1 to 10 tasks, 2nd page with 11 to 20 and last page will have 5 tasks. This count is same for 2 users. Both users open the same page and 1st user completes lets say 5 tasks. So for the 1st user, the task count gets reduced but for the other user, the count will not get reduced since he hasnt performed any action in the page. Now when he clicks on the last page icon in the grid, the following error pops up. Any suggestion to solve this issue?? The tasks are being queried from task report.

hi,  I have implemented pagination for an editable grid, but when i select a first row and move to next page the selection remain same , though the row data is different Page1 , i choose the first row Page 2 - first row is automatically selected how do I control the selection in pagination , local!listPagingInfo: a!pagingInfo(startIndex: 1, batchSize: 20), local!pagedList: rule!getData(Id: local!search,pagingInfo: local!listPagingInfo) a!gridLayout( labelPosition: "ABOVE", totalCount: null, headerCells: {}, columnConfigs: {}, rows: {}, selectionValue: local!selectedIndex, selectionSaveInto: { a!save( local!selectedIndex, a!flatten(save!value) ), a!save( ri!selecteditems, if( a!isNullOrEmpty(local!selectedIndex), {}, index( local!pagedList, local!selectedIndex ) ) ) }, /*selectionRequired: true,*/ selectable: true, selectionStyle: "CHECKBOX", validations: {}, shadeAlternateRows: true, borderStyle: "STANDARD", rowHeader: 1 ),

Is there any way to search all our constants for constants with a particular value contained in their list of values? Our options are By name/description, UUID or UI, or by expression. None search the values of our constants. 

Usually once the document is stored in the correct folder, but is some cases it is getting stored in temporary folder and Geeting the error while trying to access the site, so can we know why in some cases document is getting stored in the Temporary folder, is there is any condition to store the document in temporary folder. 

Hello All, I am trying to create a document search feature where the user is expected to search for documents only with document name as input. I have already tested "Content Tools - findDocumentByName()" function and realized that it only works when the full name of the file is provided as input. I want to have the partial name string search capability where the system can output list of documents with names containing the search string. Assuming the document metadata(e.g. doc id) is not stored in DB, is there any way to solve this?

Hii I have requirement to trigger PM on 15th business day of each month so, ( workday( date(year(ri!date), month(ri!date), 1), 13, { null() } )) By this expression i'm getting 15th working day of month bt as we have timer event and in that monthly time recurrence will ask for On Days  So How we can do that ?

Currently in the functions we have to pass the sheet number to extract the information from excel. Is there is any other excel plugin or function to get the data using the sheet name.

Hi All I have one scenario to be handled that -> If the user provides the amount as 0, load – (Minus) value in the payload. I have written this logic but its not working that means values are not loading.a!localVariables( local!crfxRateActivation_cdt: if( rule!APN_isBlank(ri!crfxRateActivation_cdt), rule!CR_APP_QE_getFxRateActivationData( requestId_int: ri!requestId_int, cif_int: ri!cif_int ), ri!crfxRateActivation_cdt ), rule!CR_APP_INT_setFxRatesRequestBody( preferredRate_txt: index( local!crfxRateActivation_cdt, 1, "preferredRate_txt", {} ), fxCodes_txt: index( local!crfxRateActivation_cdt, "tariffCode_txt", {} ), fxRates_int: a!forEach( items: index( local!crfxRateActivation_cdt, "tariffAmountProposed_dec", {} ), expression: if(fv!item = 0, "-", fv!item) ) ) ) The value which I am trying to send is at last logic,Please correct me I

I have to get all the sheet names from the excel document .

Hello,  We have a client that is interested in embedding Appian within an IFrame on their site. They would like to set the IFrame height to fit the Appian embedded Interface to avoid having to scroll within the IFrame. Does anyone know a method within Appian to retrieve the specific dimensions per unique interface? We would like to use those dimensions to size each specific IFrame.  Thank you in advance. 

Hi Community, I am facing a weird issue in one of my environments. I have used richTextEditorField on my interface and have got the following output I don't know why I am getting an extra message (Saving Image in Appian) below my field. Please let me know if anybody has faced this issue, or have any solutionsFYI: The plugin is updated to its latest version The same code is working fine on my different environments.

i want to export grid data to excel part, with graph,i want to export above data with graph to excel

Hello Appian Community, In the project I'm working on we are designing a flow to automate deployments using Jenkins. I have tested Appian APIs to download packages automatically. But when I use the API (https://docs.appian.com/suite/help/latest/Application_Package_Details_API.html)  to obtain package information from an Application, it only returns the packages created in that environment. But I want to download a package that I have deployed using "Compare And Deploy" and therefore I have not created in this environment.  Could you tell me how to download the package that has been deployed? Thanks in advance!

Hi fellow devs, There is a scenario where I have email address available to me like: "testuser@gmail.com" and this email address has some username at the backend like this: "Test_user". Now what I want to do is on the basis of email I want to fetch username. Previously I was using this function to fetch username out of email address: index(getusersby(pv!ccperson,3,1),1, null) (this function gives output in expression rule but in process model don't know why its not working and gives error) but now it seems like this function is no longer working. I am unable to find any other function through which I can perform this functionality, any help in this regard would be helpful.