Skip to main content
Question

Bring Rich Text Field information from a Child table to the Parent

  • November 24, 2020
  • 0 replies
  • 64 views

Bring Rich Text Field information from a Child table to the Parent
Hello,
How do i bring a Rich Text Filed info from the child table to the parent.
i have three tables . lets call them 1-2-3
Table 3 is the child and i need to transfer the rich text from table 3 to the table 1
they are all connected .
Table 3 is the child to Table 2 and table 2 is the child to table 1
thank you.


------------------------------
Reza Khosrowabadi
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
  • Quickbase Alumni
  • November 24, 2020
I suggest to make a formula text field equal to the rich text field.
Then make a Combined Text Summary field to get that up to Table 2.

Then make a Combines d text summary field to get THST field up to table 1.

Then make a Rich text formula field to convert back to Rich Text and replace the semi colons with a line break character.

SearchAndReplace([Combined Text Summary field], " ; ", "<br>")

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------