Filters: using previous action's outputs as value

(Khashayar) #1

I’m trying to do something but I don’t know if I’m doing it right. Some help would be appreciated!

The problem at hand is a member registry.

When people register through TypeForm, their Bot Start > USER_ID is sent to a Google Sheet.
This is how people register. They have all their info in a Google Sheet, starting with USER_ID.

Now I want to send members and non-members two different card sets after receiving ‘main menu’

I’m using a Search Rows action as soon as the flow starts to search Google Sheets for all USER_IDs we have on record.

Now I want to filer and say show this (members only) card set if:

Bot Start > USER_ID is equal {{search_rows.results_+_gsx:userid}}

Am I doing it right? It doesn’t seem to work.

I’m starting to fundamentally question whether outputs can be values or not!

Any suggested work around?

Thanks for always getting back, team!

(John Jackson) #2

Unfortunately you can’t yet use outputs on the right hand side of a filter condition.

There is a fairly simple workaround, using the code service. You’ll see the technique a little further down this thread (my answer including screenshot):