Base Design
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Add 'This Year' and 'This Month' to a view's filter

It would be awesome if Airtable added 'This Year' and 'This Month' to the filters. This way, I could create a view of records, like expenses or invoices, that apply to this month or year. I'm actually surprised this is not already a feature. It seems...

claimdepot by 5 - Automation Enthusiast
  • 2 replies
  • 1 kudos

Resolved! How to use Rollup on a lookup field

Hi (newbie here),Can you do a rollup on a Lookup field in a different grid?I have a table of employees.  There is a table of Trips where we look up the employees from the employee table.  Then I have a Departures Table that pulls in the Employee info...

ocmac by 5 - Automation Enthusiast
  • 2 replies
  • 1 kudos

Looking to create a viewable leaderboard that's linked to a form

I'm looking to create a leaderboard that's linked to a form customers can submit whenever they complete some action. Each logged action gets counted as 1 point, and moves the individual up or down the leaderboard. So I guess this has two components: ...

emma_c by 4 - Data Explorer
  • 1 replies
  • 0 kudos

Resolved! Bulk Editing Records

Hey Guys! Hoping everyone is well. I'm finding myself wanting to bulk-update records by a specific field and I'm wondering if this is possible? Does anyone know? Is there a script or anything? See the two fields? "Goes out to" and "Status"? Both are ...

Screenshot 2023-09-29 171423.png
folklore by 5 - Automation Enthusiast
  • 5 replies
  • 3 kudos

Using QR codes to streamline concert check-in process

Hello there! I work with an organization that produces a 50-concert summer festival. We have about 120 Season Pass Holders, about half of whom show up to any given concert. We would like to check them in at each concert and track their overall attend...

AndrewGreen by 5 - Automation Enthusiast
  • 9 replies
  • 5 kudos

Events CRM - track attendance

Hi Airtable Community!I've been tasked with creating a CRM for Events invites and attendance tracking and would love any input on best ways to proceed. So far I have a "Contacts" table and an "Events" table, which are linked based on who got an invit...

Kim_Zhou by 6 - Interface Innovator
  • 0 replies
  • 0 kudos

Displaying Diversity Data Using Pie Chart

I'm working on a project wherein I'm trying to display the diversity characteristics of several universities (50+). I have an existing base with a list of all the universities I'm studying with various facets as fields across (location, size, focus, ...

BlueOwl by 4 - Data Explorer
  • 2 replies
  • 0 kudos

Moving Projects Within A Section

Good Morning!I had a question about moving my projects within the table itself.  I have a main "Ready For Install" section and below are two other sections, one for each install team.  What I want to know and if I am able to, is how do I make it so w...

Sort groupings based on lookup field

I have a table called 'jira tickets' with a single select column called 'status' with options like new, in progress, done, closed etc.The options in the single select are ordered appropriately within the field definition and so if I group by the stat...

DanielP by 6 - Interface Innovator
  • 0 replies
  • 0 kudos

Risk Matrix

HelloI have a table that is effectively a Risk Register Which has been scored by probability (1-5) and Impact (1-5). What I want to be able to see how many risks score 5 and 5, how many score 4 and 3, show on a typical risk matrix/heatmap like the at...

andrewb9 by 4 - Data Explorer
  • 0 replies
  • 0 kudos

Help with URL filter parameter (contains)

Hello everyone,I'm trying to use the filterContains URL parameter in a shared view with linked records. The issue I'm encountering is that this parameter only displays records when they exactly match the value provided in the URL, but I'd like it to ...

MaorRubin by 4 - Data Explorer
  • 1 replies
  • 0 kudos

Resolved! grouping records by date when they have different times

As part of my workflow, I have a view in my base where I put in all my tasks for the day, which the populates my calendar. To make this work, I have "Date Start" and a "Date End" fields with the date and the start/end time of the record so that it'll...

Rae_Crothers by 6 - Interface Innovator
  • 4 replies
  • 3 kudos

Calendar List View?

Hello,I'm just curious to know if Airtable plans to create a list view for calendars.  We have Lists and we have Calendars but I'm looking for a schedule or list type view within the calendar.  Or maybe there is a way to create such a view? Thanks!

Organising data

Hi there,To use data for a list Softr you have to have the data in the same column. How would I be able to put two look up fields (one displaying a percentage and the other displaying a $ amount) into the same column while maintaining their exact val...

bartdubs by 4 - Data Explorer
  • 0 replies
  • 0 kudos

Jira integration and preserving parent/child tickets

Hi,I'm new to Airtable and using it to connect a number of various data sources, add additional data, and create custom views.  I know how to create linked/lookup fields for data I've created in Airtable, but I'm trying to figure out (essentially) ho...

joshanon by 4 - Data Explorer
  • 1 replies
  • 0 kudos

Calendar View

Hi! Is there any way to enter a start and end date with "no class dates" where it would remove the dates from the calendar view? I would also want the class to reoccur every Monday (sort of like google where you can say you want it to repeat every Mo...