Forum Discussion

ElizabethBerret's avatar
ElizabethBerret
Qrew Member
7 months ago

Adding new form fields based on the value of another field

I have projects that run multiple days and would like to record for each day:

(1) Num. Laborers

(2) Num. Hours

I want the number of form fields available to fill to be related to an entry titled "Num. Days". Such that if I enter n days, it creates fields for Day 1, Day 2, ... Day n.

Is there a way to automate this or do I need to manually duplicate the same fields for n days?



------------------------------
Elizabeth Berrett
------------------------------

1 Reply

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    7 months ago

    You should create a new table called perhaps Labor Days and then set up a Relationships where One Project has Many Labour days. The fields will be the date (which you can set to default to today if you like), and the Num. Laborers and the Num. Hours. 

    Embed the child table on the form so you can see the Labor Days entries and Quickbase will also make you an Add Labor Day button for the form. 

    You can easily create a summary field on the relationship to roll up the total hours up to the project Project  

    Here is some help on Relationships.



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------