Skip to main content
Solved

New checklist field from field duratio input

  • September 27, 2019
  • 0 replies
  • 42 views

Hi All,

I have a field duration. If the workshop duration is more than 1 day, it's possible to create field automatically based on input of  field duration.

For example, duration is 2 (days), it will create new 2 field  - day 1 and day 2. If duration is 3 (days), it will create new 3 field - day 1, day 2, day 3 and so on. The field will contain checklist - attend or not attend to track workshop attendance for each day.


Many thanks


------------------------------
Syaeful Bahri
------------------------------

Best answer by MarkShnierYou

This would be done using Form Rules. 

 He would create say Five sets of fields assuming that a workshop with never go more than five days. Then you would use form rules to control which set of fields open up. You would end up needing Form Firm  rolls one for each additional set of fields.

 If workshops are able to go more than five days, you might want to consider a different application design where one workshop record has many workshop day records. 


------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
  • Quickbase Alumni
  • Answer
  • September 27, 2019
This would be done using Form Rules. 

 He would create say Five sets of fields assuming that a workshop with never go more than five days. Then you would use form rules to control which set of fields open up. You would end up needing Form Firm  rolls one for each additional set of fields.

 If workshops are able to go more than five days, you might want to consider a different application design where one workshop record has many workshop day records. 


------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------