seanwhitcomb - profile

seanwhitcomb · Nov 06, 2023

I have an annual Airtable payment due on December 7, 2023. I have to get prior approval for all software purchases, and I need to submit an official invoice for the approval. I can only see my past invoices (Nov. 2023 and before). Is there a way to s...

seanwhitcomb · Oct 25, 2023

I have to get approval for all software on an annual basis. The software request form now requires the name and phone number of a support person from Airtable before I can renew for next year. There are no exceptions to this rule. Does anyone have a ...

seanwhitcomb · Aug 24, 2023

I have a base to manage volunteers and volunteer events. There's a Volunteers table to store volunteer information (name, email, phone, etc.). There's an Events table with details about volunteer events. There's a table called Volunteer Signups that ...

seanwhitcomb · Jul 20, 2023

I have a formula field that returns the URLs of an attachment field. If there's only one attachment, it returns one URL in parentheses. But multiple attachments take this form: "File Name 1 (URL 1), File Name 2 (URL 2)".Here is an example: "Screensho...

seanwhitcomb · Jul 19, 2023

I will be using Make to update a table with information gathered in the field. This includes new photos of assets. There should be only one photo in the attachment field, with all old photos stored in a separate field. I don't want to just replace th...

seanwhitcomb · Aug 25, 2023

This is pretty close to how I have things set up, but here's the problem I have:Jack Smith signed up for the April 2023 volunteer event. There is one record in the Volunteer Signups table for "Jack Smith - April 2023". Jack Smith then signs up for th...

seanwhitcomb · Jul 23, 2023

That worked. Thanks!

seanwhitcomb · Jul 20, 2023

That does seem like a good solution, but it would require scripting, correct? Do you know what that script would look like?

seanwhitcomb · Jan 30, 2023

Thank you! That helped a lot. I also wanted to make sure the field stays blank if there are no DBH values entered. This field is in inches, so I also had to convert the final value. Here's the formula I went with: IF({DBH 1 (cm)} = BLANK(), BLANK(), ...

seanwhitcomb · Dec 05, 2022

Thanks for your response. In my case the "Name" field (actually called "Taxon Name") is a formula field made up of several concatenated fields. That field should only contain accepted names, not synonyms. I don't want a "New Accepted Name" field beca...

User Statistics

User Activity

Can I view my future Airtable invoices?

Contact information for Airtable support

How to show only the most recent registered event in a volunteer management table

Extract most recent attachment URL from list of attachments

Automate replacing attachment and moving old attachment to a different field

Re: How to show only the most recent registered event in a volunteer management table

Re: Automate replacing attachment and moving old attachment to a different field

Re: Automate replacing attachment and moving old attachment to a different field

Re: Calculate square root of the sum of several numbers, excluding missing data

Re: How do I handle synonyms in my plant names base?