Skip to main content
Solved

Create child records from Parent List - User field


Forum|alt.badge.img+2

I have a List - User field called "Leads" in Property table and want to build an automation to create individual record in another table called "Team Role", so that users added to Leads field can be displayed in a table row. 

The search pipeline step allows creation of  record for the first user added to the list, but skips the other values from the List - User. If there is any alternate approach for this, please let me know.

 

Best answer by MarkShnierYou

I think that you should be able to leverage KristoferKeen's response at the end of this thread.  You may need to use a formula on the native Quickbase side to convert that List User field to text.

ToText([my list user field])

https://community.quickbase.com/discussions/quickbase-discussions/looping-through-field-values-in-pipeline/50677

View original

MarkShnierYou
Forum|alt.badge.img+24

I think that you should be able to leverage KristoferKeen's response at the end of this thread.  You may need to use a formula on the native Quickbase side to convert that List User field to text.

ToText([my list user field])

https://community.quickbase.com/discussions/quickbase-discussions/looping-through-field-values-in-pipeline/50677


Forum|alt.badge.img+2

Thank you Mark. I will try that.


Forum|alt.badge.img+2

It worked. Thank you Mark.