Records

I have two variables of list type,  local!selecteddata: { id:1, name:test1, id:4,name:test4}.   local!data:{id:1,name:test1,                  id:2,name:test2,                  id2,name:test3,                  id4,name:test4 } if I update the "name" fields of local!selecteddata,How do I index local!data and update the field "name" for ids : 1 and 4 . Any help is appreciated 

Hello,  I'm trying to use a dynamic field to allow users to add more text inputs for email addresses. Currently, the email address fields all show whatever the most recent text added is--only showing the same email address in all of the boxes.  What am I doing wrong? Thank you for any help.    { a!columnsLayout( columns: a!columnLayout( contents: { a!richTextDisplayField( labelPosition: "COLLAPSED", value: { a!richTextItem( text: "Notification Recipients", style: "STRONG" ) } ), a!forEach( items: local!emailNotify, expression: { a!sideBySideLayout( items:

Hi, I have a variable of type document and another of data entity type where I need to store the documents, in all the process models I have this: but in just one case the documentId is not filled hence I am getting an error when trying to use the cmcDocument variable. In database it is inserted as expected: the instance:  I don't know what can be the problem as in other process models it is working and there is no difference between those processes

Hi All I want to create custom search box for my main record type, whenever any user enter any value in the search box the data should be filter by the this value, this value should be compare with all the record types which have the relationship with my main record type  

Hi, Could you please help me with the below requirement Sample Table and Data RequestTable id name       email                 createdOn            createdBy1    N1   n1@mail.com 2020-07-27 13:15:30 n1@mail.com2    N2   n2@mail.com 2020-07-27 13:15:30 n2@mail.com3    N3   n3@mail.com 2020-07-27 13:15:30 n3@mail.com4    N4   n4@mail.com 2020-07-27 13:15:30 n4@mail.com2    N5   n5@mail.com 2020-07-27 13:15:30 n5@mail.com Conversation: id  reqId    message       sentBy 1    1            Xyz         n1@mail.com2    1            abc         reviewer1@mail.com3    1            pqr  &nbsp

Does anyone know why apprian would show that a table has multiple primary keys, when the table only has 1 primary key, 3 foreign keys and an alternate key?

Hello all, Just checking to see if anyone knows how to sort a grid's field when the data property is not a typical query. Please see code below for what I mean. The grid displays as expected with values and all, but when trying to sort the fields I get the error in the Subject above. Are there any other ways to sort other than [recordType.field] or [recordType.relationship.field]? I did see an earlier post solution on here with similar error, but that scenario was quite direct working with recordData for the data property of the grid. Any input regarding this particular scenario would be much appreciated. Thanks a!gridField( label: "Grid for ", labelPosition: "COLLAPSED", emptyGridMessage: "No reports for this day", data: index(local!reportsPerDayOfLastSevenDays, local!selectedDay), columns: { a!gridColumn( label: cons!LABEL_NAME, sortField: 'recordType!{8360b17d-94c9-478d-af7a-8e685ada463b}LNU Rep Sched.fields.{f

You need to create a record type with data sync enabled. What are the supported data sources. Options:- A- Web services, Salesforce, Database B- Web Services, Process Models, Database C- Salesforce, Process Models, Database

I've a record with a title that contains reference number and status of the record. On the summary view, I've a checkbox with a button something similar to "I agree to terms and conditions....". I configured the button to trigger a process using start process smart service where the details about the acceptance of the above terms along with the status updated. Inspite of activity chaining in the process, the status of the record doesn't get refreshed, until I refresh the page manually. Is there way we can update and refresh the record status in the record title? Note: This record status updates automatically if I use any related actions on the record. However, the above is not a related action, but just a button to trigger a process.

Hi, I wanted to ask something related to this sync data in record types. As we know, after the record type exceeds 4 million rows, the record data will become unavailable. But we need more than 4 million rows of data from the database, and now I want to use source filters to divide up that large data source into multiple record types, based on timestamp. And the question is how would you do this and what could be the best way so we can have only 4 million latest data synced, but others to be stored in another record type? Thank you

Hi , we are facing multiple record sync failures in PROD , do we have any feature or option to  automate record sync failure in appian ?  please suggest  , Thanks in advance.

Hi, I am new to Appian and learning by doing hands on exercise. i am not able to find the cloud database option in the settings ( 9 dots). i am using new Appian Community Edition beta, please follow this link: https://us.appian.community/suite/sites/home.

I have the following queries related to Data Fabric: Is Data Fabric feature available in Standard capability tiers in 24.2? Is Data Fabric and Data Fabric Insights different? If Data Fabric feature is not supported in the Standard tier of 24.2, how to use reports created in the old version (24.1)? Please share your input.

I have Created a Report Using Data Fabric Self Service Analytics with Grid. If I wanted add any User Filters i didnt find anyway to do that. By Default Filters are there but Post Creation of the Report, if we want to filter the data i am looking for. Please do let me know if is there any way to it Thanks, Praneeth.

Is there anyway by Using the Chatbot I can be able to Access the Application Data ? Thanks, Praneeth.

Hi All, I have requirement where i need to clone "Users" system record. we are in 24.1 and create record from record source is not available. when i tried to create using webservice its not allowing query functions.  Is there a better way to achieve this?  Thanks,

Given a list of files, having obtained the list of their relative sizes, I have to iterate on the list until I obtain a maximum size (for example 10MB) and from the next file start again with the same process, iterating until the end of the list

Hi All, i am stuck in one scenario, i just want to create interface where rules would be displayed ,added and updated. i want to list all the existing rules to be display like below screenshot. There are several products with base prices and i want to set some tax percentages as per the product and countries. and my appian records are like below screenshot.

I use the related actions of the record type to change or delete records. The flow is as follows: ①Click the "Inquire" button from the list (button of record action)②Click the "Delete" button on the inquiry screen③The inquired record is deleted.Suppose that Mr. A and Mr. B are viewing the listings at the same time. In this case, if Mr. B tries to open the inquiry screen immediately after Mr. A opened and deleted the record, an error will occur. (Error message: An error occurred while applying the context of the related action)Is it possible to handle this error?For example, to move to a screen that displays an arbitrary message, etc.Thanks

Hello! Im having trouble trying to resolve this. I have a record Action that can be activated only when a client goes to the Activity Log "Customer Registration retries on: 28/06/2024 9:23 GMT-05:00" three times, but im having trouble for the query to find me that activity log without the date.

I have a record that I use in many interfaces, querys. I need to change the data type of a column in the database. If I make this change, the references to that field are lost and I have to edit all the objects that use the field from that record to reference the new field type. This can be avoided somehow. That is, appian updates the reference of the record.field automatically.

By Using a!recordsChatField() we can get the One Particular Identifier data and its Related Data. But If i wanted to get data for Multiple Identifies. Example : I am having employee and Education Details and Address Details and Certification Details. Now i want to get the Details employees who are L2 Certified and Who Qualification is MCA ? Is There any way to do this by using or Records Chart Field or any Chatbot. Please let me know is there any way to do this. Thanks, Praneeth.

I have a record type called : Global Case  the fields for this record type are : caseId : Number (Integer) , caseTypeId : Number (Integer) Now this record is related to another recordType called : Global Case Type  the fields for this record type are :  caseTypeId : Number (Integer), caseTypeName : Text My database looks something like this :  Global Case :  CaseId CaseTypeId 1 1 Global CaseType CaseTypeId CaseTypeName 1 Dummy Case Type Requirement : I want to display on an UI the case and its caseType in a grid  Approach :  I did a query record type and queried all the cases and then used the relationship to display value. (Code : )  a!localVariables( local!case: a!queryRecordType( recordType: recordType!GCMF Case, filters: a!queryFilter( field: recordType!Global Case.fields.caseId, operator: "=", value: 1 ), pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 1 ) ).da

hi I tried to connect postgresql datasource from appian community environment using connected system but cannot connect.Is something missing in the settings?

In-order to display data over a World map which is an add-on/ plug-in system is accepting the data in : local!test:a!map( 1:{ latitude: "18.1096", longitude: "-77.2975", tooltip: { content: "Jamaica" } }, 2:{ latitude: "35.9078", longitude: "127.7669", tooltip: { content: "Korea (South)" } } ), But while using forEach loop we are getting data from system in below expression and format a!forEach( items: local!getMatchedIntells, expression: a!localVariables( local!id: fv!index, local!name: "", local!lat: "", local!long: "", local!finalDt: a!map( latitude: local!lat, longitude: local!long, tooltip: { content: local!name } ), local!finalDt ) [{'1': {latitude: 23.424076, longitude: 53.847818, tooltip: {content: "United Arab Emirates"}}}, {'2': {latitude: 33.93911, longitude: 67.709953, tooltip: {content: "Afghanistan"}}}, {'3': {latitude: 41.153332, longitude: 20.168331, tooltip: {content: "Albania"