Help

Auto Tabulate Between Tables

Topic Labels: Formulas
1244 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Weng-IC
5 - Automation Enthusiast
5 - Automation Enthusiast

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

2 Replies 2

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>'

Thank you, let me try it out.