New blocks that would allow retrieving and editing a database row with dynamically chose columns.
Blocks:
- Get Row by ID with Dynamic Columns
- Inputs: column 1 name, column 2 name, 3, 4, 5
- Outputs: column 1 value, col 2 val, 3, 4, 5
- Update Row with Dynamic Columns
- Inputs: column 1 name, c1 val, 2 name, 2 val, etc.
Right now I have to use Update by Value or Create for updating and there’s no way to do it for editing (that I know of). Unfortunately, I have to manage my own unique identifier to be able to target a known row with this block. I attempted to put in “id” but it had an invalid dropdown error and when it ran the block itself it had apparently cleared out the value.