Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jun 27, 2022 01:34 AM
Is there a way for me to auto tabulate from “Inventory” description to the respective field under “description” column for all the rows?
Title: enter title
Year: enter year
Type: enter type
Dimension: enter dimension
Jun 27, 2022 02:18 PM
The base you shared has two tables with no overlapping or linked data. I’m therefore assuming you are only intending to include data from the first table.
You’re going to need to turn your Description field into a formula field. To have a formula insert the value of another field, you reference that field’s name enclosed in curly braces. So {Weight}
would insert the value of the field named “Weight”.
The formula could look something like the example below, which assumes you have fields for each of the data points you’re tying to insert:
'<p>
<strong>Brand:</strong>' & {Brand Name} &
'<br data-mce-fragment="1"><strong>Title:</strong>' & {Title} &
'<br data-mce-fragment="1"><strong>Year:</strong>' & {Year} &
'<br data-mce-fragment="1"><strong>Type:</strong>' & {Product Type [Non Editable]} &
'<br data-mce-fragment="1"><strong>Dimension:</strong>' & {Length} & 'x' {Width} & 'x' & {Height} &
</p>'
Jun 27, 2022 06:36 PM
Thank you, let me try it out.