How to edit an array of objects in a form

💬 Queries and Resources
1

In a form I want to edit a list of objects that contains these two fields "stock" and "enabled". The list is dynamic as it dictated from the backend.

My current solution:
For that I created a table and made these two columns editable, and then when the form is submited I linked a js query to the query that submit calls, as a success trigger.

Then on that js query i grouped edited fields for my needs, then call specific sql queries for that via additionalScopes. But the problem is that the sql Queries don't get the values send them from additionalScopes, even though I added it on Additional scope variables.

image
image516×406 10.8 KB

2

Hi @Gzim_Rashiti - can you provide some screen grabs of the queries / code etc please

3

(post deleted by author)

4

Your approach is mostly on the right track—editing a dynamic list via a table and using a JavaScript query as a success trigger to process changes is sound. The issue seems to be with how additionalScopes is being passed to your SQL queries. Even if you've defined the variables in the Additional Scope section, the values won't be passed unless you explicitly return them from your JavaScript query and reference them correctly in the SQL query using the {{additionalScope.variableName}} syntax.