Re: How to create a link between Gregorian calendar and the Hebrew calendar in Airtable

249 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hi all,

I am new to Airtable and new to the field also.

I am based in Israel and I am trying to build some tables where the Gregorian Calendar (which is the default) is linked to the Hebrew calendar.

For instance, I am creating a form where the user will either input an English date of birth or a Hebrew date of birth. In both instances I will need the table to calculate either the original Hebrew date, or the original English date. When it comes to due dates also, I would like to be able to query in either the Hebrew or English dates ie. all the birthdays in September or all the birthdays in אלול.

There are many sources of Hebrew dates out there, one I found on Hebcal website.

Can anyone help me achieve this? Many thanks in advance

3 Replies 3
4 - Data Explorer
4 - Data Explorer

Hi everyone,

I found this API that can convert between Hebrew and Gregorian.

Any ideas how I would implement this in my Airtable?

Many thanks in advance,

There are multiple different ways that you can integrate a REST API with your Airtable database:

  1. You can use the Data Fetcher app:
  1. You can write your own custom JavaScript code, and run that code via Airtable’s Automations or Airtable’s Scripting App.

  2. You can use an external API automation tool like Integromat. You would use their HTTP tool to make your API request:

There are many other ways too, but those are the top 3 which popped into my head.

6 - Interface Innovator
6 - Interface Innovator

I know I'm late, but for anyone else . . 

  1. Quick and Dirty, you could just use the AirTable Calendar import extension.
  2. Dump in the ICS file from Hebcal [Download].
  3. Put that in a new ('HebCal'?) table with 2 fields, one for the 'summary' (Hebrew date) and one for the 'start date' (Gregorian).
  4. Format the english date as needed, in a 3rd field.
  5. Create an automation. Trigger: On input of date in user table. Find records: Match the date entered. Update record: In the user table in the correct field.