Help

Welcome to the Airtable Community!

53481members
126538posts
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Activity

Airtable as CRM for cleaning business

I'm putting together a website/CRM/internet stuff for a window cleaning business. I've looked at Jobber and it seems to offer everything we need but at $100+ per month it's pretty expensive. I tried kickserv which is about half the price for the feat...

  • 15 Views
  • 0 replies
  • 0 kudos

Save emails to Airtable with automations

In the past six months, I have been building TaskRobin to save emails to Airtable. After you setup your email inbox and Airtable base with TaskRobin, you just need to forward emails that you want to save to Airtable to TaskRobin.Try our Airtable exte...

Airtable_auto_fill_fields.png
  • 19 Views
  • 0 replies
  • 0 kudos

Link Across Two Tables

I have 3 tables:1. A Contacts table - lists each contact, their email, their phone number, and their Company. 2. A Company table - links to all the Contacts for that Company.3. A License table - lists all license numbers, their expiration dates and l...

  • 24 Views
  • 1 replies
  • 0 kudos

DATETIME_FORMAT returning wrong time - 24hours system

I am struggling to get the DATETIME_FORMAT to return the correct time for me. For example, my Start Date is 10 January 2023 00:00 and in my formula column, I just want it to extract the time of the "Start Date". So I put in this formula: DATETIME_FOR...

  • 14 Views
  • 1 replies
  • 0 kudos
MCC by 5 - Automation Enthusiast

Increase field number one when automated date field changes

My table is for students in a tutoring program.  One field is their current grade.  Another is the calculated formula of today's date.  Every August 15th (each year) I want each student's current grade to increase by 1.  Is there a way to do this? 

  • 24 Views
  • 1 replies
  • 0 kudos

Holidays - days remeaing counter

hello, I'm trying to make a table where employees upload two dates through a form, when they go on vacation and when they return.So far so good, I was able to make a formula that counts the weekdays and these are subtracted from the number of availab...

  • 36 Views
  • 1 replies
  • 0 kudos

Functions to pull in client email

I will preface with saying I have a hard time with functions. Not my brain thing. So, as much as I have searched for solutions I suspect my search terms weren't correct enough to find the answer. So I am hoping someone here can help.I need my email c...

  • 26 Views
  • 1 replies
  • 0 kudos

Resolved! How to use Utilitites in airtable script

 var authHeader = "Basic " + Utilities.base64Encode(wordpressUsername + ":" + wordpressPassword); I am getting error at "Utilities"  saying"Cannot find name 'Utilities'"  . I need to send post to wordpress using it's rest api and Utilities is require...

  • 39 Views
  • 3 replies
  • 0 kudos

Maximum Records

Hey AllI have a business producing about 10 000 records a month, that's going to double in a few months. Will it be feasible to create a new base each month and move the previous months data to a "backup" base?Thanks in advance!

  • 40 Views
  • 2 replies
  • 0 kudos

Choosing a Multiselect Option More Than Once?

Is there a way to choose a multi-select option more than once? For example, if I have a list of A, B, C, D for a job, and that job requires 3 A's and 2 C's, is there a way to choose those options in the multi-select more than once? Right now I can on...

  • 22 Views
  • 1 replies
  • 0 kudos

Automation to update status of a linked record?

This seems like it should be well documented but I'm having a devil of a time finding a clear example. Goal: When a new Activity is created with a Type of "Posting Closed", I want to update the linked Applications so that it's Status is "Recently Clo...

  • 55 Views
  • 3 replies
  • 0 kudos

Linking fields to a Master table using non-primary fields

Hi there,I have a series of quality assurance data for my Online School which has been populated using different google forms and is therefore stored in different google sheets. I am bringing the data into Airtable to use an interface to visualise it...

  • 32 Views
  • 2 replies
  • 0 kudos

Parsed HTML not rendering correctly in SendGrid extension

Hi there, My Goal (Image 1)I am trying to automate an email newsletter to send job postings stored in an Airtable base using the SendGrid extension. Context:In a Jobs table I auto generate the HTML for this list item in a field. (Image 2)In a Newslet...

  • 84 Views
  • 5 replies
  • 0 kudos

When do the "Automation Runs" for my workspaces renew?

It's a bit of a silly question, but I am a little alarmed that I have used up 39,000 automation runs out of the 50,000 available for my workspace ( I am on the pro plan ). Just wondering if it renews monthly, and how can I add more if I need to?My bu...

Screenshot 2023-05-29 at 4.57.12 PM.png
  • 40 Views
  • 1 replies
  • 0 kudos

We cannot figure out the lost payments

We cannot figure out the lost payments. All this time, access to Pro has been blocked. We have been unable to continue working for a week already.Please respond to our request:Your reference number is: 00564457

  • 33 Views
  • 0 replies
  • 0 kudos

How do I auto fill the form after selecting an option?

Apologies if the question sounds weird. Basically, what I am trying to create is a form that records user and their IT asset.What I would like to have is that when I select their ID (the AD Login option) on the form, if they have an existing asset, i...

Yvette_T_0-1685347123162.png
  • 48 Views
  • 2 replies
  • 0 kudos

Resolved! Export view as .txt based on a template

Hello,I'm trying to find a way to be able to export a view in a .txt file based on a template.Example view:Template would be like:Hello {Name} {Lastname}, you are a {Age} {Gender}So the .txt file would look like:Hello Martin Shelvi, you are a 22 Male...

CleanShot 2023-05-29 at 12.41.29@2x.png
  • 56 Views
  • 2 replies
  • 0 kudos

Announcements

New: Improvements to Timeline View

Hello everyone, I'm a product designer at Airtable. This quarter, our team is working on a number of improvements to Timeline view based on all the feedback we've heard (much of that from the communit...

Announcements

Community Change Maker: John Smith

This month we spoke with John Smith from Alamo Drafthouse Cinema. Alamo Drafthouse is a superior cinema and dining experience founded in Austin, Texas with ~40 locations throughout the U.S. John is cu...

Announcements

Airtable Top Contributors | April 2023

Welcome to April’s edition of our Top Contributors post! We’re excited to highlight the top contributors in the Airtable Community who have gone above and beyond to help others learn and grow their sk...

Announcements