Foundation

Is there an advantage one over the other? In my current project, using the index with the dot is questioned as bad practice, requesting to always use the index() function, my question is, is this really necessary? what are the reasons? I understand that sometimes it is good to control the default value and set a null.

Hi, Users are getting following error after task completion on task page after submitting the task. This is happening intermitently. "403 Access Denied. You dont have permission to view this page." We are querying a task report and displaying Task list in an interface. User clicks on task link to get access to the task.  User accepts the task and submits the task. On Task submission, sometimes user gets this error. [Screenshot attached] No errors in stdout logs. Did anyone experienced this issue before ? If yes, whats the resolution. Thanks.

local!combinedCriteriaResults: a!flatten( { local!test1.criteriaResults, local!test2.criteriaResults, local!test3.criteriaResults, local!test4.criteriaResults } ), Local variables show there is two items with the same criteriaCode. How can I remove one item and leave the other with the same code?

Hello everyone, we're facing a problem with the dropdown component used from Appian mobile, since it doesn't close the suggestions after pressing on the desired value but it requires the user to click back button. This UX is not very comfortable or intuitive for the end users. Any suggestions for alternative ways for handling such a use case (other than using a picker). I am aware of this older thread with the same problem: Appian Community  Thanks in advance. 

My application is specifically for a local where the decimal symbol used is comma " , " and not a period " . ". So, the decimals will be inputted by the portal users as `5,55` instead of `5.55` So my current code is the following: a!textField( label: "The amount of money for payment", labelPosition: "ABOVE", instructions: "", helpTooltip: "The amount of money for payment", value: if( local!variant_value_for_payment > 0, a!currency( isoCode: "BRL", value: local!variant_value_for_payment, format: "LOCALE" ), null ), saveInto: { a!save( local!variant_value_for_payment, todecimal(save!value) ) }, refreshAfter: "KEYPRESS" ), I've read the a!currency docs and the main question for the best solution for me should be: → How may I be able to forcely make the system reads "100.50" and recognizes as " 100.00" and keeps that format? Thanks from now on

I have a question for those who took the ACD101 exam. ACD100 was revised to ACD101 in October 2023. The reference books currently published in this world are those of "ACD100" (no reference books named ACD101 have been found).  Are the questions asked in ACD101 similar to the content of the "ACD100" reference books, or are they completely different? I bought a reference book for ACD100 without knowing that the exam had been revised, so I am unsure whether I will be able to pass ACD101.

Hi guys, We've installed the Log Reader plugin and until recently it was able read the login-audit.csv file on all our environments. Now, the readcsvlogpagingwithheaders() function fails to return any values on our OAT environment, but works in all our others. I've noticed the path it's trying to read is different on this particular environment.  In OAT, it seems to be attempting to read the log file from: "/usr/local/appian/ae/shared-logs/login-audit.csv" Whereas in the others, it's reading from: "/usr/local/appian/ae/logs/login-audit.csv" Is there anything that could be causing it to try and read from a different directory, and is there a way to change this? It's causing significant issues at the moment and we need to resolve this as soon as possible. Really appreciate any help, Thanks.

/resized-image/__size/640x480/__key/communityserver-components-multipleuploadfilemanager/5d32e8f2_2D00_67fb_2D00_46e6_2D00_8cff_2D00_9dcc2b6c0050-89589-complete/pastedimage1712731195444v1.png I have a read-only grid that displays data retrieved using the record data function. The data appears as expected. However, I need to calculate the Total Amount based on the "Amount" column in the grid, and this total should be displayed outside the grid in another card layout. The issue is that using the record data function, I'm unable to access the data in a separate local variable to calculate the Total Amount. Although I can use the query record type function to obtain the data and calculate the total amount, this approach is not considered best practice. How can I calculate the Total Amount while using the record data function? Please Give me any Solution for this

i want to add comma to separate the numbers after clicking enter key the current output like: 98998997899 but my desired output should be : 9899,899,7899 How can i acheive this....

Hey Everyone, I am facing an issue while getting the groups for a user. We used to make use of function getgroupsformemberuser() from plugin People function version 1.10 jar We need to update the People function plugin to 1.16.0 jar but in this newest update, getgroupsformemberuser() is not supported. Replacement for getgroupsformemberuser() function looked a!groupsForUser() but result set of both is not matching. When I use getgroupsformemberuser(), I get 70 groups list which is absolutely perfect. When I match with the number of groups for loggedInUser from Users in Appian: It shows 70 users Means, getgroupsformemberuser() output matches with actual groups. But when I use a!groupsForUser() appian built in function, it return 72 groups: Conclusion: Output is not matching as it's returning 2 more groups which I don't have permission to view.  Is there any way that these 2 extra [NO PERMISSION] groups can be removed from this result set? I

Hi,  I need to get all the email addresses of the users in the application. I need this list in the dropdown field. Can someone please help here?Thanks in advance!

Do we have any possibility of writing merge custom cells using write to data store entity, Firstname, lastname, city and state are fields from DB. I want to write Name and address but name column should be a merge cell i.e. A1:B1 , same goes with address column. We have the possibility of doing this with the template i.e. keeping this template. But what if, we dont want to use a template then do we have any option.

Hi All, We are facing issue with Export to excel. while exporting we are not  getting data in to the excel sheet we have nearly 350 records only still we are facing this issue.If we give any filters then it is fetching the data otherwise it is exporting with no values in excel.Please find the screen shot How can we resolve this? please provide suggestion

I am currently utilizing pane layout to display data on an interface. Everything in Appian Designer works as expected, I can scroll my data using the pane layout feature. However, when I added this to a site to be displayed on the front end, when I navigate to that site page and try to scroll it does not work. Any ideas on why pane layout is working in designer but not from the front end?

If enough app users upload excessively large profile pictures—and those profile pictures are then used in grids, for example—their application can bog down or crash. Can you limit users to smaller profile picture uploads, downsize pictures upon upload as needed, or create a thumbnail of the original picture for apps that use them? If there's some other way to address this ourselves, lmk. David Kessler

I am creating an MVP that requires users to add specific records for sites and buildings while using the mobile app (offline and online).  My current roadblock is when I'm creating a new building record that needs to be associated with a specific site.  In the create new building interface, there is a site drop down list that a user can select before adding a building name/number. For testing I have two ways to initiate the create building record action.  The first way is through the building record list site page (using the Record List Action to initiate the process), and the second way is through a site page that initiates the create building action.  In the latter setup, when selecting a site I receive an "Invalid Rule UUID field:..." for line 13 in the picture provided. I appreciate any help or insight into this issue.  Thanks!

I am trying to do bulk update i.e. update more than one row at a time using editable grid. Please suggest how to do this

I am trying to execute a process model on click of button which one of the  component in editable grid. Unfortunately. the PM is not getting initiated. Can anyone help what could be the reason. a!buttonLayout( primaryButtons: { a!buttonWidget( label: "Save", saveInto: a!startProcess( processModel:cons!TRA_WriteRecordsPM, processParameters: {recordTRA:fv!item}, onSuccess: a!save(local!success,fv!processInfo), /*onError: a!save(local!data)*/ ), submit: true() ) } ),

Hello everyone, I have a question for you.I am experiencing an issue where some data is not being displayed on a site that is currently under development, and I would appreciate any hints on how to resolve the issue. I recently added a new field to one of my master DBs.We also re-mapped the record types and performed record sync.We're also adding new fields to CDT and republishing the datastore. Based on the above, I performed the process of passing a CDT to the rule input of a certain interface and displaying it. The relevant description isri!○○CDT[recordType!○○.field.××××] It is displayed normally on the editing screen, but it is not displayed on the site. When transitioning to the relevant screen on the site, a process model is running behind the scenes, and process variables are passed to the form.This process variable's CDT is querying the record type.To check if the query is incorrect, I run the same query on a temporary interface, and all values a

Hi All, Is there any way to allow data sync in record type once we already created record type without data sync and related feature? Thanks in advance

Hello Folks, Followed by above screenshots: I have two fields (dropdown and text). Text field comes up when click on plus icon.  Scenario: Dropdown field contains company name. There is a possibility to add manual company name. That's why plus icon will be placed and on click of that shows up text field. I have column in a database called companyName that saves value. Issue here is: Both field saves value into same "saveInto" which conflicts. When I fills up text field it shows dropdown error because value saves into same companyName column. Please see below code. a!localVariables( local!company: false(), a!dropdownField( choiceLabels: local!CompanyLabels, choiceValues: local!CompanyLabels, label: "company name:", labelPosition: "ADJACENT", placeholder: "Select Choice", value: tostring(index(ri!company, "companyName", {})), saveInto: ri!company.companyName, disabled: if( toboolean(not(local!company)), fals

Hi All, am facing an issue, where according to the request the results will be coming to the grid. But when i export the results from the grid, it is fetching only first page i.e 10 rows to the excel . What should i modify, so that it will fetch the entire grid results to the excel export. Do i need to change anything in PM? Please find the reference code. a!buttonLayout( secondaryButtons: a!buttonWidget_23r3( label: "Export ", saveInto: { a!startProcess( processModel: cons!SM_EXPORT_BATCHES_ORDERED_PROCESS_MODEL, processParameters: { batchTransDetails: local!batchDs.data, selectedSiteFulfillStatusId:local!selectedSiteFulfillStatusId, selectedSiteSubOrderStatus:local!selectedSiteSubStatus, isPSM: toboolean( local!isSM )/*orderId:rf!orderId,*/ /*project:"POS",*/ /*fulfillSiteId:4,*/ /*selectedRep:1*/ }, onSuccess: { a!save( local!documentId, fv!processInfo.pv.documentId ) } ) } 

Good morning, In a KpiField component, when it does a sum with a!measure and does not find data, I get the default value "No data available", is there a way to change this default message Thank you so much

Hello, Can someone please guide me with link where can we view our grant4ed Appian certificates along with their expiry dates. Thanks in Advance

Hi guys, Is there a new limit to how many rows can be stored in a process variable that is marked as multiple? I made a query that returned 146 elements and the length of the ac!variable is 146 but in the pv!variable there are only 101 elements. Everything after the 101st element seems to have gotten trimmed out.