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

Forum Posts

Rolling up a numerical lookup with MAX

Hi all! Here's what we're trying to do, and what we tried that isn't working:What we're trying to do: (example table: https://airtable.com/appKiBFGhHOgFeXf2/shrrTAISY39Rx8mL5)We run an exam, and have two tables:test_takers - each person who is taking...

Resolved! Range between two dates

Hi everyone,I have a start and end date field in one of my tables and I am trying to find a way to get airtable to tag each month within the range. Essentially I want to know how many were active between 8/30/2019 and 7/31/2020. I haven't been able t...

Volunteer database

Hi there!  We're setting up a volunteer shift database for a large festival. I assume we can let volunteers sign up for shifts using forms, but is there a way for them to change/drop shifts without having to email us to do it on the backend? If not, ...

faizapride by 4 - Data Explorer
  • 352 Views
  • 1 replies
  • 0 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
Solved
  • 529 Views
  • 2 replies
  • 1 kudos

Assign a value to first linked record only

When using linked records, is it possible to apply a value to only the first linked record in a cell?So if I have two tables.Table ATable BWith Table A, I'd like to find a way for the Revenue to only be a logged against the first linked record in the...

artichokejoe_0-1696237373572.png artichokejoe_1-1696237431877.png

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
Solved
  • 1935 Views
  • 5 replies
  • 3 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
  • 682 Views
  • 0 replies
  • 0 kudos

Showing a range of time

Hi all! I have a base in which we create and track educational programs that we put together. I have a date and time field that shows when the program starts, and a date field that shows when the program ends. Some of our programs are mutli session o...

Limi by 6 - Interface Innovator
  • 253 Views
  • 0 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...

Seperating data for different softr app users

Hi there,I was wondering how I might be able to separate the calculation field's data depending on the user's email. This is to be displayed in softr. I am unsure how to show only the user's data when this is a combination of lookup and calculation f...

bartdubs_0-1694777375984.png
bartdubs by 4 - Data Explorer
  • 329 Views
  • 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
  • 418 Views
  • 0 replies
  • 0 kudos

Display Assignee only under certain conditions

Hello everyone! I'm sure this solution is something really easy staring me right in the face but I just can't see it. I have a  base with several tables that I am linking to, and trying to set up. To start:The Position Table has a large number of job...

Shannon_Bradley_0-1694477193433.png Shannon_Bradley_1-1694477611807.png

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
  • 464 Views
  • 1 replies
  • 0 kudos

Extracting only first attachment

Hi all,How can I take the first attachment from a list of attachments and place it in another attachment field? Is there any solution that does not require scripting or integrating Zapier/Make? Cheers

Call Log with user data overwriting?

I am aware there is no way to "overwrite" data but I'm trying to figure out how else I might accomplish what I need.I have a very basic 2-table base.  Table 1 is "Call Log" and Table 2 is "Users".  I want to set up a default set of fields (location, ...

Adding an attachment

I am wondering if anyone is able to assist with a couple of questions. 1.  When adding an attachment into the 'attachment' field I am simply adding from files and attaching a word document.  I am then having issues once I send the email with the atta...

bcrawford_0-1693343558942.png bcrawford_1-1693343695526.png
bcrawford by 4 - Data Explorer
  • 1339 Views
  • 3 replies
  • 0 kudos