Jessica_Crocker - profile

Jessica_Crocker · Aug 22, 2023

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...

Jessica_Crocker · May 11, 2023

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...

Jessica_Crocker · Apr 12, 2023

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...

Jessica_Crocker · Mar 07, 2022

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...

Jessica_Crocker · Jun 07, 2023

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({...

Jessica_Crocker · May 15, 2023

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...

Jessica_Crocker · Apr 13, 2023

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! 

Jessica_Crocker · Mar 08, 2022

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

Jessica_Crocker · Mar 08, 2022

If I copy that link and paste into my browser, it just goes back to the main automations tab/ main sheet view. No record pops up. So odd!

User Statistics

User Activity

Interface Chart for Multi Select Field - % not calculating as expected

Automation creating duplicate records

Automation to send an email with names of who signed-up to an event with today's date

Automation - history says it ran fine but new record not appearing

Re: Displaying Fiscal Years and Quarters

Re: Automation creating duplicate records

Re: Automation to send an email with names of who signed-up to an event with today's date

Re: Automation - history says it ran fine but new record not appearing

Re: Automation - history says it ran fine but new record not appearing