The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
We're having an issue with analysing some data/ representing it in charts in Interface designer.We have survey data and one of the questions is a multi-select field. When you try to represent the answers as a pie chart/ percentage, you get strange an...
I have an automation that looks for new records and then copies relevant data to another tab. However! The new records are coming across from an API that often creates duplicates (I can't access/ change this part) and my automation is also creating d...
We take bookings online for a fortnightly gardening session, and the attendees' details are then added/ updated in an Airtable list.Before each fortnightly session, we currently manually send the list of who is signed up to the session leader which f...
I setup my first automation and it seems to have worked according to the ‘history’ but when I look in the table where it supposedly created a new record, the new records aren’t there. I don’t have any filters on, I searched and sorted in various way...
Thanks for this super useful thread/ formula! I have adapted it for UK financial quarters (Apr to Mar) - and thought I'd post below in case useful for others. I've started with year first so that it's easy to sort in the correct order. IF(AND(MONTH({...
Thanks for your help - here is a screenshot. The API runs daily at midnight, creating duplicate records in the same table. No links (as the API-linked sheet will overwrite daily so can't/ don't want to link to it). Does that help give more info? A de...
Oh brilliant! This is a great solution, I've made a yes/no column for today's date and updated my automation, I think it should work, thanks so much!
Thank you! I tried building it again, exactly the same way as far as i can see and it worked great! No idea why but anyway it’s working now which is great. thanks for your help