How to push/remove a value in the list while editing the record in 1 step?

Hi

I am new to Xano. So this might be a stupid question. But I didn't manage to find a good answer online.

I have a table 'files' with column 'variants' that is a list of integers.

I want to remove/push the value in this list.

Right now, I need to do 2 steps

  1. Get a record to basically get the current list ('variants_id')

  2. Edit record (paste the current list from step 1 and then push/remove value from it)

I am sure there is a better way to do it in 1 step.

What am I missing?

5 replies