Other Questions

We are looking to import a large Excel dataset into AirTable, ~500 multi-sheet xlsx files, as individual Bases. The Add a Base > Import data > Excel file selector has a limit for 1 file. Is there a means of creating multiple Bases off of a bulk upload process?

Hi All, Here is what I would like to achieve: • I have a table that list our Items with many specifications fields and also prices fields. • I want some of my staff to see all fields. • I want to hide prices fields to some other specific staff. • I want all staff to be able to edit the values. Note that I try to stay very open in the description, I don’t mind to adapt the way to laydown the info in order to fit the optimal solution. What would you do if you were following the most common sense to achieve this result in Airtable? Thank you all ! Greg

Hi all, First, I want to thank you for your help with various issues. Some of these issues got resolved by only reading, others resolved by opening new threads like this one. I wasn’t sure if this issue related to the Automation forum, or the Formula forum - so I thought it would be best to use a general forum. Feel free to change its location as you wish! I need your help with choosing the best method to design a new field based on other fields. This process needs to be done on more than one view in the same table, for different clients. On each table, I want to create a new column that contains data from 2 different columns and convert data for the third one. Meaning: Let’s say I have a column named ‘Fup’ and contains multiple tags (fup1, fup1b, fup3, fup32, fup21c, etc.) I have another column named “User” and another column named “Receiver Name”. I want to create a new column, let’s call it “Fup text” with a long text based on

Hello, I am using a form embed in a Webflow website to gather data from a logged in user. However, if you begin to enter any data and then navigate away from that page you get a browser alert pop-up that says “Leave Site? Changes that you made may not be saved.” This makes sense if you’re halfway through entering a form, but it will still pop up after the form is submitted. Is there any way to disable this alert, at least after a form is submitted?

Is anyone else experiencing this? I use an NFC tag system to open URLs quickly to specific records relating to each job I have in my workshop. This has been reliable since June last year, and just broke last week. Now it only opens the airtable app on the home screen and doesn’t go any “deeper”. I have tested this in the desktop browser version and it works fine, it’s just the Android App im having trouble with. The URLS are listed in my airtable, so I have also tested clicking from within the app (to rule out problems with other apps on my phone) and the same thing happens. Like I say the URL’s are solid, and its nothing to do with the NFC end of things. This started happening around 7th Feb '21. I am on Samsung SM-N960F running Android 10 Kernel 4.9.118-19869079

Ik zoek een Nederlandse Pro gebruiker die voor mij 1 workspace voor mijn database wilt hosten. Ik heb nu een free plan waar ik maar 1200 rijen kan maken. En geen blocks kan gebruiken. Dit is mijn database Airtable - www.ishetcg.nl of kijk op www.ishetcg.nl Mijn database is een verzameling van Curly Girl producten die op naam, categorie, ingrediënten en winkel is te doorzoeken door bezoekers. Hij wordt veelvuldig gebruikt door mensen die een CG product zoeken. Ik krijg er geen cent voor en het is gewoon vrijwilligerswerk. Om anderen te helpen. Zoek op CG methode voor meer informatie over de producten. De CG methode is vooral voor mensen met krullend haar. Ik wil graag mijn database uitbreiden tot zeker 2000 rijen. Maar voor waar ik hem voor gebruik vind ik de 10 of 20 euro per maand echt teveel. Ik leef van een bijstandsuitkering en doe dit vanuit een goed hart. Dus ik

Hello guys, I’m looking to use airtable to apply improvements to internal projects of my organization. We use the PDCA method, please does anyone have a model that can be used as a reference to share?

Hello, Hopefully, someone can help shed some light on this issue I am having pulling text from a ServiceNow form. I don’t know if the issue I am running into is because the input type is “hidden” or if it’s just the input field that I am not understanding how to pull. I found this article but don’t know if Airtable will take the same syntax. I have tried and it did not work for me. Help! How to scrape a hidden input value? - How to? - Web Scraper The fields I was trying to pull from were the (Number, Request, and Request for) The number field cannot be changed. I am guessing this is the hidden field. Instead of pulling the web clipper from that field, I ended up pulling the information from the upper left nav field, but I still need to pull data from (Request and Request for)

Hi, I am trying to automatically populate/import a picture in the attachments field every time a record is created. I am not sure how to do this. Any suggestions? The picture needs to be attached to every line item under the attachments field. Thank you!!

I would like to copy the list to text outside of airtable. Thank you.

I’m trying to paste data from Excel into AT, and usually when I paste, it asks me if I want to Expand the table. I don’t get this message, and nothing will paste. Help!

It appears as if some records in field have a space before, so it doesn’t sort correctly. How do if fix it?

Hi, I’m guessing the “charts” app would be the way to do this, but I could be wrong… How do I create a chart/graph that tracks my current finances (i.e. bank balance) towards a goal (monthly and/or yearly)? For example… I input expenses/income every day into respective views on AT and those numbers feed into a “totals” view… From this totals view, I’d like to have goals set up (and the chart) so I can see if I’m on track to reach a set goal for that month… Any assistance would be greatly appreciated. Thanks in advance. -Christopher

I selected a hundred records and used the delete button on my keyboard to remove the content from them. I need to restore that content. When I expand each record I see the removed content of that particular record. See screenshot: Is there a way to restore the content of all the records? I’m new to Airbase and had not done a snapshot. Thank you!

I am using python to run sum calculations and data summaries at various sub-groupings. This is being done using python pandas and the data format is a dataframe. I have to convert this dataframe to a list according to the airtable python wrapper documentation, which I have used before, just not the dataframe part. After converting to a list, I am getting this error requests.exceptions.HTTPError: (‘422 Client Error: Unprocessable Entity for url: https://api.airtable.com/v0/appQzuUudoe2rSAR0/Test-2’, “422 Client Error: Unprocessable Entity for url: https://api.airtable.com/v0/appQzuUudoe2rSAR0/Test-2 [Error: {‘type’: ‘INVALID_REQUEST_BODY’, ‘message’: ‘Could not parse request body’}]”) is anyone familiar with this any why it is happening?

Hi, Apologies if this has been covered elsewhere. I’ve got a table with 3 fields: Customer (Single Line Text) Interests (Multiple Select Field) VTS (Formula Field) and I’m trying to get the VTS field to populate with the Customer Code if “VTS” has been selected in the Interests field. I used the formula IF({Interests} = “VTS”, {Customer}) Screenshot 2021-02-13 231010|700x490 and it returned a result when “VTS” was the only item selected in the Interests field, but not when more than one option had been selected. I’m assuming it’s the equals sign that needs editing, but I’m not sure what I need to replace it with. Any help would be much appreciated.

The airtable app on the iPhone doesn’t make any sound alert when a collaborator mentioned me. How can I solve that problem?

how to copy and paste an excel date field to Airtable so it can be formatted as MMM-YY, iie., Dec-02 is Dec in year 2002. copy and paste an excel date fields to Airtable

Hi. I created an Airtable form template that I would like to use in multiple bases. Is there a way I can just upload the template into each base rather than having to recreate the form in every base?

Hi Community, I’m very new to AirTable and still trying to figure things out, but am having issues syncing ONE of my iCal calendars to AirTable. I see all kinds of descriptions of how to sync an Airtable calendar with iCal, but that’s the opposite direction of how I would like to sync. I signed up with Zaphier in the hopes that that would help, but I just get continuous error messages. I am currently working with my producer and we have a shared iCal calendar, so I need to be able to integrate it into AirTable so we can see all of our upcomings events. Thanks for the help, Christi

I am brand new today, I am trying to import an entire large spreadsheet from Google sheets with Tabs. I have added my google account and I am prompted to sign in to google, then it won’t let me and says error. Help

I have a table with a column that links to another record. This column allows linking multiple records. Is it possible to create a form where people can select records and add a comment on them? I want to be able to link a record with a comment.

Hi Airtable Community! I’d love to create an automation from Table A, so that when I click “Send Invoice,” it will update all the records of Table B by changing the “Sent Invoice to Client” from “No” to “Yes”. I believe I’m stuck because I’m trying to pull a string of Record IDs from Table A’s lookup field and then update the Record IDs as individual rows in Table B. Is there a way to do this? Thanks so much for all your help!!! Cameron!!! Screen Shot 2021-02-12 at 3.06.51 PM|700x283

Now that I’m on a Pro plan with more tools available to me, I’m trying to eliminate a spreadsheet from my workflow because all the data in it stems from AT. Surely, AT must have the ability to summarize all of this for me. I have a table in my base where I track what I’m working on each day. I can have multiple records with the same date. I then use views to get a summary for a specific date or for a whole month. I can see my total earnings and time worked for that view at the bottom. Is there a way to link to those numbers in another table so that I can then use those numbers to do some calculations? The only way I’ve figured out how to get to what I want to do is a combo of a linked field and a roll-up, but the linked field can have dozens of records I have to add manually, so I could miss one. It would be so much easier if that record field could immediately link to the summary of a view in another table.

Hi - I’ve created a shared view of a table but it doesn’t seem like the shared view gives access to linked field data (linking to another table in the base). I suppose this makes sense. Is there a setting I can use to change that?