Hello,
New to airTable and I love it. In setting up a database, I am running into a problem. Links from a long text string have to be replaced with new links. Is there a formula that an do this or does this have to be done manually?
Here’s the text: <h4>UNIT OVERVIEW</h4><p><a href="https://apostolicfaithchurch.box.com/s/q77dw02m7v5mu11fg301ixmtbni56ebb">Men Who Trusted God</a><br></p><h4>MEMORY VERSE IN ACTION</h4><p>WHOSO — Point to others.</p><p>PUTTETH HIS TRUST — At eye-level, hold fists on top of each other as though holding to an imaginary rope.</p><p>IN THE LORD — Make an L with thumb and first finger of the right hand. Touch thumb to left shoulder, bring across in front of body touching right waist.</p><p>SHALL BE SAFE — wipe sweat from forehead as though just having a close call with danger.<br></p><h4>MEMORY VERSE VISUALIZED</h4><p>Though our memory verse for this week is found in Proverbs, it ties in closely with our story text about Noah and the ark. The visualization for this verse is the ark. (See pattern at the end of this lesson.) Cut out each piece and assemble in the correct order as your students learn the verse.</p><h4>MEMORY VERSE SONG</h4><ul><li><a href="https://apostolicfaithchurch.box.com/s/9gynfedpkg86inoiztrd7qjzop981ef9">Trust In The Lord</a></li></ul><h4>COORDINATING SONGS</h4><ul><li><strong>"Brother Noah" </strong>— tune of "Old McDonald"</li></ul><h4>MEMORY VERSE PATTERN</h4><ul><li><a href="https://apostolicfaithchurch.box.com/s/vc5pj6c1jp77hcj9bbqkxj40thpvyko0">Proverbs 29:25</a><br></li></ul><h4>PATTERNS AND ACTIVITIES</h4><ul><li><a href="https://apostolicfaithchurch.box.com/s/5pemga35jz6sk7ls4g17kwqu9pprt9ci">Unit 24 Patterns</a></li></ul><h4>SUPPORT MATERIAL</h4>
And these are the new links:
ACTIVITY
OVERVIEW
MEMORY VERSE SONG
PATTERNS AND ACTIVITIES
MEMORY VERSE PATTERNS
Can this be done with a formula? Do the PDFs need to be brought into AirTable?
Thank you in advance.
