Warning message when Duplicate entry is done through form
Is there a way to get pop up message saying there is a duplicate entry of the line u entered through form. Something avoids duplicate entry.
0
Is there a way to get pop up message saying there is a duplicate entry of the line u entered through form. Something avoids duplicate entry.
Answers
Hi Prathap,
Unfortunately, it's not possible at the moment to get any message in the form, but it's a great idea!
Please submit an Enhancement Request when you have a moment.
A possible workaround could be to have automation send an update request if the value submitted is a duplicate.
Would that help/work?
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET PARTNER & CONSULTANT / EXPERT
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
Sure will try it now.
Excellent!
Let me know if you have questions!
SMARTSHEET PARTNER & CONSULTANT / EXPERT
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
i tried but there is no clear option. i have submitted ER.
What do you mean that there isn't a clear option?
SMARTSHEET PARTNER & CONSULTANT / EXPERT
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
i mean there is no duplicate check option in the workflow. However, i have figured it out by the formula in the datasheet.
Yes, it has to be checked thru a formula!
Happy to hear you solved it!
SMARTSHEET PARTNER & CONSULTANT / EXPERT
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
Hi,
Is there any option to restrict duplicate entries in option. Please let me know. It will be very useful.
Regards,
Zafar
This my problem too and im very new to smart sheet so need more help
Hi @Zafar & @sara pirie
Not sure I follow!
Can you describe your process in more detail?
How would you want to use it?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET PARTNER & CONSULTANT / EXPERT
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
As a follow up to this, if I have a value range (example gift certificate numbers) for selection, is there a way ot prevent the smae one being picked twice? so it would be removed from the possible selections when it has already been selected?
Thank you kindly
AL
@Al Dawson
I hope you're well and safe!
Excuse the late response.
Crazy times and I missed coming back to you.
Have you solved it, or do you still need help?
Happy New Year & Stay safe!
SMARTSHEET PARTNER & CONSULTANT / EXPERT
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
Dear Andrée Starå,
@Andrée Starå Regarding this duplicate entry restriction - I created a form in Smart sheet where all the employees used to check-in their attendance, but sometimes few of them are submitting twice/thrice on a same day. Hence, I require an solution to stop the duplicate entry in Smart sheet form.
Hope this clarifies.
Thanks,
Zafar
This feature would solve so many problems.
I am using Forms to collect inputs from people and now I have to export to excel and check for duplicates and merge data from other columns. This is a very time-consuming exercise.
Try this formula in a separate field or column of ur master sheet: it should help u to identify duplicate rows.
=IF(COUNTIFS(ColumnB:ColumnB, [email protected], ColumnA:ColumnA, [email protected]) > 1, "Duplicate", "Original")