I've spent some time building some Interfaces and found that the best way to group things the way I want is to have a new table that holds groups as Linked Records. Here's the set-up:Table 1: Events{Day}{Month}{Year}{Roster}Table 2: Roster{Day}{Month...
Hello hello!Just a quick question for any tips if anyone has experience integrating Airtable with Squarespace. We're a music education programme. In recent years, we've cleaned up our data and workflows with Airtable. Now, we're upgrading our website...
When creating a form, we can limit the options the submitters can select. Is there a way to do a similar set up at the user level?I was thinking maybe, at the interface level, we'd be able to limit the selection of a single select field. But that doe...
Probably no way of doing this without an Automation right?I'd just like to have an image for my records based on a single select field. Essentially a Single Select field for images! I want to be able to assign a Logo for each record. Then on an inter...
Hi Airtable team!Not sure if this is the right place for reporting bugs.I'm also aware that the features being released are all still a work in progress.I have a Kanban interface that is sorted by a date field. It works great on desktop, but not on m...
@ScottWorld Yeah I thought of this first. I haven't ventured into using Make at all. I wasn't sure if Make would integrate the Marketing aspect of Squarespace. Do you have any experience with this or similar tools like Mailchimp?If it can intergrate,...
I'd use the Link field type which looks like you have already. Called "Assigned". To dynamically add them in, insert their <ID> rather than their <name>.
You could find a way to incorporate the "Repeating" logic in your automation. This way, within one automation run, it'll run in sequence without the same automation clashing with itself.I'd then make the first automation end with the trigger for the ...
I agree with @TheTimeSavingCo 's solution. This will also allow you to add more filters to define what is "missed". I assume it is not just that the date has passed, but also that some other field hasn't been updated.
Depends on what your formula for your percentage is. It'll run into issues calculating dividing by zero.A workaround would be to choose one of the options to display as 1 anytime a 0 is shown. The formula will differ depending on how your original pe...
