Records

Can we add new columns to User Uploaded excel with columns and data already in it?  Note: The added column's data is not unique for all the records

Hello Team, can you help me with this here, please? I have a form (parent record), which relates to more or less 15 different tables (records). Most of these tables have a 1-1 relationship with the parent record and, in about 3 of them, the parent record has a 1-N relationship. Knowing that all these tables are filled in the same form, and everything occurs in the same process. What is the best approach in this case? Thanks

For the following table of records, I need to be able to calculate the total of the highlighted columns, (Bid Amount & Principle Balance) so that I can utilize that information to create a list of metrics listed below the Picture. Balance Underwritten Sum of Principle Balance Balance Bid Sum of Principal Balance (Where Bid Submitted? = Yes) Balance Won Sum of Principal Balance (where Bid Won? = Yes) Bid to Underwritten % Balance Bid divided by Balance Underwritten Win to Bid % Balance Won divided by Balance Bid Win to Underwritten % Balance Won divided by Balance Underwritten

We would like to be able to access many schemas in Appian when creating a record type from a sql server table. I have the table created on the server that is in or datasource in the admin console but when I got to select the table in the record type I only see tables that exist in the dbo schema

I have a table with a field "name" which is of text type. It follows a fixed pattern and all the entries are very similar. The entries contain text and numerical values, e.g. Practice 1, Practice 2, Practice 3, ..., Practice n where n can be any number. I need to sort it in the ascending order of the numerical suffix. If I sort it as text only I get something like Practice 1, Practice 10, Practice 2, ..., Practice 9 assuming there are only 10 Practices. However, it has to be sorted as Practice 1, ..., Practice 9, Practice 10 as per my requirement. How can I achieve this?I have attached a picture of my code in the query editor below. I tried casting name to integer using the tointeger() function like below but it gave me an error saying we can't cast on a field.sort: { a!sortInfo( field: tointeger(record.name), ascending: true ) }

Hi All, We are getting the following error as startindex cannot be greater than totalCount. Start index was 31 and totalcount was 0. We are using process report query for querying the data and for paginginfo, we are using fv!paginginfo. We are getting the above error only in prod and we are being notified via the error mail as part of the new appian release. No user has reported this issue. We are not able to understand why this error is occuring. One observation was when errors are triggered, startindex is having 11, 21,31,51 etc. Any suggestions will be helpful

Hello community, There is a scenerio where I just want to add a user filter to popup only with the options that are mapped to a record. e.g. there are 10 reference records used in filter and mapping is like:: Record A - 1,2,3,4 Record B - 4,5,6 Record C - 6,8,,4,3,9 Is there any way to just popup mapped referenced values to the filters for selected records.

Can anyone help me on this : - You need to remove an unused field from an existing record type Product, which has data sync enabled and is backed by a database table. What should you do? A. Delete the field from the record type and optionally delete the column from the database table. B. Delete the field from the product Custom Data Type (CDT) and perform a full resync of the record type. C. Delete the column from the database table and perform a full resync of the record type. 

Hi Folks, Can I hide the count in below grid. FYI. I am getting data from array of maps. Regards, Ghanashyam

Data in reference tables can differ across environments, which directly leads to have different primary key values of same reference data in the tables across environments. But, knowing this fact, still some Appian applications use primary keys of reference data as constant, for example primary keys of workflow statuses are referenced using constants rather than their text value. If while deploying or during data migration, primary key changes, then code written using those constant references may break. What is the best approach to code for above use case?

Helo......Just curiosity, what is the limit or best number for entities that can be added in one Data store, I searched in docs but can't able to find the answer. Thanks in advance 

Hi Champs, There is a requirement where we need to send a link to the user so that they can directly click the record action instead of record summary page. Is it possible? Regards, Ghanashyam

How exactly does a write to data store work in the background? - For a single row, it will surely run 1 insert query, what happens when the data is an array? for each row will it run a single query or multiple ones?

Hi All, I would need an help in understanding is there any way i can PIVOT the table data and export it to excel. Currently my table has data I would need the response in excel as  Basically "Questions" column as row header in excel and Answers as row response. Help is appreciated. Thanks in advance

Could you please help me to find out the correct answer for this question?

Hi All, I have a requirement in which i am opening summary page in new tab, and from previous tab i have deleted that record through record action. Now, when I am going on summary page tab of same record, and reloading the UI, It is showing error like  "An Error has occurred. Record does not exist, either deleted or don't have permission " Please help me if there is any way i can replace this message with custom appian UI showing This URL does not exist and 404 - not found  Thanks in Advance, Shree Krishna Tiwari 

Hi Experts, I am using a grid layout and I have rule input of array type, I want to select data present at specific index in rule input, Please help  me how can I get index of array type rule input? Thanks in advance.

Hi there, I need to export data to an excel file shown below. I know it's easy to use "Export Data Store Entity to Excel" smart service to export the material list at the bottom, but could anyone know how to combine the upper and bottom parts together to export to an excel file? regards, L

Yeloow, I am currently working in a use case, I have an array of Entity data where entites from different datastores will be inside this array, I want to segregate or group the entities by their datastore so I noticed one thing while trying this out, [Data Store Entity:"xxxxxxxxx-xxxxxxxxf-9143-xxxxx8c102b00@4872"](Data Store Entity) [Data Store Entity:"xxxxxxxxx-xxxxx-43a9-a20d-3xxxx744b9aae@4872"](Data Store Entity) [Data Store Entity:"xxxxxxxxxx-xxxxx-4adc-b46f-axxxxa5990bd@6308"](Data Store Entity) [Data Store Entity:"xxxxxxxxxx-xxxxxxx-4c81-9ddc-axxxx0d18e9@6308"](Data Store Entity) after the @ every entities belong to same Datastore have the same 4 digit number so I assume entites belong to same Data store have these 4 digit number common, is my assumption right ? can any Appian legend confirm this [emoticon:4191f5ee34e248a29fa0dbe8d975f74a].  

How to query table count from oracle DB and display the result in appian screen? I have used the below "Query Database" smart service to fetch the number of table count from DB. But I receive the below error: "You should enter only a single query in a row." My query - SELECT COUNT(1) AS NO_OF_TABLE_CNT FROM USER_TABLES;   Please help me to get the table count. Is there any other option available apart from using this Query Database smart service?

Hi there, I am trying to convert a CDT to excel,  but notice the smart service "Export CDT To Excel" is "Deprecated". I dont want to save the data into database, then use "Export Data Store Entity to Excel". could you please let me know what I can do here? Regards, Lin

Hello Everyone, We have a use case where in we need to nightly refresh our look up tables( truncate existing data and update if integgration is success)on daily basis. As our application is record centric I am planning to use service backed record to external system.However I have below questions to clarify before I proceed. Do we need to hit the API twice? once to check if it’s success and second to populate the record? To truncate the existing data I am thinking to use delete records. Also, Unsure how serviceback record handles if integration fails. Please let me if this approach is suggestable for the above use case. Thanks in advance.

How can we find difference between 2 cdts and capture the changes in Audit table . what could be the best way to do it . TIA

Hi folks! Good day!! I am facing one issue while configuring the record directly in read-only grid and configure the recordActions But while clicking the Add new role button and clicking the Create or cancel button, I am facing the below issue. Note: This will work properly in the Record under the Tempo site. Could you please help me with this?

Hi I have below code: when i am clicking on add row link value is getting save in CDT structure but not displaying added row in design preview what is wrong in that?