Create View Only Checkbox until certain fields are complete
Hello everyone and thanks in advance for the help.
I have a form for Projects with several users as drop downs to the user table in Quick Base. I also have a checkbox to "Create Template Tasks" which will trigger the automation to create a series of tasks once it is checked. And once it is checked via dynamic forms it is set to become readonly so it cannot be edited in the future.
Now what I need to do is not allow that checkbox to be checked unless several of my user dropdowns are filled out. However, I cannot make them required fields. Let me better explain.
My sales team will open a new project request. They are not authorized to assign a Foodservice Designer, Interior Designer, and Estimator. Our Director of Design will ultimately assign the project to those team members and create the template tasks. So I want her to fill out the three drop downs on the designers, and once that is done select the checkbox to populate the template tasks (since it will use those three dropdowns to populate the assign to list).
Recommendations on how to do this?
Thanks again!
I have a form for Projects with several users as drop downs to the user table in Quick Base. I also have a checkbox to "Create Template Tasks" which will trigger the automation to create a series of tasks once it is checked. And once it is checked via dynamic forms it is set to become readonly so it cannot be edited in the future.
Now what I need to do is not allow that checkbox to be checked unless several of my user dropdowns are filled out. However, I cannot make them required fields. Let me better explain.
My sales team will open a new project request. They are not authorized to assign a Foodservice Designer, Interior Designer, and Estimator. Our Director of Design will ultimately assign the project to those team members and create the template tasks. So I want her to fill out the three drop downs on the designers, and once that is done select the checkbox to populate the template tasks (since it will use those three dropdowns to populate the assign to list).
Recommendations on how to do this?
Thanks again!
