Updating the table editable values

💬 App Building
19

I think if you look at the List View's options you'll also see this:

image
image905×707 48.8 KB

Which creates the property values you'd need for the whole set of list data:

image
image1076×391 28.9 KB

Using these, you can trigger the necessary operations from an outside button and get the release notes data back and/or transform it how you need for the next step in your process.

image
image1524×498 70.8 KB

In the JS you could build in logic to ignore selections that are null or you could disable the triggered query when the additional scope values are null. I think the List View is still the right container for the job, but using Retool has its quirks and caveats.

Simple loop JS Trigger:

let lvData = listView1.instanceValues;
for(let i=0; i<lvData.length; i++){
  await query2.trigger({
    additionalScope: {
      "option1": lvData[i].select1,
      "option2": lvData[i].select2
    }
  })
}

Simple Triggered Query (using additional scope):
image

Definitely worth a design think. Have a wonderful weekend and I hope you find the right solution for your app!

2 Likes