Hm yeah, you could try putting the full text of the email into a long text field, then using formula fields to extract the order details either with the REGEX formulas or lots of SUBSTITUTES.  This works but would be pretty clunky, you’d need to have one field per order in the second email, which is fine if there are like 5 maximum or something, but if it goes to dozens this is pretty tedious

You’d also then need to create an automation that would run per field here too

---

If you’re comfortable with scripting (or using ChatGPT) then that works too, you’d get the script to extract the data and output it into an array, then use a Repeating Group on the array to find and update one record per Order Number

I’d recommend doing the script option if possible; it’s cleaner and easier to maintain overall I think

Can you provide an example of the second email’s text?

Hey ​@LDKottal,

Regex/script would probably be more error prone.  However, a diferent approach would be to have an AI action on your automation (see more here, on Airtable’s official support article).

You could feed the body of the email to the AI action, and ask it to output a list of order numbers.
Then you could use a repeating group to go through each order number on such list.
Then you could have a Find Records action within the repeating group, to find the corresponding record based on the order number.
For last you could have an Update record action after the Find Records, and within the repeating group, to update the corresponding record.

If you need any help setting this up, please feel free to grab a slot using this link. I’d be happy to show you around!

Mike, Consultant @ Automatic Nation 
YouTube Channel

ChatGPT suggested using this script. “bestillingsnummer” is order number. Might that work?

let inputConfig = input.config();

let recordId = inputConfig.recordId; // ID of the Incoming Emails record

let emailBody = inputConfig.emailBody;

// Split email body into blocks (separated by blank lines)

let blocks = emailBody.split(/\n\s*\n/);

// Reference to your Orders table

let ordersTable = base.getTable("Orders");

// Get only records with Status = "Ordered"

let query = await ordersTable.selectRecordsAsync({

    fields: ["Bestillingsnummer", "Status"]

});

let orderedRecords = query.records.filter(r => r.getCellValue("Status") === "Ordered");

// Go through each block

for (let block of blocks) {

    let lines = block.split("\n");

    let data = {};

    for (let line of lines) {

        if (!line.trim()) continue;

        let [label, ...rest] = line.split(":");

        if (!label || !rest.length) continue;

        let value = rest.join(":").trim();

        let cleanLabel = label.trim();

        data[cleanLabel] = value;

    }

    if (data["Bestillingsnummer"]) {

        // Find matching order among "Ordered" records only

        let matching = orderedRecords.find(

            r => r.getCellValue("Bestillingsnummer") == data["Bestillingsnummer"]

        );

        if (matching) {

            let updates = {

                "Status": "Ready"

            };

            if (data["Ønsket benyttelsesdato"]) {

                updates["Ønsket benyttelsesdato"] = data["Ønsket benyttelsesdato"];

            }

            await ordersTable.updateRecordAsync(matching.id, updates);

            console.log(`Updated order ${data["Bestillingsnummer"]}`);

        } else {

            console.log(`No matching "Ordered" record for Bestillingsnummer ${data["Bestillingsnummer"]}`);

        }

    }

}

Hard to say without an example of your full email text I’m afraid.  When you tried it out did it work right?

Hi,
Parsing require precision in details, so you can test and see if script works.
I just made a small test with a different approach - I did Find records for Ordered status and then used results to avoid querying in script.
You can use it in case of any problems with ChatGPT version

From Find Records, order numbers added as ‘numbers’  and record IDs added as ‘ids’  at the left side of editor. Email text added as ‘mail’
 

I just typed random nonsense for test

 

Looks good

 

Of course if your email text has differences it might not work for you. Or you should make minor fix in the script. 
 

const {numbers,ids,mail}=input.config()
const table=base.getTable('Orders')
const [DIV,VAL]=['Bestillingsnummer','Ønsket benyttelsesdato']

const idByNum=new Map(ids.map(i=>[numbers.shift(),i]))
const parts=mail.split(/\n\s*\n/).filter(p=>p.includes(DIV))
const update=([id,value])=>({id,fields:{[VAL]:value}})
const getId=x=>idByNum.get(x.split(':').pop().trim())
const parse=(t,[bsnum,val]=t.split('\n',2))=>update([getId(bsnum),val])
const upd=parts.map(x=>parse(x))
console.log({parts,upd})
if(upd.some(rec=>!rec.id)) throw new Error('Order not found, pls review')
await table.updateRecordsAsync(upd)

Ouch, i forget about updating Status field
it just require updating one line in script above. I suppose your Status is Single-select field, and if yes, GPT script won’t work

const update=([id,value])=>({id,fields:{[VAL]:value, Status:{name:'Ready'}}})

but if I’m wrong and it just single-line text, it must be:
 

const update=([id,value])=>({id,fields:{[VAL]:value, Status:'Ready'}})

Thanks for all the advice.

I have decided not to do this anyways. What is the best thing to do with the thread? Should I delete it or somehow close it?

Just mark any answer as ‘best’ so this topic will disappear from ‘Unanswered’, but will be available for searching for somebody with the same question.
My script created for exact sequence of dividers (empty lines, colon), so it must be edited to work for different mails. Thus, maybe ​@Mike_AutomaticN reply is more useful here. And if somebody want to create own script, they can scroll and use any of quoted here as template.

Thanks for the shoutout ​@Alexey_Gusev :D

Mike, Consultant @ Automatic Nation 
YouTube Channel