Hi, It would make my life so much simpler if we could write functions to pre-fill default values for fields. At the moment, I have many columns in pairs, one column with a computed “default” value, and the other with an editable value. (When the values are equal, I make the computed field display “…”) It works but it makes my rows really long! -Donald ... View more

Here’s the big Google/On2Air/Airtable update you’ve been waiting for! We now have multiple Google Functions in On2Air Actions to bring Airtable & Google Docs together at last! With the functions, you can now automatically create new or templated files in Google Docs, Google Slides, and Google Sheets using your Airtable data!! PLUS, if needed, you can create custom, dynamic tables inside Google Docs, Sheets, and Slides. A table will be generated each time based on the exact size needed to fit your Airtable data. Here are the big updates: You can automatically create files in Google Docs, Google Sheets, or Google Slides using the data you have stored in your Airtable records with our new Google Functions. 2. You can now generate custom templates and tables in your documents that expand with your data in Airtable. The table is dynamically generated based on the exact size you need to fit your data. (See our Google Table Template Guide) 3. You can create new folders in Drive and store the URL of the folder or the file in an Airtable field. 4. You can send entire Airtable tables to a table in Google Sheets with our Google Table Sync Function. 5. Generate any file into a PDF, Image, Word document, Excel file, or PowerPoint file, then save it back into an Attachment field in Airtable. (This allows you to replace alternatives such as Page Designer, Formstack, Docupilot, and more!) When you combine these new Google Functions with our On2Air: Amplify app, your new file (the actual Doc, Sheet, or Slide) will be automatically displayed inside your Airtable base for editing and viewing. Start a free 14-day trial of Google Functions :boom: You can use these new features for a variety of use-cases! Generate sales invoices and legal contracts Sync data and generate dynamic charts in Sheets Copy a template folder with all template files for each new account or client Create marketing materials Design templated or custom proposals for potential new clients Create presentations to kickstart new projects Distribute Quarterly reports using a combination of Sheets, Slides, and Docs Turn any record(s) in Airtable into a custom document Ensure company-wide branding assets to maintain consistency Dynamically personalize every document created This is a game-changer for collaborating in Google Drive and Airtable. You don’t have to bounce between Drive and Airtable anymore. It’s a Complete Document Management System. Manage your entire Google Docs environment inside of Airtable. Google Function features: Create new or templated files in Google Docs, Sheets, or Slides Automatically generate custom tables in your documents that fit your data Create new folders in Google Drive Send entire Airtable tables to a Google Sheets table Insert data from your Airtable records directly into any file Create dynamic files based on unique values in your records (ex: single-select options) Save newly created files all in one folder or in various folder based on unique values Generate PDF, Image, Word, Excel, or PowerPoint files and save back to Airtable Save the URL of newly created merged file in a field in your Airtable base Export the file and save in an Attachments field in your base Use the basic or shared Google Drive accounts If you have Amplify, you can edit and view any Google file inside of Airtable :timer_clock: We also added a new Scheduler feature to all our Functions With the Scheduler, you can choose how often you want your Function to run. Choose instant updates or specific minutes, hours, days of the week, days of the month, and time zone. With the scheduler, you no longer have to rely on Zapier or other service to process your Function on a pre-set schedule. What are Functions? Functions are no-code pre-made tasks for your bases, tables, and records in Airtable With pre-made functions, you can perform a variety of tasks on your Airtable data. You can convert URLs into Attachments to store in your Attachment field, copy fields automatically, create default values for any field, import data from a URL into a table, calculate simple and complex financial equations, and much more. You can see all the available Functions on our website. How to Get Google Functions New users start with a 14-day free trial, so go create a Google Doc, Sheet, Slide, or Drive folder today! If you’re a current On2Air customer on a bundled plan, you have Functions already! Log in to your On2Air account. ... View more

I realise that this must feel like old ground and a Iknow a lot of poeple have been begging for this for a long time and I know you think were very pleased to announce you’d fixed it - but certainly with regardless the long discussions earlier in the eyar - you obvsiously werent’ reading it properly. Taht group weren’t asking to embed stuff IN airtable - why would you want ot do that when you can only share it with users or put it in the programme. This content is made to be published obviously !!! And these days for most of us that means in our website. bAsically you’ve developed a lovely dashboarding tool but wont let us actually use it. We want to embed blocks and the pages they are in in our EXTERNAL WEBSITE. not the other way round. And no, the embed one block with the table isnt’t he answer and no just being able to view a picture isn’t the answer - integrated, live data from airtable into our websites pLEASE ... View more

My team and I would love to work asynchronously on one airtable but when we leave each other comments on records the number stays there forever so we have no way of keeping track of what still needs to be discussed (you can erase your comments but not others and that way you erased the convo!). I’d like a way to get rid of the number shown on the record please. ... View more

Is it possible to import fonts natively or through a workaround for the page designer block? Looks like it’s just google fonts? Thanks for any insight. ... View more

It would be useful to have a “Button” field type that you could use to trigger an action (e.g., perform a calculation, run a Block, trigger a Zapier Zap, run a script, run small automations, etc.). Even though some of this functionality can currently be hacked-together using other fields like checkboxes in conjunction with Views and Zaps, this is something that has to be explained ad nauseam to new users. So, instead of having a “Submit” checkbox in a workflow that can accidentally ticked, having a distinct “Submit” button would be much, much more clear to novice/infrequent users. This is a feature currently offered by Coda. help.coda.io Overview of Buttons Learn how buttons can create workflows and an app-like experience in your doc ... View more

These posts are asking about a feature similar to the “filterByFormula” in the standard API, to programmatically filter record selection.   Can table.selectRecordsAsync() query a table or view? Scripting app I see that you can get all records from a table or view - and even sort them. But what if you want a subset - for example all those records connected to another record? It’s not always possible or desirable to create views for this type of thing?   More efficient way to query records? Scripting app Is there a way to retrieve specific records without iterating through all the results of a table using table.selectRecordsAsync() or view.selectRecordsAsync()? Something like SELECT / WHERE queries in SQL? Or in AirTable terms, a Filter? This would be far more efficient than having to iterate through returned records checking for the records I’m interested in… My request is slightly different and I think falls into the “interactive” idea behind the scripting block: session.selectedRecords() . The idea Each record can be selected with a checkbox on the far left-hand side of the row, or all records can be selected from the box at the top. The UI allows users to “Send” or “Delete” the selected records from the base when right-clicking after selection. Providing a scripting block some way to detect which records are selected could help with more granular use-cases. For example, the user wants to update 4 records in “GroupX” and 2 records in “GroupY”. Right now, there are easy ways to filter records matching “GroupX” OR “GroupY” but not a mix (absent other algorithms for detecting the desired records). Potential issues One implementation issue that comes to mind is when does this selection get stored. If a user runs a scripting block with “N” records selected, provides some information via an input.textAsync() and deselects some records before submitting the text, does the script use the selected records at script start or at moment of execution? What do others think? And anyone from Airtable, can you give hints if this might be in the works (or any other session variables for that matter)? ... View more

Okay, I’m going to make this ask as simple as possible: Give us the ability to define a new Airtable formula function called UUID() The output of UUID() remains STATIC and anchored solely to the RECORD_ID() value. This means the ONLY time UUID() values change IF and ONLY IF the RECORD_ID() value changes. As a byproduct of this, whenever you duplicate a given record/row, that duplicated record/row’s UUID WILL BE DIFFERENT than the source/original record/row. ... View more

When I open the search bar, it covers up my column titles, which makes filling information in the rightmost columns difficult. It would be nice if the search bar opened here: ... View more