Jump to content
  • 0

Disable Datapage Based on Record Value in Separate Table


wimtracking2

Question

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.

image.thumb.jpeg.7b8a2d81dad5ce53059045e4195d8fa2.jpeg

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

  • 0
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.

image.thumb.jpeg.7b8a2d81dad5ce53059045e4195d8fa2.jpeg

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.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...