Ben_Simai - profile

Ben_Simai · May 25, 2022

Hi Airtable community, We have a business that runs multiple programs and we use Airtable forms for signups. One person can sign up to multiple programs. I have created 2 key tables: Raw forms table: Where all the raw data from the forms is entered. ...

Ben_Simai · May 02, 2022

Hi Airtable community, Looking for some help with setting up a basic CRM. Context: This company runs multiple programs.1 person can sign up to multiple programsWant to create 2 tables:Table 1: Sign-up forms: All sign-up form data sits here, there wil...

Ben_Simai · May 29, 2022

Hey @ScottWorld, Thanks so much for your time & solutions! This solution would work if there were only a couple of forms and only one field per form that renders the form ‘blank’ but unfortunately in our case we have many forms and many fields. But t...

Ben_Simai · May 25, 2022

@ScottWorld made another Loom video explaining

Ben_Simai · May 25, 2022

Hey @ScottWorld , That makes sense. The major downside is that I would need to do that for every field I want to look up. So, I need to create an extra 3 columns for each field which doesn’t seem very practical/sustainable :confused:

Ben_Simai · May 25, 2022

Hey @ScottWorld , Thanks for replying :slightly_smiling_face: I just watched your video - I should watch these more often! I have actually already set up that system and it works well, however, I need an extra step where it doesn’t just return the ...

Ben_Simai · May 07, 2022

Thanks @kuovonne & @ScottWorld for your help, much appreciated! I think I understood what you both suggested and have made a quick Loom video explaining the solution in case anyone else runs into this issue :slightly_smiling_face:

User Statistics

User Activity

How to lookup/return most recent non-blank entry

Creating a basic CRM in Airtable

Re: How to lookup/return most recent non-blank entry

Re: How to lookup/return most recent non-blank entry

Re: How to lookup/return most recent non-blank entry

Re: How to lookup/return most recent non-blank entry

Re: Creating a basic CRM in Airtable