Forum Discussion
QuickBaseCoachD
7 years agoQrew Captain
The only way i can picture doing this would be to have an Automation which would create individual child records when the Multi select record is saved. it would need to create a child for every one of the selections, and then based on a relationship to the parent multi select field total up the # of children, and then look that up down to the children so each could calculate what weighting to receive, say 1/3 or 1/3rd.
You would need to start off the automation by deleting all its children for that multi select Parent in case the user edits the multi select, ie delete the children, if any, and then re-create the children.
You would need to start off the automation by deleting all its children for that multi select Parent in case the user edits the multi select, ie delete the children, if any, and then re-create the children.
AviSikenpore1
7 years agoQrew Trainee
Mark's approach is definitely what I would recommend. Make sure your multi select choices are coming from a table and not a field dropdown so you can maintain them easily. Secondly The automation should get triggered whenever that field is changed in the modified record option which cycles through and creates a child record for each of the selected item. You can add a step to first delete all existing child records and then add the ones in the multi select checkbox to avoid any duplication. Feel free to reach out if you need help setting up the automation - they are fairly intuitive. Obviously you can use middleware like Workato or Zapier to accomplish it as well.
- VenkateshGandi4 years agoQrew TraineeHi @Avi Sikenpore, I'm struggling in looping though the each selection & make a child record. Can you elaborate more on how to achieve that.
------------------------------
Venkatesh Gandi
------------------------------