AnsweredAssumed Answered

Is there a way to prevent duplicate entries in scripted data entry?

Question asked by srbridges on Nov 19, 2016
Latest reply on Jan 8, 2017 by srbridges

I have 3 tables; Contacts, Affiliations and Donations. (All related through a ContactID field.)

 

I have portals (in popover windows) on the Contacts home page showing affiliations and donations for that particular contact.

 

I have a separate popover window that creates a new affiliation using global fields. All that works fine.

However I want to make sure each contact has no more that one affiliation per year. Is there a way to do that? I would like to perform the check before I commit the record, but am not sure I can do that.

 

Any ideas?

 

 

Thanks,

 

Here is the script to create New Affiliation

Screen Shot 2016-11-19 at 8.23.41 PM.png

Outcomes