Creating checkbox in rich text field via scripting

[Admin_OHP]

I have a column in a table formated as rich text. I want to auto populate other cells in the same column with the same rich text in the first cell when a status in another column changes from “empty” to “is not empty”. I update a record once a response is received and need to auto populate a check-box set of data in another cell once the status is updated.

Other option maybe? Batch update rich text? Anyone know how to do this?

Thank you!

[kuovonne]

Welcome to the Airtable community!

Because you want to use the value from one row/record in another row/record, you cannot use a formula field.

Here are some possibilities:

• if the value in the rich text field will never change, you can use a no-code automation to update the field. Place the value that you want to use directly in the automation.

• if the value in the rich text field of the “first row” changes, and you always want the most recent value, you can use a scripting automation. The scripting automation would look up the current value and then update the trigger record.

• If you do not want to use an automation, you could also use a button field that triggers a script.