Disable Datapage Based on Record Value in Separate Table

[wimtracking2]

I have 3 table:

1. Programs

2. Sites

3. ProgramtoSiteAssociation

Users can view the Program from Datapage1 (see image) and create an association into ProgramtoSiteAssociation table using  Datapage2 (see image) that offers a list of Sites from the Site Table and receives the Program ID from the Program table. If the Program Status (Program Table, Datapage1) is moved to Inactive, I do not want the user to be able to use Datapage2 and create a new recrod in the ProgramtoSiteAssociation table. 

Is there a way to disable Datapage2 based on the Program table or create a pop-up that tells the user they cannot make an association due to the Program being inactive.

[cheonsa]

On 6/21/2024 at 11:28 AM, wimtracking2 said:

I have 3 table:

1. Programs

2. Sites

3. ProgramtoSiteAssociation

Users can view the Program from Datapage1 (see image) and create an association into ProgramtoSiteAssociation table using  Datapage2 (see image) that offers a list of Sites from the Site Table and receives the Program ID from the Program table. If the Program Status (Program Table, Datapage1) is moved to Inactive, I do not want the user to be able to use Datapage2 and create a new recrod in the ProgramtoSiteAssociation table. 

Is there a way to disable Datapage2 based on the Program table or create a pop-up that tells the user they cannot make an association due to the Program being inactive.

Hi @wimtracking2,

You can disable the dropdown field using Rules. To get the value from the other DataPage, either you pass the parameter or use a Virtual Field > Calculated Value.

https://howto.caspio.com/datapages/forms/conditional-forms/

https://howto.caspio.com/datapages/datapage-components/calculated-values/

 

Hope this helps.