Help

Welcome to the Airtable Community!

65509members
151032posts
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Activity

Formula If or Switch Help

Hey I am trying to set up a formula for the below problem. I am provided with a list of names in the 'home' column and certain entries I need to change to end up like the 'bot name'. I have tried switch/If functions and I just get errors.  

Sarah1_0-1718754695037.png
  • 10 Views
  • 0 replies
  • 0 kudos

Timezone problem

Time zones are difficult to handle within AirTable. Here is an example that gives me a headache. I have a table (let's call this table Calendar) in which there is, among other things, a Date Field associated with an event occurring at a Location. Str...

  • 15 Views
  • 0 replies
  • 0 kudos

How to sum values and sort by another field?

Hi all,I have a base table with the transaction history which lists each profile's contribution amount, date, and the fund invested. Each profile is allowed to invest in many funds and can also invest in the same fund multiple times. How do I create ...

Picture1.png Picture2.png
  • 37 Views
  • 0 replies
  • 0 kudos

Show remaining values from linked table

I have a table listing persons linked to another table showing tasks. I'm trying to show the remaining tasks a person needs to do.Example: These two tables are linkedTable 1: a list of 100 peopleTable 2: a list of 34 tasks to be done by each personEa...

  • 24 Views
  • 1 replies
  • 0 kudos
G_T by 5 - Automation Enthusiast

API Call for List Records with Cell Format V2?

Hi, I'm working with the Airtable API, and am noticing that the "list records" API endpoint is returning linked records in "cell format V1", while the Webhooks API returns values in "cell format V2". Cell format V1 is an array of strings representing...

  • 25 Views
  • 0 replies
  • 0 kudos

Resolved! using f-string with filterByFormula

Hi,i am using python-requests and trying to use f-string with filterByFormula here is a simple implementation:hard coding the name worked:   url=f"https://api.airtable.com/v0/{base_id}/{table_name}/" headers={'Authorization': f'Bearer {api_key}', ...

  • 37 Views
  • 1 replies
  • 0 kudos

Attendees to be able to Update their Own Record

Hello everyone,I am using AT for events.When I sell a ticket to my event it creates a record of the attendee.Afterwards I would like attendees to be able to fill a form with further details about their profile (eg. dietary restrictions) and whatever ...

  • 45 Views
  • 2 replies
  • 0 kudos

Announcements

Airtable Top Contributors | April & May 2024

Happy Thursday, Airtable Community!  Welcome back to our Top Contributors post, covering both April and May.  We are thrilled to celebrate our incredible Airtable Community members who have gone abo...

Announcements

Introducing single-select output for formula fields

Hello, I’m Rosalind and I’m a Product Marketing Manager at Airtable. I’m excited to share a small but often-requested new feature with you today: the ability to output the result of formula fields as ...

Announcements

Expanded Support for Dynamic Filters

Hi there! I’m Rosalind – a product marketing manager at Airtable focused on helping teams build powerful, custom applications that make work more efficient. Today I’m happy to share more details on th...

Announcements

New Project Management Features Added

Hi there! I’m Rosalind – a product marketing manager at Airtable focused on helping teams build powerful, custom applications that make work more efficient. Building on our project management-focused ...

Announcements