Assign values to columns in specific row(s) based on user selection

Ask for Help
, ,
1

Hello Gliders!

Is there a way to write to a specific row of a data table i.e. after filtering on the basis of user selection?

I am trying to create a screen for the admin to be able to edit the morning/evening timings here once the admin user has selected the branch and the day they want to edit.
I tried variety of different ways but either I manage to (i) edit and overwrite the first row in the table or (ii) add a brand new row. Struggling to find and edit the right row based on the 2-variables (branch & day).

My data table looks like this →

image
image1786Ă—508 68.4 KB

(the open and close in the screenshot is in minutes - borrowing from @Loqode’s technique!

So in this example, if I wanted to edit the timings for Thursday for Borivali-MCF Branch - how should I setup my screen? Can I even do this?

2

If you can create a single Relation, or a Query followed by a Single Value → Whole Row, that points to a specific row, then you can set column values through that related row.

3

Thanks @Jeff_Hager, I have something like that in the form of the “Branch-Day Key” however how do I dynamically let users write to the row using this key?

I guess an alternate is to first write the user made changes in a different table and then run the query to update the right row?

4

Like I said, if you can create a relation using that key to a specific row in the other table, then a Set Column action can write values through that relation. You could also directly open an Edit screen via the relation.

1 Like