Skip to main content


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

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 rNon Editable]} &
'<br data-mce-fragment="1"><strong>Dimension:</strong>' & {Length} & 'x' {Width} & 'x' & {Height} &
</p>'

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 rNon Editable]} &
'<br data-mce-fragment="1"><strong>Dimension:</strong>' & {Length} & 'x' {Width} & 'x' & {Height} &
</p>'

Thank you, let me try it out.


Reply