Other Questions

Hi! I have a Lookup column that gets one or more images from another table. Now I need to get each image link in its own column. I already have the formula to extract the images URLs, but how do I get each of the URLs in a separated column? Thanks!

I use Evernote for daily notes of all activities for each week in one daily note. I use an Evernote template each week to start the process for the week and include various URL links to outside programs (i.e., Google Drive files, etc.) that I use regularly. I want to create a URL link in my Evernote template to link back to an Airtable base for call logging. I cannot determine a method to find or create a link for a specific Airtable base that I would paste in the Evernote template for regular use. Any ideas or best past practices? Thanks in advance for your help.

Hi, I am wondering if there is any way to display a single record with multiple dates in the calendar view? In the calendar view it says I can’t so is there any separate app or work around for this? What we’re trying to do is create a delivery schedule where our sales team will fill out a form which they put in date, name and select a delivery slot. For large jobs, they can select multiple delivery slots so that the delivery team is not overbooked on a certain date. But when they select multiple delivery slots, these count as a record with multiple dates so they don’t display. I checked other threads however they’re quite old now and wasn’t able to figure out a solution. Thanks!

I’m trying to figure out whether this is going to be possible, and would appreciate any pointers. I’ve been asked to set up a system to book fittings for protective equipment (COVID related). There are three constraints: Each booking slot is 30 minutes between 11am-5pm M-S (there is a definitive start and end date) Each booking slot can book access to one or more pieces of equipment (there are 180 individually numbered items in total). Once a piece of equipment has been booked it isn’t available to anyone else that day (they are re-sanitized at 5pm). Ideally the respondents would select the equipment they need, then be presented with dates where all of the selected equipment is available. I’ve seen a number of guides on creating simple booking systems using Airtable, but can’t quite wrap my head around how I could adapt these for use.

Hi! I’m trying to make a sign-up form for booking 3 different classes with 3 sessions each. So Airtable would have 9 sessions and 3 classes. The form would have 2 fields: the class and the session. The “class” (linked field) would be prefilled on the form based on the link it came from. But how can I make only the relevant sessions come up as options? In more detail: Class A: Session 1, Session 2, Session 3 Class B: Session 4, Session 5, Session 6 Class C: Session 7, Session 8, Session 9 If Class A is selected, is there any way to filter the options such that only Session 1, Session 2, and Session 3 show up? Maybe another linked field or multiple choice field would be best, though I’m not sure how to do that. Looking for a way to do this without making a view per class. My ideal would be to just have one multi-purpose form that I can prefill. Thank you very much!!

I’m trying to get a stock quote script to work for me. I’m not someone that understands scripts, but I think I have it right. Although something is wrong and not sure what. The API is from financialmodelingprep.com/developer/docs/, which I found mentioned in this forum. When I run it I get this result: Blockquote Updating stock prices Updating price of aapl… Can’t update the price of stock with no name Can’t update the price of stock with no name aapl’s price right now is: $undefined Done! Here is the script I have, with the field names changed to my field names (Symbol, Price, Price Date) (Sorry for the way the code looks below, not sure how to paste in code) output.markdown ("# Updating stock prices"); let table = base.getTable (“Holdings”), records = await table.selectRecordsAsync (); await Promise.all ( records.records.map (async record => { let stock = record.getCellValue ("Symbol"); if (! stock) { output.text ("Can't update the price of stock with no nam

Hi, All the way from Australia, and I’m newish to Airtable and will probably have 100+ questions. My first one is, can I calculate how many days there are from column B e.g. Column A is the date a property was loaded online column B is how many days a property has been online… any help would be appreciated. Thank you Sarah

Hi. I have a daily activity table, which I populate via a form (health tracker). I have several views against this table which show certain types of activity filtered for the last week - which I then use an email automation to send back targeted messages. All works great. However, I don’t know how to respond to inactivity. So if I don’t populate the form for a week (and therefore the table doesn’t have any entries for the last X days, how can I detect this (so that I can automate an email to remind the user to populate it again). Is there something with a max created timestamp, and then a logic check against this? Email automation is focused on a record being created or updated - I can’t think how to automate based on the absence of rows. Hope this makes sense - trying to prove this on my basic plan (for my MVP) before committing to a paid plan. Many thanks for any assistance.

How do I remove collaborators who are grayed out and seem to “come with” a template base? There are a couple templates I am trying to use but extra collaborators cannot be removed. I tried right clicking, I tried left clicking, I tried every other possibility that works in other bases and cannot remove the grayed out collaborators. Any suggestions? Thank you in advance!

I am trying to create a room Scheduling database. I want to be able to list the rooms on the left and have the calendar dates across the top. Please see the attachment for and example of what I am trying to create. Does AirTable do this? Please help. I

Hi all - somewhat daunted by the capabilities here … and so asking if someone can point me in the right direction. My base table is straightforward - just a list of calendar events, grouped into courses. What I want to do though is have something which allows me to populate new groups of events into that table based on some predefined rules associated with each course. For instance, if I were to setup a new course of type X, that might lead to three events being created in the table at +7, +21 +28 days from the start date of the course. Type Y might only have one event at +21 days from the start date etc. There are only a a small number of course types (<10) so needn’t be too complex. However, there are a lot of instances of courses being created. Any advice? Thanks in advance.

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: