This just came up recently, and I couldn’t find a similar request outstanding. Lately I’ve been working on a query generator for a client with some relatively complex database and reporting requirements. Frankly, as the base currently stands, it’s impossible to create a query using filters that meets his needs, as the values to match and the records to report are too distant in the model. To get around that, I’ve created a table he can use to build queries. Each record represents a single atomic query (e.g., ‘which customers bought a white widget in 2016 or 2017?’ or ‘who bought a widget at WidgetWorld in 2017?’). Up to five queries can be defined, and the individual queries can be AND ed or OR ed together to create more complex inquiries. Admittedly, it’s a work-in-progress, but so far it seems to be holding up. I’m about to add more potential variables to the equations — say, salesperson (‘Who bought a widget from John last year?’) or color (‘How many people bought camo widgets in 2012’). Currently, I have a <Make Selection> view that hides all but those fields pertinent to creating a query. I’d like to change that to <Make Selection> and <Advanced Selection> , with several less-frequently used values visible in the latter but hidden in the former. The concern is that the user may easily switch from <Advanced Selection> to <Make Selection> with a value or values still present in [now-hidden] advanced fields. I already have an {Alert} field that watches for common problems and flags them (for instance, specifying both a generic ‘during year 2017’ and a specific 2017 event [‘Widget World Asia 2017’]), and I’d like to expand it to include such things as values included in hidden fields. If I could do something like IF(@CurrentView='NormalSelect', ; advanced fields hidden IF( OR( Salesperson!='', Color!='' ), 'Alert! Hidden fields contain data!' ) ) then I could watch for such an error (and no doubt help prevent hours of confused troubleshooting). ... View more

For the URL field type, I’d like to be able to set a field option so clicking on the URL opens it in a new window/tab. ... View more

Being able to link records inline text blocks, inside long text fields. This would be a very helpful feature, I believe. ... View more

I’m trying to manage my Roleplaying campaign in Airtable but would like to link specific records inside some of my long text formatted fields for instance “Dargon the warrior is traveling to Flurgan the village.” can “Dargon” and “Flurgan” be links to records? ... View more

Should be possible to have a field for a QR-Code generating the information of an entry ... View more

I have a user case where I need to be able to have the form reveal, display or highlight specific fields based upon the individual’s first selection. All entries will update the same base table. Problem statement example: Are you Tom or Susan? If Tom: Show fields 1,2,7,8,10 for content input. If Susan: Show fields 3,4,5,6,9 for content input. ... View more

We are starting to implement using the Page Designer Block to create “Sell Sheets” for our vehicle inventory. While I can see that there are numerous benefits to this feature, one thing is throwing me off. The page alignment is completely out-of-whack; the first time I tried to print, the bottom of the page was cut-off even though it was visible in the “Edit Layout” mode and the “Presentation” mode. I adjusted and got it all to fit (had to move everything up about 1.5", which is ridiculous), but the margins are still mis-aligned. I’ve attached screen shots to show the print preview vs. what I see in presentation mode. Is anyone else running into this issue? Presentation Mode: note bottom of page and margin alignment Print Preview: Margins are widened significantly ... View more

I love the page designer.Although pretty barebones, I am aware that it’'s still a beta and knowing how you work, I fully expect that it will improve over time. One feature that I think is critical but missing is the ability to have the header to any column show a header. If you have multiple fields, having to manualy enter a text header and then match up the actual data is both a pain, and can lead to pretty serious errors. Currently, I can link to another table , but this A: is limited in it’s appearance, and B: I don’t necessarily want to create a link to another table solely to make the page designer work. ... View more

I would like the ability to control how many fields are visible on the record preview when embedded on a website. I use the “card view on desktop” option, and it shows the first 3-4 fields on the card. This can be confusing for users that think data is missing or incomplete. It would be helpful to be able to determine how many fields are visible in the record preview, before clicking to view the entire record. ... View more