Other Questions

Hi all,I work for a marketing organization and we use airtable frequently. We have different bases for each job (graphic design, writing content, digital marketing content, and website content). We would like to find a way to move tasks/projects from base to base. (Ex. creating a postcard. Starts in Writing Content base and then move it to Graphic Design base once writing has been completed). Is there a way to move tasks from base to base, as well as notifying the correct person once it has moved? We would like to make things more efficient instead of sending emails to the appropriate person, letting them know that one part of the project has finished and they can start working on their part of the project.

I’m having trouble writing a script that creates new records (representing jobs) based on the following parameters: start of date range end of date range days(s) included That is, if Mondays are included, create a job on each monday within date range. I use a function to add jobs onto a stack, and call the function for each day of the week as required. My stack is defined outside the function as: Let newJobs = ; The new records created included a date field. That’s the problem. I can see my function looping through the dates correctly, and even pushing them onto the stack. But when everything is finish, every job on my stack has the final loop date. The same date. It was updated even after being added to the stack! Function is: function addJobs(opp,start, end, offset) { let jobDate = new Date; if (offset >= start.getDay()) { let addDays = offset-start.getDay(); jobDate.setDate(start.getDate()+addDays); } else { let addDays = 7+offset-start.

My plan was downgraded since my team member has added one extra-collaborator and missed some invoices since it was overlimit and supposed to be billable.Before we were on annually paid team plan.We deleted an overlimit collaborators and want to get our team plan back. Any suggestions how it can be done?We have already reached a support via mail but I am just curious if it could be done any other way.

Hey there! I’m syncing some records from Base 1 to Base 2, and that’s working just fine. In Base 2 I need to be able to add additional records alongside the synced ones. I set up an automaiton to copy these new records over to another Table in Base 2, which works perfectly. I was then trying to use an Update Record automation to copy changes, which tests fine but fails in practice with an error. Is that possible, or is there a better way to accomplish this? I was using Find Records with a condition of my manual unique ID (not the Airtable Record ID), which it seems to do, and then try to apply the updates to the Record ID from that step (Step 2). It all says it’s good, and can even update it from “Run As Configured” - but it fails when I test it by updating Base 1 and syncing Base 2. Updates fine in the sync but fails to update the record in that second Table. Thanks!.

Hello,Your help will be appreciated with the following issue:I have created a form and shared it via a link ("Share form" button in a form view). I need to fix typos in the form description. When I change the content of the form (in the form view), the webpage displayed via the shared link does not change accordingly. Same for the page displayed via the "Open form" button (actually this is the same URL as the shared link). I am under impression that it should.I recall that several weeks ago Airtable seemed to be working differently, i.e. the changes made in the form view were propagated in real time to the webpage reachable via the shared link (and via the "Open form" button).I do not believe this is a problem with my local browser cache, because others who open the form page on their computers for the first time ever, still see the outdated form (while their browsers did not have a chance to cache anything yet).Am I missing something, or am I seeing a bug in that the changes to t

Hopefully I’m posting this in the correct section. If not, please direct me to the correct one. I was going to post in the API section, but this seemed like a “broader” section to start with. I have setup AirTable to support a gaming group of which I’m the admin. The multiplayer game does not have any admin tools leaving us to develop our own solutions. Having done table design and DW/BI work in the past, I was able to build the table structure and views without any difficulty; once I learned how the table linking worked in Airtable. I’ve even been able to create and post the “forms” for users to input data and respond to events with their “bids”. The next logical step is to create the output I need. I’ve attempted to connect Excel to Airtable with little success. I can get the connection created, but I only get a single field of “Record” values. Total rows is correct, but I can’t see any of the fields. I’m familiar with ODBC, SQL, etc. but have no experience with JSON, Java or

Hi. What is the best way to export AirTable data for use in Microsoft Word’s Mail Merge tool, and have it updated in Word after making changes in AirTable?

Hey guys, I’m fairly new to airtable, but i’ve read all the posts i could find on this topic, but still stuck. I have a list of clients and a list of vendors. some clients prefer only a subset of vendors - i define the preferred vendor relationship in my base design. I have a form that collects requests to engage a vendor for a quote. I want : Basic: Based on client selection to present only relevant vendors in the list. Advanced: I want to present relevant vendor based on vendor category in addition to the above what’s the best way to do this with the newly added functionality of logic on lookups / rollups etc? Thank you guys in advance!!!

Hello! How to link tables, but to include info in form of linked variants to choose from? Here is the deal. We sell cars. And need Airtable as a database to synch to our website. Our team members add cars to the database. The question is: How to make dropdowns in columns from linked tables, so they would “know” the previous column and provide an option to choose from a specific number of variants? Here is an example: We want to add a car. It has a lot variables, some of which are: “car maker”, “model” and “specification”. I would like to have a columns dedicated to each variable. But so if for example I choose “car maker” Mercedes-Benz, in the next “model” column I would get only Mercedes-Benz’s models, and after I choose, for example “S-class”, in the next column, “specifications” I would only be able to choose from that model’s specifications? How can I achieve that? Spent too much time trying to solve that problem Thank you!

Hi! Mailed support and didnt get a reply. So Im trying here instead. I understand one can have a conditional dropdown that adds all the values from a linked table. But what if I want to select between the values? Lets say I have TABs called “Company” “Office” and “Employee”. Now I would want to add an Office to an employee - but only the offices linked to a specific company. How would one do that? Im guessing using IF statements - but would it work for string values? Regards, Vincent

Helllo, New to the Airtable platform. I am wondering if this is possible. I am developing a manufacturing schedule and in the schedule you have a Phase and multiple (different) steps in each phase. Ideally I would like a (2) drop-downs side by side and the second one becomes dependent on what you chose in the first. So if i Choose Phase 3 the second column would only show steps associated with Phase 3 not all the others. Thanks

Requires Linked SingleSelect/MultiSelect Dropdown, which can be restricted on the basis of any criteria. In particular I need Dropdowns, which offer a subset of choices based on the result of another dropdown/field. For example, I would like to have a drop-down “LAND”, which gets the data from a separate table (LAND, REGION). The table would then look like this: COUNTRY, REGION Switzerland, Aarau Switzerland, Bern Switzerland, Zurich Germany, Baden-Württemberg Germany, Lower Saxony Germany, Saarland France, Aquitaine France, Brittany France, Poitou-Charentes …, … A second dropdown “REGION” should then only show the regions matching the selected country. Then the second dropdown should only show “Aquitaine”, “Bretage” and “Poitou-Charentes” when I select “France” as the LAND. If I look up in the forums, this is probably a very popular wish for a long time. Is something like this available now and if so, how does it work?

Hello Airtable Community.  I've reached my wits end and so has chatGPT 🙂  I am using the following scripting code in an Automation to extract some data from the record that triggered the automation and insert into an external API.  Most of it is working as expected until the very end of the first function where I keep getting   CONSOLE.ERROR "Error processing Airtable update:" "Unexpected end of JSON input"  I've tried lots of logs to understand the input and everything appears in order to me.  JSON is coming back fine in each of the "console.logs" indicated in the code here.  An example here:What could be causing this error?  Source code below:  // Function to escape HTML characters function escapeHtml(input) { return input.replace(/</g, "<").replace(/>/g, ">"); } // Airtable Script to trigger on "Terpene Tags" field update // Airtable Base ID and Table Name const AIRTABLE_BASE_ID =

I am hoping someone can help answer this basic question.We have a survey where our athletes answer using a ranting system. I want to take the rating once in airtable and assign it a number value. 1 star = 1, 2 stars = 2, 3 stars = 3, 4 stars = 4, and 5 stars =5 so I can total.Is this an easy thing to do or do I need to get the data into a number before it hits airtable?

Has anyone succeeded in merging Airtable data with InDesign CC layouts/style-sheets? :nerd_face: We’d love to be able to leverage online datasets to populate nicely designed layouts for PDF export. This export will be done both locally, as final artwork files for professional print; and hopefully… automatically. We’d :sparkling_heart: LURV :sparkling_heart: to be able to generate PDFs, in the cloud, using real-deal layouts, that can then be relayed/ingested via other integrated services like Dropbox, Slack, email, etc. How would you build an Airtable-InDesign CC-Google Cloud Print-Slack/Email stack? THANX YALL! :dancer: A.

I have a form built. Today I was asked to add an option to a multi-select field and published it. I added the option and it is showing in all views and in the preview, but it is not showing on the public-facing version of the form. I am not sure what I am missing that is causing the option to show everywhere except the public-facing side.

I’ve got two tables that I’m embedding in a Sharepoint page, using an iframe window. They work great, except that there’s some kind of splash screen showing the Airtable logo that doesn’t go away until the user mouses over it. Is there a way to disable this and have the tables load automatically without any user interaction? Here’s what it looks like before loading: Thanks for your help!

Hi  I'm familiar with the Maps extension in AT and using it without issue but I'm interested in making the map public and embedding onto a website. I've seen some posts about this coming at some point but they date back a few years and so I suspect that's not happening anytime soon. So my question is, what is the easiest way to do this? I understand there is a Google API (Many Map API's) and also some mention of Mapbox but they both seem over complicated for my usecase. This is a very simple request of maybe 10-15 points on the map that could change every few weeks. Has anyone done this, any pointers on the easiest method ? Much appreciated  Jason 

Hey guys,I am looking for a way to help restrict access to certain bases I have in my workspace. I thought using groups was the answer, but that doesn't seem to be it as the groups still have overall workspace access and I can't seem to remove someone who's in the workspace from a base.We have our workspaces separated by the different companies in our parent company and then within each workspace is a base for the different departments. I have groups for the different departments as well that I was hoping to use to have for example the GFX department have access to only the GFX base.Does anyone know how I should be using workspaces, groups, and bases to restrict access? I feel I am using these wrong.Thanks!

Hello,I manage an Airtable base for a motorsport event management company. Right now, we have to use JOTFORM for the customer registrations, because the company uses Authorize.net, and the client wants the registration form to be submitted with payment in the same step. Upon looking into Zapier, they do not support Authorize.net. (So if you know a workaround for this, we would LOVE to just use Airtable instead of two different platforms for customer registration.)But! That's not the main issue at hand. The main issue is that my client has a list of Instructors for these events that we are currently registering via a form on Airtable. However, the instructors have to fill out the entire form for each event, and this is a bit tedious and redundant, and causes us to have to go in and delete duplicates if the instructor has forgotten if they've registered for the event or not, and fills out another one. I have sifted through the community, and youtube, and still haven't been able to find a

Hi, I’ve created an interface from my base which I’ve tried to share with users who work off iPads. I’ve tested two so far and while the interface works on The iPhone app on the iPad no interface shows up

When I select a lookup field in Airtable, it retrieves all the values within it, but I want to make a selection from within this lookup field, is this possible?

I have a list of records that's something like this. PROJECT NAMEPROJECT VERSIONCONTACTASSIGNEEApples1JoeBobApples 2JoeBobBananas1SallyJimOranges1JoeJudyI receive a .csv report with the most recent information about the first three fields every week. The fourth field (assignee) lives only in Airtable. There are additional fields as well as notes and comments on the records that need to be maintained. The weekly report often includes changes. For example, a new "active project" may be added or something might change about the project, like the CONTACT field. Example .csv report:PROJECT NAMEPROJECT VERSIONCONTACTApples1JoeApples 2JoeBananas1JillOranges1JoePears1JoeWhat I'm trying to do is find a way to import this new .csv report and have Airtable update/merge the existing records that have changed (in this case, the CONTACT on Bananas project is now Jill) and add any records that didn't already exist (Pears project). The CSV Import extension only allows you

The Google Vision API extension offered by Airtable works well enough if one wants to retrieve labels, logos and texts from an image. However, the Google API offers other capabilities, such as tagging offensive images and, what interests me most, calculating the dominant colours of an image or suggesting cropping possibilities. The Airtable extension doesn't seem to give access to any of this.Is there something out there already that might allow me to retrieve those extra features and insert them into a field in my database ?Thanks.  

I am receiving this notice when attempting to upgrade: "We were unable to upgrade you at this time. Please refresh the page and try again. If you continue experiencing problems, please contact us."I was charged and my upgrade has not been reflected. I contacted customer service but the 1-2 TAT turned in 6 days -- no response. Any suggestions?I would think a financial ticket would be considered important.