Skip to main content
Solved

Create child records from Parent List - User field

  • April 15, 2025
  • 0 replies
  • 223 views

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

MarkShnierYou
Forum|alt.badge.img+22
  • Quickbase Alumni
  • Answer
  • April 15, 2025

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
  • Author
  • Quickbase Alumni
  • April 17, 2025

Thank you Mark. I will try that.


Forum|alt.badge.img+2
  • Author
  • Quickbase Alumni
  • April 22, 2025

It worked. Thank you Mark.