Hi, thanks for the reply.
I didn’t phrase the message properly (or I didn’t understand your answer). The scenario is as follows:
We get an automatic notification from another webpage when a user A made a progress. User A appears in the table USERS which holds all users an the group names. Each group has its own table (CLIEANT A, CLIEANT B, etc.). What I want to do is look in the USERS group, find the client name, and get the table ID from that in order to update the table.
The only way I came with to do so, is to setup a zap for each group and use a filter that will update stop the zap if the user is not in the relevant group. (e.g. for the zap fro group B, the filter will be set to only continue if the group column for the user will read Client B). The drawback with this approach is that I will have to add/delete a zap whenever a group is added/removed.
I hope my question is clearer now.