Fill Text element base on Choose field?

[BigMike]

Hi,

• I have a table People with name and e-mail columns.
• I did setup Data source List people as a List multiple rows - people and added to the Form element a Choose field connected to List people Data source.
• This Choose field has Formulas as follows:
  • Option names - Data records > List people > [All] > name
  • Option values - Data records > List people > [All] > Id
• Next I have a Text field.

How can I populate that Text field with corresponding email?

I tried Single row data source but I don’t know how/where to get Row Id.

Any ideas?

Thank you.

[olgatrykush]

@frederikdc could you please help with this request?

[frederikdc]

You can do this with a querystring parameter. Add a parameter to the page

You can use this parameter to create a data source that returns a single record

Next, use a Record selector element instead of a Choice element and link your List people data source to the element.

Since there is no event to detect a change in the Record selector, you need a Link element that links to the same page using the input of the Record selector as the parameter

Finally, add a Text element and set the text to the data source that gets a single person.