Michael_Hjorten - profile

Michael_Hjorten · Jun 06, 2023

Question on the following formula. I have tried just about anything and everything to get this formula field to only calculate the score based on after the date. The formula works perfectly fine without using any date fields. Form type (single choi...

Michael_Hjorten · Jan 13, 2023

HelloLooking throughout this community for any additional insight on third party applications with AirTable. In particular exploring better Forms options and capabilities. Through looking at different program applications JotForm seems good, howeve...

Michael_Hjorten · Aug 23, 2022

Question if anyone received the following error with a form submission. This error has not occurred with this form for a few weeks until the last few days. The data is still processed though into AirTable however, because of this error the end user...

Michael_Hjorten · Aug 02, 2022

Within the last hour all of the automations just stopped processing through and now have a “In Progress” for the run history. I checked the automations as there was no field values changed and the trigger never changed. Additionally, I ran a few te...

Michael_Hjorten · Jun 08, 2022

Automation is setup too append a row to a Google Sheet. All of the values (text, dates) will populate within the sheet row, except for the numerical score values when the automation is running. However, if I run test automation with the same record,...

Michael_Hjorten · Jun 06, 2023

Hi @Stephen_Orr1 I used what you provided, modified it a little bit and it finally worked. Appreciate it, I simplified it as well. IF(AND({Form Type} = "QCLH",{Date of Session} > DATETIME_PARSE('5/20/2023')),IF({LH_GC_Def_1}=1,0,3)+IF({LH_GC_Def_2}=...

Michael_Hjorten · Jun 06, 2023

Hi @Stephen_Orr1 I gave that a try and still didn't work. Wasn't sure as that field within AirTable is a date column field type. I tried to add the formula below and it goes through but the scoring is almost like it is avoiding a portion of the fi...

Michael_Hjorten · Jan 13, 2023

Hi Hannah, Appreciate the input. I have setup a calendar meeting with Mia next week to do a quick walk through on some of the questions asked to just get an idea of its capabilities and different pricing options that maybe available. The live calcu...

Michael_Hjorten · Aug 17, 2022

@Kamille_Parks Thank you. This is good to know and didn’t realize this could be done. The users that need to see the information currently do not and wont ever have access to the actual Base. These users are employees but only need to see their perfo...

Michael_Hjorten · Aug 17, 2022

Emily_Sermons: I hear you, and thanks for the feedback! Our team has been working very hard over the last year on enabling Permissions in Interfaces, allowing you to share the Interface separately from the underlying base. This functionality is ...

User Statistics

User Activity

IF Formula assistance

Third Party Applications

Form Submission Error (Duplicate Entry)

Automations Broke

Appending Row in Google Sheet, any numeric value will not populate

Re: IF Formula assistance

Re: IF Formula assistance

Re: Third Party Applications

Re: Forms in Interface Designer

Re: Forms in Interface Designer