I need separate row in my table for each multiple checkbox (if selected)values in the form

Queries and Resources
1

image
image800×260 24.2 KB

image
image830×346 59.7 KB

case condition is not working in the insert query.

2

Hi @Jame,

You're missing the }} after {{affordableFloorPlanProgram.value[1] (on the line highlighted in red.

3

thanks..still having issue
image

4

Is it correct to add 'case condition' in between insert statement in retool?

5

it look like you want to write a query that includes the CASE and then to insert the results of the query. You are currently inserting values which should just be a list of values.

The form for a query insert should be something like:

INSERT INTO foo
SELECT 
  bar.buz,
  CASE 
    WHEN bar.buz = ‘cond1’ THEN 0
    ELSE bar.array
  END
FROM
  bar
WHERE
  bar.limit = ‘limiting criteria if needed’

Or you can use a ternary operator instead of the CASE when creating your list from variables: