Scheduling Formula needed

Question

looking to create a formula or rule to do the followinginterior Date Field to not allow changes if interior status is confirmed and less then 2 weeks from current week.

MarkShnierYou · Accepted Answer

I think the easiest way is to make a formula field called [Lock Interior Date?]

[Interior Status ] = "Confirmed"

and

Todays([Today() - [Interior Date]) <= 10

Then put that field on the form, even in a hidden section and use it in a form rule

MarkShnierYou · Answer

This can be done with form rules.  Can you tell us if you are using new style forms or old style forms?

Sign up

Login to the community