Forum Discussion
MarkShnier__You
Qrew Legend
7 years ago.. so are you looking to have these rooms born pregnant by an automation or push a button and the correct children would be created, is that what you are after? yes that can be done. Not sure I can easily explain it in a step by step manner. But is that what you are after?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
MarkShnier__You
Qrew Legend
7 years agoI slept on this and realized there is a no code solution using Automations.
You can make up a table of Standard rooms types. That table would have a child table or Required Std Equipment. The net result is that you would have a table of required std equipment with two columns - the std room type and the equipment.
Then you can set up Automation to to copy records from that Std Room Equipment table subject to a filter off the trigger record that the room type on the record matches the room type of the std equipment record and be sure to populate the field for related room so the child records get attached to the room and are not Orphans.
Post back if you get stuck.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
You can make up a table of Standard rooms types. That table would have a child table or Required Std Equipment. The net result is that you would have a table of required std equipment with two columns - the std room type and the equipment.
Then you can set up Automation to to copy records from that Std Room Equipment table subject to a filter off the trigger record that the room type on the record matches the room type of the std equipment record and be sure to populate the field for related room so the child records get attached to the room and are not Orphans.
Post back if you get stuck.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------