Warning message when Duplicate entry is done through form

prathap.krishnashetty69881prathap.krishnashetty69881 ✭✭✭✭✭
edited 08/04/21 in Formulas and Functions
08/14/19 Edited 08/04/21
Answered - Pending Review

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.

Previous1

Answers

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    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.

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Excellent! yes

    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.

  • prathap.krishnashetty69881prathap.krishnashetty69881 ✭✭✭✭✭
    edited 08/17/19

    i tried but there is no clear option. i have submitted ER.

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    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.

  • prathap.krishnashetty69881prathap.krishnashetty69881 ✭✭✭✭✭
    edited 08/21/19

    i mean there is no duplicate check option in the workflow. However, i have figured it out by the formula in the datasheet.

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    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

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    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

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    @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")

Sign In or Register to comment.