Hello there!
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 checklist
table.
Is there any way I can perform an inline edit of a JOIN table without using an inline action button?