Mike_Ball - profile

Mike_Ball · Mar 27, 2024

HiI think I've been overthinking this and have brain freeze.Two tables Contacts (all contacts) and Students (people who have been trained, should exist on contacts)Both tables have email address as Primary fieldContacts has a Verification field which...

Mike_Ball · Feb 24, 2024

HelloI have two tables Customers and Orders. They both have a CustID to link the order to the customer that placed it.I need to import a CSV file to Orders and this includes the CustIDI can import as a regular field but can't figure out how to import...

Mike_Ball · Feb 23, 2024

HiI have two tables Customers and Orders. They are linked on CustIDI want to be able to find the latest order date (Order Date) for each customerAny ideasThanksMike

Mike_Ball · Apr 10, 2018

Hi Really simple requirement but just can’t get my head round it (put it down to advancing years) I want a simple HTML and JavaScript page with a search field that just searches a particular field in an airtable table and returns results Anyone got a...

Mike_Ball · Jan 12, 2018

Hi I am building a simple CRM. I have a Company table and a contacts table. On the Contacts table there is a Checkbox marking a single contact as the “Primary contact” I’d like to show this specific contact when I view the Company, effectively “just ...

Mike_Ball · Mar 27, 2024

Yes thanks great video which I already watched. Your material is fantastic and greatly appreciated

Mike_Ball · Mar 27, 2024

OK, thanks Scott. I'm a bit happier that I wasn't just being stupid but that seems a pretty limiting issue. I'll just do it with MakeThanks again

Mike_Ball · Mar 27, 2024

Thanks Scott. I did manually create the link (in Students, Link to another record, Contacts). Added a Lookup field of Verification (from Contacts)It's a feed (CSV file from another system), figured it would be easier to just bring them in as seperat...

Mike_Ball · Feb 24, 2024

Thanks again Scott. That is a massive oversight! My customer has an industry specific CRM with no API and only CSV export. We want to hold data for Make to report and send messages to customers who haven't bought for a while etc.I'm Make certified a...

Mike_Ball · Feb 24, 2024

Thank you both for taking the time to reply. Makes senseMike

User Statistics

User Activity

Simple 1-2-1 Linked tables

Import with linked data

Get latest order for a customer

Airtable on simple web page with Ajax

Link to another record dependant on a flag

Re: Simple 1-2-1 Linked tables

Re: Simple 1-2-1 Linked tables

Re: Simple 1-2-1 Linked tables

Re: Import with linked data

Re: Get latest order for a customer