How can I add a row to a Google Table only if one does not already exist for a person?

Hi @RBailey 

Good question.

Try this Zap action: GTables - Find/Create Row

I have looked at that, in fact, I have used it in other scenarios. As far as I can tell, you can only filter on one field.  In my case, I can have multiple records with the same email address but a different patient name.  A person could file a claim for themselves with their email address but as a parent, they can also file a claim for the child with the same email address.  I am trying to get the third party to send me a “patient Id” to store that would be truly unique but I was trying to come up with a solution in the meantime using email and patient name.

Thanks,

Rhonda

@RBailey 

Try this…

Create a new formula field that concatenates both data points.

Then in the Zap you can map both data points in the search field.

Good idea.  I will give that a shot.

Rhonda

That works.  It seems kind of a hack but in lieu of having any other unique identifier, I guess it’s the only option for now.

Thanks,

Rhonda