Forum Discussion

JP's avatar
JP
Qrew Member
4 months ago

Scheduling Formula needed

looking to create a formula or rule to do the following interior Date Field to not allow changes if interior status is confirmed and less then 2 weeks from current week.   
formulas
  • MarkShnier__You's avatar
    MarkShnier__You
    4 months ago

    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  

     

jpol's avatar
jpol
Qrew Member

i believe its the old form ... i have a check box formula however when the status and schedule dates are aligned to trigger the check box .. the check box line flashes a red strike through and does not apply the check off ... (the check off box is my trigger on the form rules to not allow the field to be edited. )

MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 months ago

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  

 

  • JP's avatar
    JP
    Qrew Member
    4 months ago

    thanks got it working