Jump to content
  • 0

Datapage field label selection from a different table and case dependent?


Question

Hi

Apologies upfront if my questions have been asked before (I could not find the answer). In my defence I am new to Caspio, started testing it last week and now have lots of questions. This one is regarding dynamically selecting data labels on submission datapage based on a field.

Assume I have a shift field and in that field I can select “morning” or “afternoon”. Based on that selection I would want the labels for the next 4 fields to either say “08:00” , “10:00”, “12:00”, “14:00” or, if it is afternoon, “16:00”, “18:00”, “20:00”, “22:00”

The exact times can be stored in a table called Shift_times that would look like this

Shift_name, Period_1, Period_2, Period_3, Period_4

morning, “08:00” , “10:00”, “12:00”, “14:00”

afternoon, “16:00”, “18:00”, “20:00”, “22:00”

 

Depending on what I select on the submission form I would want the labels to pick the time labels from the Shift_times.

Can this be done and if yes how ?

 

I really appreciate any help you can give me!!!

Link to post
Share on other sites

0 answers to this question

Recommended Posts

There have been no answers to this question yet

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