Can I add a constraint to a field to act just on new records?

replied on July 15, 2014

Hi John,

The only way I think you could achieve this would be to create a new field and use the constraints on that new field. This can independently be assigned to documents you need it on. Or swap out this new field onto the template and use the same method to apply the old field. You could get workflow to do this for you as long as you could work out the conditions.

Hope this helps John!

0 0

replied on July 15, 2014

Thanks Chris, I think that's what I'm going to have to do (copy the existing values into another field). Problem is I've got a Affinity and other saved searches and need to make sure they will find the existing field values where necessary, but I'll just have to work through them all.

Regards,

John

0 0

replied on July 15, 2014

Don't forget Fields are independent from templates so you can move these around quite easily between templates.

Workflow could be your best friend here John

0 0

replied on July 15, 2014

I've already got workflows picking up errors, but all I can do is get WF to email them to correct the field. Unfortunately, you can lead a horse to water but... what I really need is to force the correct format when inputting. A new field if I set one up to move the bad formatted reference to needs to stay on the same template, as I'll need to amend the searches to check this as well as the main reference field. Thanks for the advice though - much appreciated.

John

0 0

Question

Question

Can I add a constraint to a field to act just on new records?

Replies

Sign in to reply to this post.