All Collections
Basics
Row ID and Column Functionality
Row ID and Column Functionality
Justin Yan avatar
Written by Justin Yan
Updated over a week ago

The new Row Column function found in the Form or InfoList block is way to pull in your row data without referring to a static row value or Frontly ID. For example, instead of finding the row where frontly_id = 6, you can find the first row where Customer = Ethan Moore

Why is this a big deal? This opens up other options for flows where you don't have the frontly_id available easily in the current context but you have some other value.

Possible use cases:

  • If a user dynamic variable has been entered to retrieve row details from a contact page, a user can easily have their row details retrieved to modify those contact fields. See note below***
    โ€‹

  • As part of an internal ticket management system, using an Edit Form block with a static "Status" value in its Row ID can be used to fetch the oldest ticket matching that value.
    โ€‹

  • A button click that's mapped onto a Local State value can retrieve the first row data matching that column value.

Some notes regarding this feature:

  • The value must be an EXACT match, no partial matches here. The first matching row will be returned, so this method isn't ideal if you have multiple rows with the same data, unless it doesn't matter which one is returned.

  • Using the frontly_id is still highly recommended because it guarantees the correct row, but using another column can be useful in some cases.

  • *** If you incorporate this in an Edit Form and allow the user to modify a field that was utilized to 'locate' the row, saving the changes may disrupt the form due to the altered value. In case you are using this with the Form, we advise to deactivating or hiding the field designated as the Row Column to avoid potential issues.

Did this answer your question?