I am fairly new to WeWeb, but learning fast. I have a Datagrid that is populated from Airtable. I have just 3 columns set as Editable. I am trying to setup the workflow with On Cell Value Changed as the trigger. I have it going to the proper id in the Airtable table. The problem is that there is no way to bind the fields to the columnId dynamically, so it only updates the fields that were edited. If I don’t select the fields I want to update, it will wipe out all the other fields as they are expecting all to have updates. There has to be an easier way to dynamically bind to the edited cells only, and only send updates to them? Even with my 3 fields, I would have to select them from the list of fields, then bind newValue or oldValue to each to update, but if i didn’t update it, how can I make sure it uses oldValue, and if it was edited, use newValue? I thought there might be a bind option to the fields that could be tied to columnID, but as you can see in the screenshot, it is only a dropdown list. Hopefully this is clear enough to understand?
Upon further research, some AI, and testing, I think I have it figured out. You have to do a True/False split, if event?.[‘columnId’]==‘Field Name’, then on the True branch, send newValue to only that field. Then repeat the True/False split for each field in the datagrid. Seems to be working, unless someone else has a better method? Thanks
1 Like
you can delete the action in the false and just have it empty rather then having a continue loop there
Ok, thank you for the advice. I just set it because I wasn’t sure if it would error if I didn’t.
2 Likes
Hi Nate, welcome to the community 
I’m glad you managed to solve your issue and I appreciate that you posted your solution so it stays up to serve as reference for other members.
Cheers!