How to populate choices of a variable field(record producer) with the choices of a field of a table?

[Community Alums]

Hello! I have a field in a record producer, this field needs to show the same options that another field of a table has. Create a variable field with the options manually is not a choice because you need to maintainance the two fields. Any ideas of how to do it? thanks. 

[KB18 · Accepted solution]

Dear Rocio,

You can use customer table and give reference in the variable as Select Box and same way for the table you are mapping with Record Producer.

Please feel free to ask in case any queries.

[Ratnakar7]

Hi @Community Alums ,

One way to achieve this is by using a reference qualifier in the variable field of the record producer. 

Here are the steps to configure a reference qualifier:

1. Identify the table and the field that contain the options you want to display in the variable field.
2. Open the record producer and go to the variable field you want to populate with the options.
3. Configure Reference Qualifier.
4. In the Reference Qualifier field, enter a script that retrieves the options from the other table and returns a condition to filter them. The script should return a string containing a valid encoded query condition. For example:

javascript:'active=true^category=' + current.category

This script retrieves the options from a table where the active field is set to true and the category matches the category of the current record producer.

Thanks,

Ratnakar

[KB18 · Accepted solution]

Dear Rocio,

You can use customer table and give reference in the variable as Select Box and same way for the table you are mapping with Record Producer.

Please feel free to ask in case any queries.

[Community Alums]

Hello! Thanks for the help. It works, but i need to do the same in the backend (table). Do you know how to do it in a field of a table? Because, there is no select box, just choices type field. And I dont have te opcion to complete the same that in the image you sent. Thanks.

[KB18 · Accepted solution]

Dear @Community Alums 

Yes, you can use the choice field and refer the below screenshot to configure.

Please feel free to reach me in case any queries.