Duplication of form creation

Jimmy · 11/27/18

Duplication of form creation should be highlighted to the user while creating a new forms based on the parameters is this possible.?

Andrée Starå · 11/27/18

Hi,

I don't understand your question. Can you describe it in more detail?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Jimmy · 11/27/18

Andree..

Appreciate your support.

Below screenshot you will find I created two rows with same data..

Would it be possible I someone input the duplicate data using the form it should popup a message( information already exist so that no one enter duplicate data and add a new row )

Instead of adding the same duplicate row its should popup line already exist something like this..?

Andrée Starå · 11/27/18

Happy to help!

Unfortunately, it's not possible to get a message in the form about it, but it could work to get an update request sent if there is duplicate data already in the sheet. Do you want to check a specific field or a combination of fields?

Would that work?

Best,

Andrée

Jimmy · 11/27/18

Combination of fields.Could you please provide the steps how to do it.

this means, if there fields are same it should send an email to the user that he has submitted a duplicate entry.

Thanks

Jimmy · 11/28/18

Hi Andree,

Can you please support here..Thanks!

Andrée Starå · 11/28/18

If possible, I would use a combination of the JOIN function and a checkbox column type.

Add a new column and add the formula below (change the column names as needed)

This formula will JOIN together the columns chosen in a string of text.

=JOIN([Request Name]@row:[Assigned PM:]@row; " ")

The same version but with the below changes for your and others convenience.

=JOIN([Request Name]@row:[Assigned PM:]@row, " ")

Add another column and set it as a checkbox type column (change column name as needed)

This formula will check for duplicates in the text string created with the JOIN function above.

=IF(COUNTIF(Join:Join; Join@row) > 1; 1; 0)

The same version but with the below changes for your and others convenience.

=IF(COUNTIF(Join:Join, Join@row) > 1, 1, 0)

You could then add an Alert and Action update request rule that would trigger from the checkbox combined with a date or something else to only trigger for the latest entry that is a duplicate.

Would that work?

Best,

Andrée

Jimmy · 11/30/18

Hi Andree,

Getting an error with the formula.

Also can you help how to set the alert and action so that when the auditors try to submit the duplicate form he get an trigger automatically

Andrée Starå · 11/30/18

Where are you located?

The formula is different depending on your region.

It also looks like you need to change the column name or the reference to it (Join) in the formula.

Best,

Andrée

Jimmy · 11/30/18

Didn't get you..please fix the error the screenshot

Andrée Starå · 11/30/18

Where are you located? (which country?)

The formula is different depending on your region.

It also looks like you need to change the column name or the reference to it (Join) in the formula.

Best,

Andrée

Andrée Starå · 12/31/18

Hi Jimmy,

How did it go? Did you manage to get something set up?

Happy Holidays & Happy New Year!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Duplication of form creation

Comments

Categories