I’m a relatively new user (started last week-ish), and while I love Airtable overall, one part of its behavior is becoming a little frustrating.
I’ve got a fairly simple base where I’m tracking events tied to specific clients. My first table is a list of events by date, with the client being selected in a field that’s a lookup from the second table. The problem I’m having is with delays in being able to select an option in that lookup field. Sometimes Airtable is fairly peppy, and the available choices appear in a fraction of a second. Other times I have to wait several seconds for the options to appear. I thought at one point that there might be a difference in responsiveness between tabbing into the field and typing part of the client name to whittle down the list for selection, versus clicking the + icon in that field to pull up the full client list. However, I’ve had delays with both scenarios.
My tables are fairly small: 39 events so far in the event table, and only five clients to choose from. If my client table were much larger (like in the hundreds), I might expect some delay as Airtable pulls things together, but with only five options, I don’t see the reason that it takes several seconds to show me the choices. This is primarily happening in the Mac desktop client, though I ran a quick test just now to see if the web interface would be any different. Sadly, it’s not. About a three second delay to show me the client options after I typed one character of the client name.
Are other users experiencing this same sluggishness? Is this just the default behavior of linking to another table? I thought about changing the client field on the event table to the Single Select type (which doesn’t have these delays for me so far), but I’m using the client table to tally the number of events for each client and run some other formulas, and linking the two tables is the only way I know (currently) to make that happen. If there’s some other way to optimize this setup, I’m all ears.