Create new records
I would like to use an automation to create multiple new child records when a parent record is updated. I understand how to set up the first part of the automation, but am having difficulty figuring o...
Forum Discussion
Hi Bre,
In Groups you are indicating which group a user belongs to, is Users another related table that you are bringing in or is each record on the groups table a user and a multi-select field of the groups they belong to or some other way of indicating which group they are in?
Is there a direct relationship between Groups and Documents or is that multi-select field just created by selecting Input type is "from another field" under the field settings? Because a multi select field can't be used as a reference field for a relationship and not having a relationship between those two tables can change the way you would try to solve this issue.
------------------------------
Evan Martinez
Community Marketing Manager
Quick Base
------------------------------
In Groups you are indicating which group a user belongs to, is Users another related table that you are bringing in or is each record on the groups table a user and a multi-select field of the groups they belong to or some other way of indicating which group they are in?
Is there a direct relationship between Groups and Documents or is that multi-select field just created by selecting Input type is "from another field" under the field settings? Because a multi select field can't be used as a reference field for a relationship and not having a relationship between those two tables can change the way you would try to solve this issue.
------------------------------
Evan Martinez
Community Marketing Manager
Quick Base
------------------------------
Hi Evan,
Thanks for the reply!
Users is not another table - The Groups table just contains a User field and a multi-select field for the group.
There is a direct relationship between Groups (parent) and Documents (child). Should I instead create a multi-select field in Documents where the input comes from Groups?
------------------------------
Bre Butler
------------------------------
Thanks for the reply!
Users is not another table - The Groups table just contains a User field and a multi-select field for the group.
There is a direct relationship between Groups (parent) and Documents (child). Should I instead create a multi-select field in Documents where the input comes from Groups?
------------------------------
Bre Butler
------------------------------