Updated formula map to check table content before creating new rows

1

Hello everyone,

Can someone help me with a formula map?

  • I have a Typeform database of raw contact data that comes in regularly.
  • I then click the button (script below) below to add “unchecked” contacts to a useable database (so I can edit the fields)
  • Over time and with a few different users, the “unchecked” has become messy, so if I were to click the button now, I’d get all kinds of duplicate rows in my main database because it’s adding new rows indiscriminately.

Question:
How do I update the below formula so that it does not blindly add rows? it first checks if “Company” already exists in the target database, and if it does already exist, then skip the AddRow for that row.

Current Button
[TypeForm Requests].Filter([Add to CRM?]=false).Company.FormulaMap(AddRow(CRM,CRM.[TypeForm Requests 2],CurrentValue))

Thanks!

1 Like
2

Hi @Dominic_Symons1

You can use the AddOrModify() formula. In the parameters you put the expression that you want to check. In your case, if the company is the same, just edit.

1 Like
3

Ah, that sounds easy enough, let me give it a shot. Thanks.

1 Like
4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.