Hi readers,
I would like to know if this is possible, i have a interface where it has a drop down which should have list of values from record types.
example:
In the below table when entering data into Table-A it would be in a normal way; But when entering data into Table-B we need to enter ID_A as well right, So i am thinking to keep a dropdown in this place, where i can keep the list values present in ID_A Table-A
Table-A is as below
Table - B is as below
Discussion posts and replies are publicly visible
You could create a local variable in which you load the data of record A.
https://docs.appian.com/suite/help/22.1/reference-records.html#referencing-a-record-type
Then use that data as choices for a dropdown.
When trying to query the record for drop down i am getting the values as shown in the snip but i want them as numbers just numbers,
To extract keys we have a!keys but how will we get the values
You can use the index() or property() function to get the fields. index(your_variable, "Cluster_ID", {})
I am able to query the database table and get the data as required, but when trying to do with by querying record type i am getting this cluster_Id also tried index or property functions as well its not working
Query code: Output of this is the snip in above comment
a!queryRecordType( recordType: 'recordType!IV Cluster', fields: { 'recordType!IV Cluster.fields.Cluster_ID' }, pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 100)).data
index( a!queryRecordType( recordType: 'recordType!IV Cluster', fields: { 'recordType!IV Cluster.fields.Cluster_ID' }, pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 100) ).data, 'recordType!IV Cluster.fields.Cluster_ID', {} )