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-3Table 3 is the child and i need to transfer the rich text from table 3 to the table 1they are all connected .Table 3 is the child to Table 2 and table 2 is the child to table 1thank you. ------------------------------Reza Khosrowabadi------------------------------

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 ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Hello Mark,Can i use automation to trigger info onto the table 1 when i leave comments in the rich text filed in table 3?------------------------------Reza Khosrowabadi------------------------------

Well, you can try, but if here are multiple child records with comments, then how would that get written to the parent record. Maybe you should need to give me an example with multiple comments on table 3 and what you would wan to see in table 1. Then also what if he comments get edited or deleted in table 3. It gets very messy to try to deal with that so I would not go that way------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

My table 3 is actually my Action table on which each action is listed. Any comment i make on the action table whether original or in edited, i would want it to copy the same on the table 1.i review a file on table 1, my questions for my review come from the table 2, and table 3 is my action table.when i click on any question on table 1 that is not in compliance, it will automatically take me to the action table to leave my comments.so now, i need the comments on my review table as well. i do not know how to get them to the review table.thank you.------------------------------Reza Khosrowabadi------------------------------

Would it be good enough to just show those comments when viewing a table 1 record. That's easy.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

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

MarkShnier__You
Qrew Legend
5 years ago
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
------------------------------
- RezaKhosrowabad
  Qrew Cadet
  5 years ago
  Hello Mark,
  Can i use automation to trigger info onto the table 1 when i leave comments in the rich text filed in table 3?
  
  ------------------------------
  Reza Khosrowabadi
  ------------------------------
  - MarkShnier__You
    Qrew Legend
    5 years ago
    Well, you can try, but if here are multiple child records with comments, then how would that get written to the parent record. Maybe you should need to give me an example with multiple comments on table 3 and what you would wan to see in table 1. Then also what if he comments get edited or deleted in table 3. It gets very messy to try to deal with that so I would not go that way
    
    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------

Forum Discussion

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

Related Content

Create A New Record In the Parent Table from the Child Record's Information

Add child record through parent form and redirect back to parent form in edit mode

Totaling Child Records Live on Parent Form

Many parent records on a single child record

Pipeline to add Parent record from child import