Hello, I do have a table with 10k rows in it. The table contains WooCommerce orders (including the address from both the buyer and recipient). Each address has about 5 different columns (i.e. address, second address line, postcode, ZIP etc.).So what ...
Hello, I am having a table in Airtable with Subscriptions. Each subscription record has its subscriber data containing the following fields:First NameLast NameAddressZip CodeCityBut each subscription can be assigned to a person more than once. So per...
Hello, I am looking for a way to do something like this: I do have two values. I want to sum up these tweo numbers and create 3 more results. I.e. the value of field "first field" is 70, the value of field "second field" is 10.The result should be th...
Hello, I am looking for a way to combine five fields (address, second address line, zip code and city) to a new multiline text field when another field "second zip code" has a value. So here is an example of the five fields: Address: 220 Miller Avenu...
Hello, I am looking for a way to calculate a date minus x days based on a date field. I.e. the result should be 31.12.2023 (DD.MM.YYYY) minus 10 days = 21.12.2023. How can I do this? I tried to use this formula, but it returned an error: DATETIME_FO...
Thanks a lot @Alexey_Gusev , @Sho and @TheTimeSavingCo . I used the "Expand table" feature and it worked very well. Didn't expect that it was that easy. Many thanks for your support!!!
Hi @Stephen_Orr1 , thanks again. The problem is, that not every record has an email address. But I will look into your last idea with the automation. Thanks, M.
Thanks @JonathanB for your update.I guess I will have to look for another solution (i.e. adding pre-defined autonumbers from Excel and look with the Dedupe extension https://support.airtable.com/docs/dedupe-extension and give them another ID manually...
Hi @JonathanB thanks for your details. The problem is that both data (Subscriber and Subscriptions) are in the same table. So I can't use the Rollup field.And I do have 10k subscriptions! So it would be a bit complicated to split the data. Is there n...
