Forum Discussion

CharanR's avatar
CharanR
Qrew Member
7 years ago

How do I block users from adding linked records to the main record once that main record has reached the ""Stop Time"" field.

I have Tables B, C and D linked to Table A. One can only add records in Table B, C or D only through a record in Table A after saving it.

I have certain projects that needs to be closed 1 hour before the meeting. I have the project closing date/time in PST already specified in the form/record.

How do I disable users apart from the Administrator from adding records B, C or D to that particular project once the clock strikes or exceeds the project close date/time (PST). Irrespective of the users' timezone.

I have tried dynamic form rules but they aren't working.
Forms
Relationships
Tables and fields
  • KevinSlider's avatar
    KevinSlider
    Qrew Trainee
    7 years ago
    Hello Charan, 

    I would have actually recommended a form rule to hide the buttons when the condition is true, so that you can allow Admins to continue to add records. 

    I would say also, that you can add a condition in the buttons formula to show "" if the conditions are met, hiding the button essentially. This would not detect user role however.

    While both of these should work, I could see the formula not firing on time, and some added difficulty with timezones.  

    Would you like to try a condition in your formula button?
    If(Now()-tohours(1)>[Date/Time],"",$URL) 

  • CharanR's avatar
    CharanR
    Qrew Member
    7 years ago
    Wow! Condition in the button gave me exactly what I was looking for. Thanks Slider.