Skip to main content

Auto Tabulate Between Tables

  • June 27, 2022
  • 2 replies
  • 35 views
W

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

Kamille_Parks11
Forum|alt.badge.img+27

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>'
W
Hannah_Wiginton
W
  • Weng-IC
  • Author
  • Participating Frequently
  • June 28, 2022

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.

Terms & ConditionsAccessibility statement