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

[Jonathan_Levy]

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

[Jonathan_Levy]

Hi everyone,

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

https://www.hebcal.com/home/219/hebrew-date-converter-rest-api

Any ideas how I would implement this in my Airtable?

Many thanks in advance,

[ScottWorld]

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

1. You can use the Data Fetcher app:

Airtable

Data Fetcher - Apps - Airtable Marketplace

Run, save and schedule API requests on Airtable with the Data Fetcher app.

2. You can write your own custom JavaScript code, and run that code via Airtable’s Automations or Airtable’s Scripting App.

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

Integromat

HTTP Integrations

Tweet new Facebook posts automatically. Save new Facebook photos to OneDrive. Share your Instagram photos to Facebook Groups, and more. There''s no limit to what you can do using HTTP and Integromat!

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

[OfficeOurs]

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.