Forum Discussion

JohnReinagel's avatar
JohnReinagel
Qrew Trainee
6 years ago

Create new records using data from a multi-select field

When I save a record in a table, I would like to take items selected in a multi-select field in that table and create a record for each item selected into another table.  I tried an automation but it ...
Quickbase Automations
Tables and fields
LauraThacker's avatar
LauraThacker
Qrew Captain
6 years ago
You can also use the formula that Mark has provided; and use it to create a formula that can be read by Quick Base as a csv import and leverage the Webhook automation feature to create child-table records with the values from your multi-select text field.  This is much cleaner than having 10 separate fields that run on separate automations.
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    6 years ago
    True, but this would be just 1 Automation with 11 steps, so not separate Automations.  Also there is a COPY feature to COPY a step :).  Also I'm not smart enough to remember the syntax for a Webhook - I have to go back to my cheat notes each time.  But you are correct, that your way can work too.
  • JohnReinagel's avatar
    JohnReinagel
    Qrew Trainee
    6 years ago
    I can see how the webhook would be clean, but have never used them.  Any good places to see examples of webhooks.  I can usually figure things out if I have a good example to work off of.
  • LauraThacker's avatar
    LauraThacker
    Qrew Captain
    6 years ago
    If you call me tomorrow I can walk you through a webhook setup and the import from csv formula setup I am referring to.
  • JohnReinagel's avatar
    JohnReinagel
    Qrew Trainee
    6 years ago
    Thanks!  What's the best number to reach you at?
  • LauraThacker's avatar
    LauraThacker
    Qrew Captain
    6 years ago
    Intelligentdbs.com has my contact info on it at the bottom of the page.