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

Problem: Sorting a select field puts blanks at the top.  Often, we want blanks to sort at bottom. Suggested Solution: Sort the select field in descending order in the view.  That puts blanks at bottom.  However, then your select values are in reverse order.  If you could sort the select field options (in the field) in descending order then all would be good in the world:  blanks would be at the bottom and options would be at the top sorted in ascending order. Implementation: Best part, implementation is super easy.  Currently you can only sort options in a select field in ascending order.  Just enable clicking on the sort icon to toggle between ascending and descending sort of options in select/multi-select fields. ... View more

Hi. I am currently in testing mode with Airtable and have to say: I really like it. There is one thing which I currently came up with and I would like to share: New field type “Action Button” which triggers an action (the one I am thinking of is something like mail the record to someone, sending any kind of answer/feedback … there maybe more actions) which could be very useful esp. when your table is shared via html. Michael ... View more

Please add the ability to set a default option in Single Select fields, akin to the Default Text feature currently offered in Single Text fields. Thank you! ... View more

Activate an option to scroll horizontally with the mouse wheel. Useful on table view when having lots of fields. ... 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

I’d like to suggest and request a new, COLOR field, that can be set to accept various color values/standards, previewing the resulting color full-cell. At minimum, I’d expect this field to support the same color strings/syntax as the current Color Palette block, but ideally many more color standards. A deal with Pantone/X-Rite would allow PMS/TCX lookup, something we’ve had to build-out manually, and without the benefit of any real end-to-end color management. Adding this would make Airtable the immediate leader within the creative/product sector. We deal with color calculations daily. Thanks!! A. ... 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