Help

Recognize or extract cell info

Topic Labels: Formulas
4211 10
cancel
Showing results for 
Search instead for 
Did you mean: 
Sebastian_Orell
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello everyone, first time in this forum but I’ve been using Airtable for a while.

I have an ecommerce and when there is a new order I get this information in my “Purchased items” (cant change this).

count: 1
productName: 102
productSlug: rollin-102-bleu
rowTotal: {u’unit’: u’EUR’, u’value’: 120, u’string’: u’1\xa0\u20ac’}
variantImage:
variantName: 102 Gravure personnalisée (+20€): Avec gravure or véritable
variantPrice: {u’unit’: u’EUR’, u’value’: 120, u’string’: u’1\xa0\u20ac’}
variantSlug: rollin-102-bleu-gravure-personnalisee-20eu-avec-gravure-or-veritable

count: 1
productName: 102
productSlug: rollin-102-bleu
rowTotal: {u’unit’: u’EUR’, u’value’: 120, u’string’: u’1\xa0\u20ac’}
variantImage:
variantName: 102 Gravure personnalisée (+20€): Sans gravure
variantPrice: {u’unit’: u’EUR’, u’value’: 120, u’string’: u’1\xa0\u20ac’}
variantSlug: rollin-102-bleu-gravure-personnalisee-20eu-sans-gravure

I would like to extract some info for ecah product, for example the count, productSlug, productName, and put it in other cells.

Is this possible?

Thank you very much!

10 Replies 10

Thank ok very much for all your answers @Bill.French!