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!
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.