Javascript to find and replace and then update fields

Thanks. Have you tried a Quick Base Automation to do this natively?

I can't see how an automation would work to find placeholders in the rich text field and replace them.

I use automations and webhooks for much of  my workflow including copying the templates among other things.

I'm just needing help with what I stated above... reading data from html elements that don't have a corresponding #_fid_.

Hi Wendy. I don't know the details of the use-case, but Automations definitely can find and edit records. We also released _SearchAndReplace()_ as a formula function. Wherever possible, we would encourage using supported methodologies vs. image onload.

I think you might have helped me down a better path!
I'd rather not use .js [iol] anyways. 

• Create formula rtf fields for each of the rtf fields
• Use _SearchAndReplace() for the placeholders
• When user clicks button, run automation that saves the formula field values into the regular fields

Question: do the formula rtf fields have to be displayed in order for them to work properly?

So the serchAndReplace works but for only one variable 

For example my text says:

[Date]

 

To: [PC]
[Delivery Method]

Case: [Case ID]

Client: [Client]

There are three separate rtf and approximately 25 different variables (may be more as we progress and need this to be an option to be able to implement on the fly as new templates are created).

So I need to be able to iterate over the text such as 

Text = [rff field]
Text = SearchAndReplace( Text, "[PC]", [Case - PC Full Name])
Text = SearchAndReplace( Text, "[Delivery Method]", [Delivery Method])
Text = SearchAndReplace( Text, "[Case ID]", [Case - Case ID])
...