
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 16, 2021 05:48 AM
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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 18, 2021 07:36 AM
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,

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 18, 2021 09:21 AM
There are multiple different ways that you can integrate a REST API with your Airtable database:
- You can use the Data Fetcher app:
-
You can write your own custom JavaScript code, and run that code via Airtable’s Automations or Airtable’s Scripting App.
-
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.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 03, 2024 01:14 AM
I know I'm late, but for anyone else . .
- Quick and Dirty, you could just use the AirTable Calendar import extension.
- Dump in the ICS file from Hebcal [Download].
- Put that in a new ('HebCal'?) table with 2 fields, one for the 'summary' (Hebrew date) and one for the 'start date' (Gregorian).
- Format the english date as needed, in a 3rd field.
- 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.
