Update cell, not whole row?

(Hamish) #1

I’ve been playing with flowxo to address a need I have with a bot I’m building on chatfuel, to give out vouchers to users.

Because of my Point of Sale software I can only get a list of predefined single use vouchers.
I’m using Google Sheets.
I was hoping to have 2 columns, fB_id, and voucher code, and to put in all the vouchers code before the promotion. flowxo could then look up and see if a fb user has already received a code and send it to them, or add them to the spreadsheet - BUT the Add a Row function ads a whole row below all my rows with vouchers, and I can’t see how to add the new fB_id to the first first row that has a blank first cell.

Any ideas?

(Karen Barker) #2

Hi Hamish,

You’d need to first search for a row that has a null value for the fB_id column. Once you have found this then you could do an Update a Row task to update this row with the new fB_id.

Hope this makes sense - if you need any further help don’t hesitate to ask. :slight_smile:

(Hamish) #3

And this is possible in flowxo?

Thanks,
Hamish

(Hamish) #4

I figure this out:
I couldn’t figure out how to search for a null value, so instead I filled the whole column with the text “unallocated”.
A initial search for the user ID will return a voucher code and end the flow.
If the results of the search were less than one, I do a search in the first column for “unallocated”. Flowxo returns the first result. I then did an update on that row for user ID, and then send the new row values.

Thanks!

#5

Exactly the same problem as @hamish. While his workaround is good, how to search for null value?
I’ve tried in the field Value:
Empty
null
{{null}}
space

None works, How do you enter null as the value to search for?

(Daniel Beckett) #6

@itzco

The actual search can’t be used to find an empty value but filters on other actions can check if a value is empty.

If you can search for any piece of info on the row that you need you can then have an update row action with a filter for the column being empty.