Records

Can we add icons or any images on Record Title?

I'm trying to invoke the a!save() function when an interface loads. Is there any way to save a value into a rule input of an interface without any user interaction?  I've noticed this statement on a forum somewhere "Rule Inputs and local variables in an Appian Interface can only be updated as a direct consequence of a user interaction.". What I'm wondering about is if there is any way to mock user interaction to force a save into the ruleinput? My value is saved in the localVariable. Any suggestions would be greatly appreciated. Jan

Hello, I'm trying to write a record event with specific data of the changed record, using record event as an audit table, but I'm not sure how to get the data of a specific record when I'm writing multiple record in the same node, there is any clue on it?

Hey everyone, when i was doing the step by step i encounter this problemand because of this i cant find the AS_VEHICLE table to continue the exercise.Can someone help me please?

Hi, I've one scenario where i need to display data as per the filter selection, and in filter i have a date range field where user can selection up to 2 years range and data would be displayed on grid as per the filter selection.please suggest best way to do display data on grid and to export data on excel.I am using record type, and i have a date column at backend.

"I'm encountering an issue with updating an array in costAdjustments. The current code is setting the LengthOfMonth field to 6 for all items in the array, but I only want to update specific entries." a!save( local!newEstimates2, local!newEstimates2: a!forEach( items: local!newEstimates, expression: a!update( fv!item, "costAdjustments", a!forEach( items: fv!item.costAdjustments, expression: a!update(fv!item, "LengthOfMonth", 6) ) ) ) ) This isn't exactly what I need. What I want to do is loop through newEstimates and pull data from local!uniqueContractPeriods, which contains three rows of data with the fields: period, periodType, startDate, endDate, noOfMonths, and noOfDays. When the contractPeriodNum in costAdjustments within newEstimates matches the period in uniqueContractPeriods, I want to update the LengthOfMonth in newEstimates with the value of noOfMonths from uniqueContractPeriods. Below is the code I&#3

"I'm encountering an issue with updating an array in costAdjustments. The current code is setting the LengthOfMonth field to 6 for all items in the array, but I only want to update specific entries." a!save( local!newEstimates2, local!newEstimates2: a!forEach( items: local!newEstimates, expression: a!update( fv!item, "costAdjustments", a!forEach( items: fv!item.costAdjustments, expression: a!update(fv!item, "LengthOfMonth", 6) ) ) ) ) This isn't exactly what I need. What I want to do is loop through newEstimates and pull data from local!uniqueContractPeriods, which contains three rows of data with the fields: period, periodType, startDate, endDate, noOfMonths, and noOfDays. When the contractPeriodNum in costAdjustments within newEstimates matches the period in uniqueContractPeriods, I want to update the LengthOfMonth in newEstimates with the value of noOfMonths from uniqueContractPeriods. Below is the code I&#3

what is the difference between Record type and Data Store entity, I am having a really hard time understanding the difference between them, and when to use each one , a real-world examples would be great 

I want to select and soft delete multiple records from the read only grid and updation of DB should be done through process model called in related action. 

Hi community, How we can database table for application in appian version 24.3 as previously we get the cloud database .Now there is no cloud database please help us on this

I have 2 record types, totally Sync, with a relationship One Event to Many Instructions, properly related, as I have a custom record field in Event about a sumatory of an Instructions field which is correctly working... But then, when I query the Events,I retrieve nothing using: local!instructions: local!events[recordType!Event.relationships.instruction]. So I've tried to fill the relatedRecordData field in the query of events but it keeps retrieving nothing, null data. local!events: a!queryRecordType(... relatedRecordData: a!relatedRecordData( relationship: recordType!Event.relationships.instruction ), ... ), local!instructions: local!events[recordType!Event.relationships.instruction.idInstruction], How can this be? Maybe Security, how? Is it just not the proper way to retrieve its data?Thanks in advance

Hello, a!localVariables( local!number: todecimal(370737340900000.00), /* Replace this with your input number */ local!chunkSize: 7, /* Define chunk size (7 digits) */ local!divisor: 10 ^ local!chunkSize, local!chunks: {}, /* List to store chunks */ local!x:a!forEach( items: enumerate(ceiling(log(local!number)/log(local!divisor)) + 1), /* Arbitrarily large number to iterate through */ expression:{ local!iteration:enumerate(ceiling(log(local!number)/log(local!divisor)) + 1), local!chunk: mod(local!number, local!divisor), /* Get last 7 digits */ local!number: round(local!number / local!divisor, 0) } ), /* Reverse the chunks list to maintain the correct order */ reverse(local!chunks)) I want to achieve try to split the big decimal into 7 digit numbers, I want the result in the "local!x" {8765431, 7373409, 370} I hope the question is clear, let me know how to achieve this.

Hello Everyone, There is an issue in Write Records Smart Service Its not giving as output with/of primary keys in the Output section    It works for a record which takes single value as input but not working for array pv!   Please ping if anyone has faced this issue before, We,ve tried everything but nothing is working Thanks in advance.

In a Process Model I have added an Execute Stored Procedure and configured everything very well, in Data in the data source I put the constant with the connected system, in the name of the procedure I put the correct one and I configure the 2 input variables of the procedure, save and it is published fine and when it is executed it returns the error: ERROR: insert_in_din_tbl_tests(character varying, integer) is a procedure Hint: To call a procedure, use CALL. Position: 15, I understand that by default the Execute Stored Procedure executes with CALL without any prior configuration, but rather it executes it by default, so I don't understand how to arrange my execution.

Hi Guys, I have a requirement where the user has to fill in around 5000 characters in a paragraph field, is it possible to store 5000 characters to the database ? 

Hi  I am using Import Excel to  Database Smart service and for Datasource I tried to make connection using Connected System .I called the CS in constant using  CS as its type .But in Import excel smart service , Datasource is defined Text type .Is it possible to give DB connection url string as Text and pass it in constant and then use it .If yes then what is correct connection url string?

this kind of output my SP giving me, and I have used print statement of SQL to print this output,  but when I call SP with the correct input Parameter then it's not returning the result.

Hi All, I'm getting the below errror from the recordtype Can you please help me to find the rootcause for this issue Expression evaluation error [evaluation ID = 4JPG0] at function a!recordList: An error occurred while retrieving the data for "NV_CaseData". Details: Record type is marked as synced, but its data has not yet been synced or its existing synced data has been invalidated. Contact your system administrator. (APNX-1-4198-000) Thanks, Udhaya

Are there any limitations for record actions like how many record actions we can create .

I have asked two developers about the best approach for data management in Appian. One usually uses Datastore Entities and other uses Sync Recordtypes. But, I have seen that there is a third configuration where a RecordType is related to a Datastore Entity (this disable recordtypes relationship). Which best approach is my dilemma. I have heard recordtypes limitations related to database (some datatypes capacity limits) schema, 2 millions rows storage limitation and sync issues. I haven't found documentation about best practices for data management. What do you recommend? Some prefers CDT others Recordtypes.

I am looking for different options in Appian to connect with Mongo DB. Please share your suggestions / experience.

Hi all, I'm a beginner of Appian. I usually see a "export excel" button in a record type at the upper right corner, but I could not see it on a record type. In the record type, the following error is shown. "Expression evaluation error at function a!gridField_23r3 [line 51]: The field [b4975317-48bc-4a6d-9ade-949dece38b46] does not exist." In record type, I cannot see expression code, but the error show the code line... How do I see the code in a record type? What i want to do is to export a data into excel... any suggestion please... Best regards,

Our tenant is currently on Appian cloud version 24.2 and experiencing a real-time aggregation error on a custom record field. When editing the custom record field in the record type view, clicking the 'TEST' button displays the following error: ava.lang.RuntimeException: tvJavaBridge is null We have tried removing the relationship and re-adding to no avail. Also, testing the rule in an expression also yields the same result (see screenshots below). Any ideas of what we could try to alleviate the issue?

Hello, I have a doubt and I am unsure how to proceed.   I have an interface where the individual record rows are displayed in a read only grid where I am using the FK of another table to filter and display only those audits for a specific record. The requirement is to display a different background color in the read only grid of the values in the row based on previous entries. For example   FKID Name Temp Approved 1 Tim 20 No 1 Timmy 22 Pending 1 Timmy 22 Yes 1 Timmy 23 Retired Timmy, 22 and pending are highlighted in the second row because they differ from the first entry. Yes is highlighted in the third entry due to being different than pending. 23 and retired are highlighted because they differ from previous also. I have a record query as below and I feel I need to compare the fv!row[currentValue] against the indexed local data somehow but I am not sure how to proceed. a!localVariables( local!data: a!queryRecordType( recordType: 'ADtable',

Hi Champs, I have a grid where I have a column in which I am showing a recordaction component based on some conditions. So that column can show a button(recordAction) or it will be blank.  Now I have a requirement where I need to first show the row where I have the column having the button and then the rows where the column is blank. Secondly, I need to again sort the data based on the name . I am not sure whether we have a easy way to do the same? Regards, Ghanashyam