Skip to main content
Solved

Multiple text and value rows in same entry

  • March 16, 2023
  • 2 replies
  • 39 views

Forum|alt.badge.img+3

Hello everyone,

I'm trying to create something similar to what I do with spreadsheets, it's like a product catalog but using multiple rows on a single entry so I can use different values for each variation of the  same item. (image attached)

Is it possible to do something like this in AirTable?

Or if anyone got any suggestions on how I could do something similar to this in AirTable, I would appreciate it very much.

Thanks everyone!

 

Best answer by TheTimeSavingCo

Kind of?  You could try to do it with a long text field, as seen by the "Notes" field in the screenshot below

I don't recommend that though, and highly recommend having another table that will just contan the variations and price:

Link to base

2 replies

TheTimeSavingCo
Forum|alt.badge.img+31
  • Brainy
  • 6460 replies
  • Answer
  • March 17, 2023

Kind of?  You could try to do it with a long text field, as seen by the "Notes" field in the screenshot below

I don't recommend that though, and highly recommend having another table that will just contan the variations and price:

Link to base


Forum|alt.badge.img+3
  • Author
  • New Participant
  • 1 reply
  • March 17, 2023

Kind of?  You could try to do it with a long text field, as seen by the "Notes" field in the screenshot below

I don't recommend that though, and highly recommend having another table that will just contan the variations and price:

Link to base


Thanks for the help Adam, I was going crazy trying to figure out a way to do this haha.

The thought of linking two different tables together didn't even cross my mind, I think I could use this to do the calculations on prices*quantity ordered as well.
I just have to check if the time spent doing it this way would be faster than doing it in a normal spreadsheet.

Thanks again for the help!