I decided to add a time stamp to the form so we could see when it was submitted, thinking I could add this as another field to update automatically in my Contact Info table and replace the timestamp from the last time they submitted. Step 4: After excitedly demonstrating my project to my dad, he pointed out that we need an easy way to tell who submitted the form and who ignored the email.
When a new record is created in the table “Form Submissions”.Step 3: To have the form submission update the existing record, I set up the following automation: I chose to have the form pre-filled for two reasons: 1) if an employee’s information has not changed, it will be easier to review their current information and submit vs having to re-type all of the same information and 2) I’ll be using their company email (the one data point that will not change and is unique to each employee) to link the new record to their existing record and I want to eliminate the possibility of typos interfering with this automation. Step 2: I created a form for the contact info in a separate table (I used the exact same column headings and titled this table “Form Submissions”) and used the app SendGrid to create an email template that would pull data from the base and send a unique email to all employees with a pre-filled form. This google sheet had a lot of information (about 50 different columns) so I created a view that would hide everything aside from the contact information that I am wanting to keep updated (name, personal email, company email, address, phone number) Step 1: I imported data straight from google sheets into Airtable to create my Employee Info base. Right now, this is being done by HR reaching out to employees individually to see if their info has changed and then manually updating in google sheets.Ĭurrent Project: Import current employee info into new Airtable base and set up a form to be emailed quarterly to all employees which will allow them to change any information and update their record automatically once this form has been submitted. One of these tasks is keeping employees’ contact info updated regularly. Some background on the project: My dad’s company is built almost entirely out of google drive and he is wanting to start transitioning over to Airtable to automate some processes that are currently being done tediously by his HR team. If that doesn’t work, try copying one of those mystery characters into a plain text editor that (I hope) will display it for what it really is, and share a screenshot of that here so we can dig more deeply.Hi! I am brand new to Airtable (and admittedly, brand new to the tech world in general), so I wanted to share my first project and get some feedback/suggestions. Replace :x: with your mystery character and see how things go. I tried this, using the formulaĭATETIME_FORMAT(DATETIME_PARSE(, "❌", ""), "MMM DD, YYYY"), "YYYY-MM-DD") If not, then I’m okay with creating another field (as pictured below) called “Checkin”.
My ideal date format would be YYYY-MM-DDĬan I format my “Check-in” field to be a formula that accepts the format coming in from Zapier as text? Or if I need to convert the text field to a date, that’s fine. The date in the email is formatted as text: Jan 09, 2020 but I would like it to be a date. I’m using Zapier’s email parser tool to grab data from incoming Airbnb “New Reservation” emails, and dump all of these new reservations into my Airtable. I’m using Zapier to populate Checkin and Checkout dates for our Airbnb, in Airtable. I also added this discussion and had no replies.
Continuing the discussion from Convert Text to Date: