I’m trying to setup a number of different tables widgets linked by some reference. (Trying to use Grist properly as a relational DB).
For the end users however, I want them to be able to update the field in whatever view they’re looking at. So even if “First name” is a referenced column, I should be able to change it without having to go hunting to find whatever table its actually from.
It would be nice to toggle between a “Design” mode - where I can edit the formulas, and reference pointers, but then drop the users into “Edit” mode, where they can edit all the fields and not have to care about the back-end table structure.