I have a Retool table which is populated by a
LEFT JOIN statement like this:
SELECT c.*, e.end_of_contract FROM checklist c LEFT JOIN employee e ON c.employee_id = e.id
Now, if I try to perform a bulk update via primary key with the GUI Mode and the "save changes" button Retool returns an error.
GUI mode only lets me select one table, and of course my
table1.recordUpdates won't work because
e.end_of_contract does not exist in the
Is there any way I can perform an inline edit of a JOIN table without using an inline action button?