Submitted on
Mar 10, 2020
05:09 AM
Submitted by
Maya_Bialik
on
Mar 10, 2020
05:09 AM

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
Submitted on
Mar 04, 2020
12:39 PM
Submitted by
Matthew_Thomas
on
Mar 04, 2020
12:39 PM

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
Submitted on
Apr 27, 2022
12:27 AM
Submitted by
Hendrik_Yang
on
Apr 27, 2022
12:27 AM

Hi Guys, Is there a way to invite users direct to Interface Designer and only have access for that specific Interface Designer?
... View more
Submitted on
Apr 25, 2022
11:38 AM
Submitted by
Samir_Ghosh
on
Apr 25, 2022
11:38 AM

May I suggest a very helpful, super simple to implement, feature? Problem: Sorting (ascending order) a single select that has empty values puts all the empties up front. Work around: Reverse the single select options order (put 1st at bottom), but this is a pain. Suggestion: You already have “Alphabetize” in Single or Multi Select, which sorts A-Z. Please enable a 2nd click to then sort Z-A. Voila! Now sort my view Descending and my empties will be at the bottom and my single selects will sort in the view correctly. A better, more intuitive solution might be to provide a switch in Sort dialog: “Sort empties at top/bottom”.
... View more
Submitted on
Feb 24, 2020
11:44 AM
Submitted by
Kevin_Li
on
Feb 24, 2020
11:44 AM

Grouped records and the summary bar - functionality here is great, but the only way to sort the grouped records is by the order of the grouped by field options. I’d like to be able to sort by the numerica values in the summary bar (e.g. revenue or # of records)
... View more
Submitted on
Mar 07, 2017
10:39 AM
Submitted by
Ryan_Jaccard
on
Mar 07, 2017
10:39 AM

In our CRM, we have a COMPANY Table and a CONTACT Table (among others). Within each of these tables, we have a CLIENT view and SUPPLIER view.
PROBLEM: EXPANDED RECORDS
That said, when I expand a record in the Contact Table > Supplier View, I’m inundated with irrelevant Client-Contact-specific fields (ex. ‘Won Projects’) haphazardly stacked at the bottom of the record. It’s become very confusing and bulky for our staff and, in my opinion, it’s probably a big reason so many of us wish we could ‘link bases’; but I won’t dive into that.
PROBLEM: EXPANDED LINKED RECORDS
Likewise, when I’m in the Company Table > Client View, and I want to access Contact Info for one of our Client companies, I’ll simply click to expand one of the linked records (linked from the Contact Table). In this case, I’m still inundated with Supplier-contact-specific fields, lumped together at the bottom. Ultimately, we need these gone!
SOLUTION
I’d love for a given record to expand into a Default Expanded View Preference (i.e. with default visible fields) that was specified during the creation of this contact/record (i.e. every time I add a new record to the Contact Table, I can select what type of record it is [“Client” vs "Supplier]; in turn, instructing AirTable on which fields are relevant to that record). The result, in the above example of expanded linked records — our entire sales team will always see this expanded linked record as a “Client”-specific record, per the records’ system-wide default expanded view setting.
DEFAULT VIEW & CUSTOM VIEW PREFERENCE
But then (hear me out!), once any given record is expanded, I’d like the option to specify, from a dropdown within that expanded record view, how I’d personally prefer to view that contact/record going forward. For example, the Default View for a given Contact record could’ve been set to “Client” when it was created; but, depending on my department and the info I typically need, I can now select an alternate ‘view preference’ from the expanded record drop-down (ex. maybe I choose “Client Finance Data” or “Client Holiday Gift Info”). Once I’ve selected a new expanded ‘view preference’, AirTable would remember this selection as my new personal default for that specific contact/record. The result — anytime the record is expanded by ME, I’ll only see the info that’s relevant to my work. If I need additional info/fields in the future, I can always change my “view preference” with the dropdown.
Again, I think this feature would help to calm people’s consistent request to link bases. I do believe all data can be kept in 1 base, and I’d prefer it that way; but we need more features to help us hide things that we don’t want to see.
... View more
Submitted on
Apr 19, 2022
03:09 AM
Submitted by
Gatlinburg_Moun
on
Apr 19, 2022
03:09 AM

Thanks for a great product! I have created a fair number of automations and my list is growing longer and longer. Unfortunately, they are shown in order of when they are created, and so the list is a mess. It would be nice to be able to reorder the list manually so they are shown in a manner that makes sense to the creator. Adding the ability to put them in folders would be nice too, but I won’t get greedy. Thanks again for a great product. I love Airtable!
... View more
Submitted on
Aug 14, 2020
04:43 AM
Submitted by
Nathan_Renner-1
on
Aug 14, 2020
04:43 AM

I would suggest that form submissions that include attachments should also be able to (optionally) include those attachments in the automated emails that get sent out.
... 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
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