Select a row from a table and pull a value from that same row

asked one day ago

I need help with a table that’s populated from a data source. I have two main requirements:

Single Row Selection:
I want to ensure that only one row can be selected at a time. For example, if the first row is selected and I then select the third row, the selection (radio button) in the first row should automatically be deselected.
Retrieve "Remit Number":
When a row is selected, I need the value from the "Remit Number" column of that row to populate a single-line text field labeled "Selected Remit Number".

I believe this can be handled with JavaScript, but I’m open to other solutions if there’s a better approach.

Thanks in advance!

Java LF Question.png (17.98 KB)

| Download

0 0

replied 12 hours ago

To set the value in Selected Remit Number field:

=IF(EQ(INDEX(Remits.Select,ROW()),<value of select field when filled>),INDEX(Remits.RemitNumber,ROW()),NULL)

To only allow one selection in Select field, you'd have to change the field type from radio. A radio field with only one option will not allow you to deselect it, so it would work better as a checkbox field. With the checkbox, the JavaScript would work like this: when one check box is checked, uncheck all others. That said, it might make more sense to change your approach to select the row by using a dropdown field that contains the values of Remits.RemitNumber instead. The method would be similar to this.

1 0

Question

Question

Select a row from a table and pull a value from that same row

Replies

Sign in to reply to this post.