Forum Discussion

Qrew Cadet

5 years ago

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

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 ...

Formulas and functions

Quickbase Automations

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
------------------------------
- RezaKhosrowabad
  Qrew Cadet
  5 years ago
  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
  ------------------------------
  - MarkShnier__You
    Qrew Legend
    5 years ago
    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 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

Parent to Child Reference Field

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

Create child records from Parent List - User field