Other Questions

Does anyone know how to save multiple documents into a single attachment field in Airtable. My experience has been that when you insert a document, you can only do one at a time. And if you update the attachment field, it will overwrite the existing document. Any suggestions?

Hi there, I have already asked the same question here, only the question was wrong: I have to start from decimals. I don’t find any documentation on how to accomplish this anywhere. I am not an expert in this either. So here’s the question: I have records that contain time formats in decimals, eg: 0.50 (= 30 minutes), 8.00 (= 8 hours) etc. This is a formula field. For a partner I have to convert this to the following format: 1.00 -> 0100 8.00 -> 0800 0.50 -> 0050 0.12 -> 0012 etc. So 4 digits of which the first is a ‘0’. There should be no point in between. Can anyone help me with this? Thanks for your help! Erwin

Is there a possibility to make some fields editable by unsigned users (guests)? I want to make a wishlist of gifts and let people select which ones they will buy by changing the status of an entry to something like “Taken”. But I think it will be too much to ask people to sign up to airtable just to select one checkbox in the table. Unfortunately in “Edit field permission” there is no such possibility. Are there other ways to do it?

How do I format a field to geographic address? The dropdown does not provide me with that option. Sorry if this is a dumb question, I am new to airtable

I’m trying to find a way to add an appointment request form that is HIPAA compliant… the Form Block feature is not. Does anyone know of any third party integrations I could use that would satisfy this need? Thanks in advance.

Hello all, I’m having problems with the following search formula in integromat: {field_name}=“value” In this particular case, {field_name} is a formula field. I’ve checked the values, and the naming, and everything is correct. So I can only surmise that you can’t run a search against a formula field? Can anyone help? Drew

Hello all, I am currently in search for a consultant to build out a custom CRM through Airtable for my Real Estate Investment company. I am mostly set on and convinced with Airtable at this time for what I am needing and looking for in my business. The CRM will need to include several of my systems to be linked and connected with an API to the CRM for the capability of operating with my team almost entirely out of our CRM. Additionally, I am in search for someone that I can do business with long term on other parts of my business that needs attention as well. I am willing to pay for all work done on this project along with other projects to come. I would first like to discuss with you directly in more detail about my business and what I am looking for. I will prefer to see any prior work you have done on any CRMs in Airtable, and any work that you may have done with building a CRM for Real Estate before beginning on my project. You can contact me by email at tw@winnco.net and let me kn

Hi! I’m new to airtable and trying to use it to do some menu planning. Here’s what I have so far! https://airtable.com/invite/l?inviteId=invN8vHUKqsBc8OUu&inviteToken=cb4825266bf6ec64751c488bc8518294da66f8708064c3e58cb54bbd01889143 I have a table of Meals, which is going to be my list of all possible meals I like to have in rotation. I have a table for Ingredients, which is stuff I use to make meals. Meals have many ingredients, ingredients can belong to many meals. Ingredients also are linked to specific Grocery Stores where I like to buy those ingredients. I have a table for Grocery Stores. And last, I have a table for ‘this week’ (here Week 39), where I select WHICH meals to have this week. Here’s a screenshot of those: What I would LIKE TO do is to query this somehow to create a report that shows: for the meals selected in Week 39, list all the ingredients needed and for bonus points, sort that list by Grocery stores where I get that ingredient. Can you help me think thro

How do I remove the timestamp from this? IF({Appt Date},DATEADD({Appt Date},-2,‘days’), BLANK())

Our client secret stops working… Now it’s returning us this below data, which is effecting the Airtable users not able to authenticate their app on Appy Pie Connect. { “error”: { “type”: “NOT_FOUND” } }

Good morning everyone, I have a database of vegetables I purchased from several producers for my retail business. The database is structured as follow: one vegetable (table 1) is being procured at a price (table 2) in a specific order (table 3) from specific producer (table 4). I would need to get the past average cost of each vegetable for each producer, sth like an averageif (unit cost, past dates, producer A) To my understanding, only scripting can do that. And Im new to it. What script should I write ? Many thanks to everyone :)))) Good day !

There are two fields: 1. Category - Fruits, Vegetables. 2. Sub-Category - Apple, Mango, Potato, Onion. If I select Fruits then I should be able to see only Apple and Mango in next dropdown menu and if I select Vegetables then I should able to see only Potato and Onion in the next dropdown menu.

Hi all, I’m working on a project to build WiseCabin. I am manually adding tweets (the author name, the tweet text content, the images, etc) to airtable. We’ll be building the website on Webflow and so far I only know to add the content manually into Webflow CMS. This is obviously a very time consuming process. So perhaps my question is two fold. Is there a way I can basically grab all the contents on a embedded tweet (and its connected tweets) into Airtable, and then export the content into webflow CMS? We cannot use the embedded tweets because we will have to create our own formatting to display the tweets more akin to a Reddit list format. Thanks!

Hello My Awesome Community, I am wondering if I can grab Data from a live website like “IMDB”, I have the title Name " Movie" or “Series”, and I want the script when I run it to go surfing the IMDB database and search for certain data like Director Name, Production Year, Cast, winning nominations, Is there such a way or a script to apply that. I was thinking something like Fetch function or keywords Parser, I define some keywords and it garbs whatever after these words and sends them in specific fields in Airtable. Waiting for suggestions guys, Thank you. :pray:

Hello all, great to be on here, am loving the power of Airtable!! Is there a way to do the following : In a table, I have a “Single Select” Field with 5 Options, “Pitch 1” “Pitch 2” “Pitch 3” “Pitch 4” “Pitch 5” If I create a new record, the first field is a Date field, so I select a day, eg 11/01/2020 I then want to assign a “Pitch” from the “Single Select Field”, initially all 5 pitches are available to choose from. I select “Pitch 1” for this record. Record Complete. If I then create another record with the same date, there should now only be Pitches 2-5 available to choose from. i.e. the database has looked at this date and knows “Pitch 1” is used on this date so the single select will only show you the remaining Pitch options (Pitches 2-5) ? Does that make sense? I hope Im explaining it reasonably! Many thanks in advance for any info! Cheers Jon

Hey - I would love to figure out a way to use the Kanban view to show if two or more records are incompatible. I’m using the Kanban to display different categories of concrete ingredients that can lower the carbon content/climate impact of concrete mixes. Each ingredient has its own tile. Some of these ingredients can be combined, others cannot. Wondering with conditional logic if a special kanban column can be added where different ingredient tiles can be dragged, and if one is not compatible with others, all incompatible tiles turn red. Here’s a 40 sec video of me laying this idea out. Any ideas on if this is possible, and if yes, how it could be pulled off would be super helpful and appreciated! Thanks in advance!

Summary: I’m working on a basic sign up process. I’m sending a POST request with the user’s UID to a table called “Sessions” to create a new record. I wish to have a certain value returned if that UID exists on another table called “Users”, and a different value returned if it doesn’t exist. ex: So if I create a new record on “Sessions”, and the UID exists on table “Users”, on column RESULT I will get “User already exists on Users table”, and if it doesn’t exist RESULT will return “This is a new user”. I’m at a loss here at this point. Any ideas?

Hey Everyone: I am trying to set up a Send Summary button for my team so after a meeting it sends out the notes. I am trying to use the Open URL Action but the button stays greyed down and not active even though the button saves properly. URL Formula is this - “mailto:” & ENCODE_URL_COMPONENT({Attendees}) & “?subject=” & ENCODE_URL_COMPONENT(Meeting) & “&body=” & ENCODE_URL_COMPONENT({Meeting Summary})

Is there a way to export the list of billable collaborators a workspace owner can see in workspace settings? I’m looking for a way to pull a csv listing billable collaborators and the bases they have access to, similar to the workspace settings page, just in an external file.

Hello! I am new to Airtable, and I am hoping I can get some assistance. I am in charge of managing hearing lists for a law firm. I am looking for a way to take information from a .csv and list it in a way where you have the date of the hearing and then all of the hearings listed for that day and some additional information. They want it in a list, not in a calendar form. I am trying to figure out a way to automate it by creating a template where all I have to do is import the monthly CSV and run the app and the template auto-generates. Does such a thing exist? I have no problem doing the coding / generating the template (if it is not too complex… I know some basics, but I am by no means a coder), but I have no idea where to start. Thanks you for all of your help in advance!

I’d like to use Airtable to do production / batch / inventory tracking for a manufacturing company. We currently use digital logs (google sheets) to track our raw material intake, bulk production, secondary production, & product packaging. In a perfect world we would like a simple system that take that data and does a couple of things: Track production / packaging output based on batch number, product name, or product type Report on-hand inventory, filterable by product type or name Report production / packaging by date range Pull reports of total production / packaging based on batch ID Pull reports of total production / packaging based on vendor (multiple batch IDs) I looked for some templates that were close, but didn’t find something out there that was easily modifiable. So I guess I’m really looking for someone to build this for me (for pay, of course). Any takers?

Am I going crazy? As of this afternoon, when I double-click on field headers, only the field title goes into edit mode. Until now, double-clicking the field header would open the customize field type modal. If anyone from Airtable HQ is seeing this and this was an intentional decision, PLEASE change it back. It’s killing my workflow when building bases with many, many fields.

Or better yet, a daily report of all the records that were deleted yesterday?

Hello, Me and my friend playing “neighborhood” soccer and we want an automatic mechanism that will build equal teams, based on a score for each player for these stats: Speed, Pass, Shoot, Defense. We are 20 people and we play 5X5, so its 4 teams. Each player will receive a form and he will fill each stat (Pass, Speed, etc) for every player from the group. What do I need to do for creating 4 equal teams based on this score, and how do I create the form to be the most comfortable for filling (I don’t want that every player will fill 19 different forms)? In the end, I want to create 4 equal score teams that will be created automatically :slightly_smiling_face: Thank you!

I use Airtable as a CRM but I need to fill more data of my customers. I want to ask them to fill those fields that are missing using a web form. How can I make it?