Skip to main content
vaddhicharanc0001
vaddhicharanc0001
March 30, 2022
Solved

Drop Down values - Records

  • March 30, 2022
  • 6 replies
  • 1 view

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

ID_A(PK) Job_Role Company_Name
1 DBA ABC.ltd
2 SysAdmin ABC.ltd
3 HR ABC.ltd

Table - B is as below

Member_ID Name Phone_Number ID_A(FK)
1 SSR 1234567890 1
2 RC 0987654321 1
3 NTR 6789054321 2
4 RRR 1234567098 2
5 MB 0984562348 3
Best answer by stefanhelzle0001

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',
  {}
)

6 replies

stefanhelzle0001
stefanhelzle0001
Brainy
March 30, 2022

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.

vaddhicharanc0001
vaddhicharanc0001Author
March 30, 2022

Will try this!

Terms & ConditionsAccessibility statement