Submitted on
Sep 09, 2021
09:25 AM
Submitted by
openside
on
Sep 09, 2021
09:25 AM

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
Status:
New Ideas
Submitted on
Dec 21, 2022
11:46 AM
Submitted by
Sean_Murphy1
on
Dec 21, 2022
11:46 AM

It seems that if I want to use a custom format for my Date field, I need to create a Formula field and use DATE_FORMAT(). Would it be preferable in most cases to offer a 'Custom' option in the 'Date format' menu in a Date field's settings? (see attachment) This would then show a text field where one could input the same formatting string one would give DATE_FORMAT(). That way I would not need to create a 'proxy' field to display the date as I prefer.
... View more
Submitted on
Mar 10, 2019
12:15 PM
Submitted by
KPR
on
Mar 10, 2019
12:15 PM

I love the ability to import images via a URL. One thing I’ve recently encountered is the inability to import images in the WebP format. Use of this image format is quickly becoming (annoyingly) widespread. This would likely require converting the images to JPG on import for storage, but that would be simple enough to code. (See: developers . google . com/speed/webp/docs/using) Currently, I’m having to use a third-party website to convert WebP images to JPG, and that adds another 5-8 steps in the process to import an image via URL. I would rather not have to leave Airtable to import WebP images as this is a function I use a LOT.
... View more
Submitted on
Oct 05, 2016
04:11 AM
Submitted by
Julian_Kirkness
on
Oct 05, 2016
04:11 AM

Hi
I am finding I am using Zapier to automate stuff in a client project and it would be much more useful if the integration were of the Instant type (as some other database products have with Zapier).
Example use cases
I have an app where a user can add an article to a table and the app needs to then work out which clients are due to receive that article based upon some logic (Javascript largely) in a Zap.
I specialise in HR software generally - in a leave app you need to be able to create records for each day of a leave (so that you can properly analyse it). This involves comparing the date for each day with the employee’s working pattern and also a list of public holidays to determine which ones are actually leave days. This should happen immediately when the ‘parent’ record is created.
I believe that this would greatly increase the flexibility of the product.
... View more
Submitted on
Oct 01, 2018
02:58 AM
Submitted by
Mathias_Elmose
on
Oct 01, 2018
02:58 AM

Hi there When you have a workspace with a team you end up with lots of bases and there is no way to organize them into subspaces or folders. Would be nice.
... View more
Submitted on
Mar 07, 2019
03:13 PM
Submitted by
Dereck_Hoekstra
on
Mar 07, 2019
03:13 PM

We should have an option to lock the positioning of the fields in a table in ALL views that are created. If you have a ton of fields and views in a table (say like 50 fields and 14 views), and you want to add/subtract fields to modify the data in it, it because very cumbersome to make sure the fields in each and every view are organized in the correct/logical order. Some tables don’t require the fields to be in unique/custom orders. It’d be nice to have an option/button that we can turn on/off for a table to force all fields in be placed in the same order. If you adjust the position of “Field 2” in “View 4”, then it’ll automatically update the position of Field 2 in the other 13 views in that table so you don’t have to manually drill into each view and drag Field 2 into the desired position. As tables generate tons of fields/data, this feature would really come in handy and save alot of time.
... View more
Submitted on
Feb 11, 2021
12:09 PM
Submitted by
Nicolas_Lapierr
on
Feb 11, 2021
12:09 PM

Hello!
We have a total view of run Automation in the Usage section of the Billing page. But it’s for all table, and all automation together.
I would really like it to be more specific.
To my need, I would like it to be shown in the Automation tab, for each automation. The number of runs executed so far for the period. It would allow us to monitor which automation are consuming most of the limit as well as seeing if some automation are running more than expected, etc, etc.
The total for each table should also been available for the same reason! The limit is pretty low, it would be very useful to see where it is spent!
Thank you 🙂
... View more
What is the proposed idea/solution? To hide the first (main) column of a table in a Grid element. How does it solve user problems? Not all tables' first column is important, especially for tables that mainly connect between linked records. While the first column cannot be hidden on Airtable base tables, it should be possible on the Interface Designer's Grid element. Who is the target audience? Those who use the Grid element on the Interface Designer.
... View more
Submitted on
Jul 31, 2020
04:10 PM
Submitted by
Jonathan_Lefebv
on
Jul 31, 2020
04:10 PM

This will be the perfect addon after the " Field & table editing permissions" and help avoiding so much errors! As simple as a checkbox, when it’s TRUE nobody can modify the record (except for formula, Rollup, Lookup fields) It could be the same look as checkbox but simply using the image of a lock. As options for the field ; ACTIVATE/DESACTIVATE Scripts can modify record while he’s locked (Could also select wich script) ACTIVATE/DESACTIVATE Blocks can modify record while he’s locked (Could also select wich block) ACTIVATE/DESACTIVATE Kanban view can modify record while he’s locked (Could also select wich view) ACTIVATE/DESACTIVATE Calendar view can modify record while he’s locked (Could also select wich Calendar view) ACTIVATE/DESACTIVATE Disable button fields while lock CHOOSE 1 OR MANY Fields you want to lock when activated (by default it would be all field, the same was as “Modified by” & “Last Time Modified” field) How I would use it : In my expense tracking base I would add a “Lock Record field”. Then I would set this field permission as ONLY my accountant would be able to edit it. Then when he validate the amount of the expense in the bank, all other user will not be able to modify the amount anymore. Same thing for a purchasing request base, if the manager agree to buy the item the employee requested, when he will lock the record the employee will no longer be able to change qty and item description.
... View more
Status:
New Ideas
Submitted on
Oct 09, 2023
06:47 AM
Submitted by
WestenGehring
on
Oct 09, 2023
06:47 AM

What is the proposed idea/solution? org chart extension: rather than listing every single field beneath the table heading, creating a searchbar option for each table where you type the field name in and the extension then shows ONLY the fields across the base that are connected/impacted by changes to that field. flow chart extension: (1)Allowing for more than a hundred records to be included, (2) arranging them to fill the screen rather than listed in a line regardless of whether they are connected to other records and (3) allowing for the possibility to zoom in and out How does is solve the user problems? org chart extension: currently, this extension is only practical for relatively simple bases. this change would allow for more focused conceptualizing and trouble-shooting of bases. flowchart extension: current configuration is very limited and difficult to use for tables/views with more than 100 records. these changes would allow for use with larger data sets and clearer visualization. How was this validated? Not sure what this means, but this is based on my own experience using Airtable. Who is the target audience? org chart extension: anybody who is interested in a powerful, usable visualization of their base (presumably most airtable users). i was extremely excited when i came across this extension, and i think the added elements mentioned above could make this much more useful. currently it feels more like a neat trick that doesn't work effectively for the bases that could benefit most flowchart extension: users interested in showing how records within a table are linked, particularly users trying to show a network of interrelated records (applicable for users in practically any field). my organization is building an international network of researchers on various types of perennial crops, and this extension could be an incredibly powerful tool for visualizing various elements within the network (hubs, sub-networks, geographical range of these sub-networks through color-coding... etc)
... View more