I have added a column in my table as a boolean (checkbox) and just want to run a script on that row. There would be no id in my underlying query for this checkbox.
Is this possible?
Yes, if I understand correctly, you are simply trying to run a query on change of that checkbox?
If that's the case, you can just make the column as editable, and add an onClick event to it that triggers your query. You can pass additional scope as well if your query needs some specific data from that cell.
In the ID field there is a warning "without an id you won't be able to reference the value...". Do I just ignore this?
You can, but if you need to persist the value of the checkbox it might be a bit of debt you are putting yourself into.
2 Likes
Just figuring out Retool and now makes perfect sense. Always an id of course.