Ask the Community

I’m creating an extension here. Often times I want to send record from extension to my backend api. My backend already supports the json serialized format returned by get records api. It would be very helpful if there is a method to convert record object in blocks sdk to that format. Or is there already a way for that?Thanks

Trying to build an automation where an email is sent when a record enters a view (specified by a month status). The record contains a previously uplodaded file (pdf). Up to that point I’m able to make the email automation work, but when trying to add a last “update record” step (so that the record is updated after the email has been sent out, by having its status changed/updated) I get an error. Seems as if Airtable wont be capable of updating the record  “status field”  because the record contains an attachment. Trying to work a solution that will allow me to keep using the product. I have a paid version.  

Hello, I have a main base and several project bases that have a two-way sync with this main base. In these project bases, I receive data from my main base, but also have columns specific to these project which are freely editable by the teams.I would like my columns from the main base (the sync one) to be in editor access to the teams (values are editable, but not the column), and the non-sync columns to be in creator access to the teams. How can I do that ? Thanks !Agnès  

I am perplexed by the labeling in Airtable Calendars.  In the attached screen grab, I have two projects in a single calendar, separated by color.  Great. However, it does not show the label of the fields I have associated with dates, even though it seems like there is ample room. So great, let me enable the labels I want.  Except it doesn’t show the labels, it shows the date, but instead of just including the date on the specific entry, it puts it on ALL entries.  Very perplexing.  Why would I want to show the date of one entry on a completely different entry that falls on a different date? This makes no sense and can not imagine a case where this would be useful.  Why won’t just show me the label that is already there on a specific date? Is there away to show the whole label on a given entry? In both the Interface and Calendar view I see this and can see know way to show the entire label.

When using a form, I want to offer specific choices for students to choose from, but I also want to offer them to option to fill in some option that we haven’t thought of. (As in, “how did you hear about us? Internet search, friend, Facebook, other- tell us how”) Thanks Linda

Is there a script that can initiate printing of a record designed in the printing extension from an interface? As in, Print This Record?

I am importing three different reports into the same table.  One report’s DOB field provides the date as we wish it to appear, MM/DD/YYYY.  The other two reports provide a DOB format of DD-MMM-YY.  I am using a formula to convert the DD-MMM-YY format into MM/DD/YYYY and then using an automation to move the DOB Calculation into the DOB field.  Some of the converted dates are future years.  The formula correctly converted 23-Sep-97 into 9/23/1997, but 29-Jan-56 became 1/29/2056.  How do I get the formula to create DOBs in the correct century?Some years convert correctly, others not so much.Current formula. 

Hello Community! Has anyone had success printing from the new Interfaces feature? I’ve created some texts and a table in the new Interfaces feature - basically it’s a nice checklist. When I do a basic print - the formatting is way off and my table doesn’t fit on the page. I tried using the app Page Designer, but it doesn’t appear that you can select an Interface to load into Page Designer. Thoughts? Suggestions?

I’m running into an issue where a URL prefill is linking the correct records to the form, but showing them as “unnamed”. I know they are the right records, because when I submit it shows the correct records. This wouldn’t be a problem, except for the fact the the user needs to see which record is which employee, so if they need to they can remove someone that left early, for example. Anyone have any ideas how to have it show the names of the employees that definitely are not “unnamed” and have something in their primary field?We are using Record IDs to prefill the Employees field.Thanks in advance to anyone that has any ideas or suggestions!

Is this scenario possible?I want to automate a task on my team in which a team member would create a record and attach a word doc to it. The team member would then fill out a form which allows them to attach the record they just made (or any record via the dropdown that lists all team member-made records). Once they submit the form, it triggers an automation to send a pre-determined Teams message with the record chosen from the form. I successfully created an automation to make part of this happen, but i can’t get it to attach the record (because the message is static and the attachment is dynamic?) Is there a way to make this work??

I can’t see anywhere which would state if my level has been set as builder or end user? 

Hi all,I am struggling to find a solution to this, and I wonder if it’s an easy problem. I want to upload an attachment to an Airtable base for a specific record/field; I am following the instructions reported here: Upload attachment - Airtable Web APIHowever,m I keep getting error 403. I can create and update records, but the image upload is not working. Any ideas? 

Hello all,So I have been uploading attachments to a field through a google share link and have made sure to make the file and folder public but for some reason when i click on the attachment it just comes up as a blank screen and says loading but never loads. The share link is fine as when I put it in the url bar it works perfectly. Im unsure what is causing this??

Hi everyone, I’m setting up a project management base with dependencies between tasks. I have two questions: In some cases, task 2 can begin before task 1 ends, but the completion of task 2 does depend on the completion of task 1. There will simply be some overlap in when both start (e.g. parts of task 2 can be started before task 1 begin, however until task 1 is completed, task 2 cannot be fully done). I have set up the dependency as Task 1 → depends on → task 2. However, this then shows up as an error: Task 1 begins before Task 2 ends. Is there a way around this? What happens when you have some dependencies in the same table that are predecessors and some that are successors? Thanks a lot in advance!

Hi all, Any help would be appreciated on this one. I'm working on an automation in Airtable we previously used Zapier for to try and streamline some self-fulfilling on-demand educational resources. The way I currently have it set up is in one Airtable base, but two separate sheets. One sheet has an external-facing form for people to order course content through, another sheet has the content listed by name, in zip files or individual files. The names match the form exactly, and I have tried two different methods to get the automation to grab the content from the form sheet based on the name: multiple select and link to another record. Any way I do this it provides all or none, and won't search by name. The content is currently fulfilling best in an Attachments field in a zip file as it ranges from PDF documents to videos to PowerPoint files. The actions I'm using are 'When a form is submitted', 'Find Records', and 'Send an Email'. I've attached images of the

TODAY() and some similar functions are broken because they're stuck on Greenwich Mean Time. What it's meant to do is return a value that changes once per day, at the start of the day. It does this by setting the time part of the current date and time to 0 but, because Airtable's internal time zone is GMT/UTC and yours probably isn't, the result of the function will never be the start of your day. Any formulas that rely on it will have flawed results. The effects depend on how far from GMT your time zone is, and how accurate your formulas need to be. During summer in New Zealand, for example, with an offset of +13 hours, it behaves like a YESTERDAY() for more than half of each day. In California it becomes TOMORROW() early every evening. It can wreck reports and automations.Changing the time zone in the formatting of any formula that uses it

Does anyone know the names of the colors in Airtable? Thank you.

We are looking to reply to specific Slack messages to update product status. While it looks like it’s possible through Slack conversation IDs, I haven’t found documentation on how to set it up. Does anyone know how to do this without an external automation? I checked the following thread from 2 years ago, but it mentioned Make (an external automation tool) - I don’t believe my company will allow such integrations: 

I don’t want to be overly negative as I love Airtable, as do my clients. But can Airtable slow down in integrating new features without proper testing. In the past couple of weeks since developers integrated Interface/data layout into one in the home view, there have been so many bugs in the system. I am all for new integrating and love the direction the company is going. However, don’t be premature about it. Every time I am using Airtable now there are new bugs and I don’t have time to send Airtable developers feedback and examples... It’s hard to keep up (more a clients perspective) with new features, new layouts and new bugs. To the developers, just make sure your ready before publishing new layouts and features please 🙏

Please excuse the long explanation..I have a spreadsheet showing some factories producing a number of products. For the sake of the example, let’s assume that the factories are the primary records and the products that they produce need to be split out in to a linked table.So the source spreadsheet looks like this:Factory City Country Product Acme Tools Denver USA Spanners Acme Tools Denver USA Screwdrivers Western Hardware Paris France Spanners China Supply Shanghai China Hammers China Supply Shanghai China Screwdriv

Hi there, What is the best way for me to not show anything from FY25 in the graph below? I have tried to add filters but it then shows up with no data. Filters triedDoes not contain FY25Contains: April, May, June  Many thanky

Anyone know if/how to change the default behavior of clicking Interfaces when in Data Mode. It defaults to design mode so I need to click Interfaces and then click Open. I could have sworn it took me straight to interfaces prior to the most recent UI changes. 

I am looking for a way to change the way that my shared Airtable base can be shown as the preview when sharing the url, instead of the generic “Airtable, everyones app platform” being shown. I frequently share the base, and people aren’t opening the base, or are wary to because they dont know what Airtable is. Please tell me there is a way to have a different preview shown? Do I need to first embed it in my website? I am open to paying, or outsourcing but I am just not sure how to start! Uploading: Screen Shot 2022-06-08 at 9.32.46 AM.png… https://airtable.com/shrbYQAOhU8YNsK99

Trying to figure out how to have the Interface “Button” When clicked it will go to the form I built? Do I use external URL?

Hi all,I am desigining an interface and using newly released Portals add-on of Airtable to share the interface with guest users.While the login is working fine, the base name, notification and profile buttons are still visible on the interface. Ideally for whitelabelling, these options should be removed.Note: I am on Team plan