Use Copy Master Detail Record and Data Validation

Question

Hi,
I'm using the Copy Master Details button. I'm stuck on how to get this functionality:
1. User clicks button2. User goes to new record3. If the user tries to save the new record without changing the text field that is used in the Copy button, a data validation rule would prevent them from saving.
I can't do this because I can't have a unique field and have the copy master detail button work. I thought there was a work around with the custom table rules but can't figure it out.How can I use Copy Master Detail wizard&nbsp;and prevent the user from saving the new record with the same name as the copied record?Thanks community.------------------------------Raymond Sakar------------------------------

quickbasecoachd · Answer

I suggest making a formula checkbox field which will be true if the name of the project (your record) starts with "Copy of"

Then have a form rule which will abort the save if that checkbox is true.

Mark Shnier

Sent from my iPad

raymondsakar · Answer

Thanks, Mark! That worked perfectly.

Forum Discussion

Use Copy Master Detail Record and Data Validation