First time posting here as a new user of Airtable and I’d really appreciate some help -
Context: I have two tables - Submission and Final. Submission data is fed from a form which is completed by customer for each book. A customer will usually enter multiple books which then roll up into one submission that populates the Final table (i.e. one submission = one invoice). It was working great when I roll up using a unique ID (Invoice ID) made up of the customer’s initials + date. However, occasionally a customer will want to put in 1+ submission on the same day. So I end up with duplicate invoice IDs that then all roll up into one invoice - which I do not want. I want to separate these same-day submissions and send separate invoices (emails) for each.
Right now I’m trying to append to the invoice ID like how I would do it manually, e.g. GS-091522A, GS-091522B, etc. But I’m unable to figure this out as an automation. This is what I have:
This appends A to the first of the multi submissions. Then I try to add a conditional action for the subsequent submissions, like this:
But then the first step runs again on the second submission which ends up being appended A as well:
I don’t know if there is a way to build the conditional action somewhere between trigger and first step? Or maybe there are other ways to achieve this?