Hi, I'm trying to do a bulk update on a table based on two ids, rather than one primary key. Is there anyway of doing this?
@juf
Our GUI mode does not support bulk update based on two ids, unfortunately. Here's a community post that might be helpful! http://community.retool.com/t/how-to-use-composite-primary-key-for-bulk-updates/2406/10
A workaround a past user did was write a query to update each row, then use a map to return an array of triggers on the recordUpdates object utilizing JS promises. Not sure if something like that could work for your use case?
Also, here is a feature request for composite keys, if you'd like to add your +1.
1 Like
As noted in other discussion threads, the workaround of writing a query to update each row has its own limitations since it is quite resource/time inefficient if you are making multiple updates. Would be great to see this feature properly supported soon.