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 befo...
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)