Other Questions

Hi, I’m super new to using formulas. I’d like to do an IF formula for my “Published date” column with the “assigned week” column. So if the dates are less than 2 weeks time it will get “first two weeks” if its more than two weeks it will get the “last two weeks”. My formula: IF({Published date}) < 14, “first two weeks”) ,IF({Published date}) > 14,“last two weeks”) Please advised… Thanks in advance!

I am working on a script that creates a record based on the user input. I am struggling to get a document upload to save with the newly created record. I read the follow thread: How to creat a record while using input.fileAsync Scripting app My question as below: I use this script: Let attachment = await input.fileAsync('Pls upload the cargo packing list') Then I want to create a new record with one field as MultipleAttachment. I want this MultipleAttachment field having the attachment input above by input.fileAsync. As per the API, the MultipleAttachment written format as below: Array<{ url: string, filename?: string, }> How could I achieve my goal? I don’t know how can I have the url of the uploaded file by fileAsync. … and was curious if a solution for this has been created yet. Is there a way to programmatically host this file through airtable without bringing in another storage service? I am attempting to create some automations

Hey guys, I have a weather station that logs data to an Airtable every 5 minutes. I can easily access daily summaries if I group the records by date/day, but I cannot use them for anything. So, as suggested in this forum, I created another table to act as “pivot”, linked records by date/day, and then used rollups to get minimum, maximum, and averages. What I would like to do is have this system update automatically. I’ve tried to update the linked field, both using the logger (a POST curl) or airtable automations, but it remains unchanged. Is another way to do this? Thank you

Hi there, total newbie here… So I am working on airtable via a different org as a collaborator and I really like it so I want to install it for my own company, this company has many subdivisions providing same service but from different domains. So I have 2 questions. I want to be able to continue to work on my original collab org and my oiwn company airtable at the same time. The data is not related so those airtables do not need to be connected in any way, I just want to be able to log in in both organisations but with different logins at the same time from the same browser. Is this possible? As our company has different divisions, we organise our contacts with a field that defines the division by domain. Now if we want to notify a contact in our airtable is there a way to link this to the domain of the division so it looks like the person generating the notification for a division A send this from a division A email whilst B contact sees this as a division B email? Thanks in a

Hi, friends! Okay, I am setting up a group of databases for a client on Airtable. I love it but I am having issues connecting all of them to one another. The app we are building is meant for users to be able to book private charters. There is an additional functionality that will allow the user to submit a route request and then be notified when there is a flight that matches their criteria - ie from Denver, CO to Aspen, CO. So, I have 4 databases. The airport codes. Each city has multiple airport codes associated with it. For example, there are 3 airports associated with “Denver, CO”. The flights. This info flows through directly from admin adding the flights in our app. Notification requests. This info flows through directly from users submitting a request in the app. Users. With all of the user info. Any idea how to connect multiple databases to one specific column? In addition, is there a way to populate when a flight is added from a certain airport that falls under the c

I’m looking to use Airtable as a database for my website that is a marketplace. My website allows neighbors to share referrals with one another. First, I don’t like the design limitations of the “embed view” option…is there an app that you suggest within the AT marketplace that will allow for more customization for both mobile and desktpop? Secondly, and more importantly, I need googlebots to crawl my pages with the referrals on them…and embedding an iframe isn’t going to help me from an seo standpoint. Is there a AT app or work-around solution for people needing the data to be published in a text readable format? Thank you in advance for your help! And I apologize if this question has already been addressed and I didn’t see it in the archives.

I’ve been banging my head here for a bit and ready to give up. I am trying to get Page designer PDF output and copy paste it into a word document. I only want three text fields. Name, Title, Description. The output from PDF has a variety of problems if copy past to a new document. All kinds of corrupted characters, combos of “fi” appear to be vectors, not text. So all kinds of words have issues. Dan Gri􀂣ths , 􀂡lled Line Breaks throughout the Description text block. Should be clean text. I tried galley with an embed to see if I could copy/paste html from the embed but the Desctiption field is truncated. I can’t figure this out, is there any way I can get clean output other than CSV. So far the best result is to export PDF, then convert PDF to Word using an online service. This fixes the line breaks but still have corrupted characters and bookmarks. Open new word in Google docs, copy into notepad ++ and back to clean up a bunch of other stuff and I’m finally at clean text

I have created a large database. It has 46 rows and 15 columns. I attempted to download this base as an Excel worksheet. First, I downloaded it as a .CSV file. Then I saved it as an Excel sheet, but the result was very poor. All the rows and columns were out of whack. This does not happen to me with smaller bases, like those with 5 columns. The 5-column bases download neatly as Excel sheets. Why does this not happen this larger base and how can I fix it?

Hello! I need to import xml feed to my airtable, is there any way in which I can do this? The xml feed is in here: https://feed.omegacommerce.com/f/hnc01/feed.xml

Is it possible to use more than a single logical operator for filtering results? So far, I see there is only the option to filter based on the AND logical operator or the OR logical operator. Is it possible to combine these? For example: WHERE (“Status” contains “active” AND “Due Date” is within “1 month”) OR (“Status” contains “started” AND “Due Date” is “empty”) Otherwise, I need two separate filters and cannot see projects side-by-side easily.

Hello Airtable community. I am a designer whose brain is hurting after struggling to get a decent grip on building dynamic databases in Airtable. I have a lot of questions, maybe you have some of the answers? This is my Airtable: Airtable - Hodebra aktiviteter Q1: How can I make sure that any tasks that are marked complete (logget in Norwegian), are reset to incomplete every night (Ikke logget in Norwegian). I have tried to schedule automation, but I can’t find out how to describe the record ID, when using “changing a record” as action. I would like to change ALL the records that has been completed back to incomplete. Q2: How can I summarize the values in a specific field (Score aktivitet) based on the field “Device.ID” In other words, how can I calculate how many points the user (Device.ID) has in “Score akivitet”, “Score sammen” and “Score meningsfylt”? Q3: How can I track which task is most completed? In my Airtable, I have several views. The first view “Alle aktiviteter” should onl

I have imported a database from CSV to airtable and all the links are broken. is there a way to fix this?

I’m trying to find a way to visualize data across multiple tables in a Flow Chart or Org Chart type view. Imagine one table is a list of projects, and a second table is a list of teams, and lastly a list of people. People belong to a team, and a team is assigned a project. I wanted to create a view that lists the projects, and then draws lines to the teams assigned to each project and then for each team draws a line to each member of the team. From what I can tell the flowchart and org chart apps only work from one self-linking table. Is there anyway to do this on airtable?

Has anyone made sync tables available to all? Like ‘calendars of interest’ in Google Calendar. All sorts of reference data could be pulled into an Airtable base via sync instead of maintaining locally. I haven’t come across any platform or marketplace to browse such tables. Are there any? I guess individual providers could make their own tables available if they chose to. Are there any? I’m sure someone has already thought about all this.

I am having trouble using the fill handle to copy data quickly into a set of cells. (Fill handle - the little crosshairs you get when you select a cell, that allows you to be able to copy from one cell to another by simply dragging - see support article here) I’m not trying to get it to do series copying, where it continues a series or sequence. I would just like to copy the identical data from one cell to several others that are adjacent. I have done this many times in my Airtable work and suddenly it doesn’t appear to want to select multiple cells, let alone use the fill handle to copy. Stranger: In one base it’s working fine, but in another base it won’t work at all, in any of the tables - I drag from the corner and nothing happens. My permissions on these bases are the same. I saw one other post about this but it was closed without being solved. Thanks for any ideas to try.

I hope the topic doesn’t seem too confusing… if it is, I apologize for that :grinning_face_with_sweat: So I’m making a database for a pet store, the tables are: Customers table: it contains contact information of the customers (name, tel, email, etc.) Pets table: it contains pet info, 1 attribute called “Owner” linked to the Customers table Now I’m building an Appointment table, which has two linked attributes: Customer: links to Customer table and show the who is the person that book this appointment Pet: shows the pets who are taking the service. I would like make a “filter” for the Pet attribute so that only the pets that belong to the customer I already selected would be able to be selected For example, if I selected a customer ABC, and he/she has two pets, when I select the records for “Pet” attribute, I’d like to only see the two pets he/she has rather than every pet in the Pet table. I used to create SQL-based database and would make a query to fulfill this “filter” funct

Hi, i need your help I’m in the middle of a project and I need to track when the status of each record was modify in order to track the time between phases. I have a column in which i track the status of each sub-project (Received, Processing, Ready) and i will like to analyze the average time is taking me on each of the phases. In the activity panel of each sub-project, i can see how many day ago was change each category, is there any way to transform that data to several independent cells? For example: Column 1 → Status Change to Received: 02/10/2021 10:30am Column 2 ->Status Change to Processing: 02/10/2021 10:40am Column 3 ->Status Change to Ready: 02/11/2021 9:00am With this data i will be able to see how efficient i am at my work and will allow me to improve Many thanks for your help

We are shifting from Salesforce to a much simpler and easier system on Airtable. I need help or a bit of consulting on how to do the following: We have 75 member companies in our small association. I want to have a way to add a member company (with a key contact) Then, let that person add up to 100 or so more contacts - with a password or unique url. And, let the key contact look at their list of contacts - at any time - and add or delete names. Can someone point me to resources to help?

I am trying to send a message in Slack after an Event is created (new event in Google Calendar). There is no clear way to change the timezone format, as the default looks like that: “2021-03-02T17:00:00.000Z” Two questions here: 1 - is it possible to add a separator between Date AND time? 2 - is it possible to change the time zone as it looks like the default is GMT+0

I currently have a Client Database which stores client info and automates scheduling. What I would like to do is create a Client History which would store past appointments, how much clients spent, how much they tipped etc. I’m thinking the way to do it would be to create a separate synced database which would use Their Appt Date/Time at the Primary field. So then when I confirm an appt with a client on the CLIENT base, Airtable creates a new record in the HISTORY base, and this new History Record is associated with the client. Does that seem like a sensible way to do this?

I am trying to import a Google Sheet containing ~500 rows of data into Airtable. Airtable successfully detects the data, including the column labels, but after I confirm and press the “Import” button, it always throws this error. How can I fix this?

I have a table where i am capturing 4-5 data points about different members of a household, such as name, age and education. All this is gathered through a single form, so all the data for a household is in a single record. I want to now split this data into multiple records in a different table - so that i can see the name, age and education of each household member one below the other, rather than in the same row. Is it possible to automate this in airtable?

I am using airtable for invoicing for a transportation company, and we bill by mileage. Ultimately, when billing, I want to be able to choose an origin point from a drop down, choose a destination from another drop down, and have airtable fill in the number of miles between the two locations in a third field. I’m a bit of an airtable newbie, so I’m struggling to figure out how to set this all up. My current base is set up as follows: Table containing a record for each item/route to be billed Table for customer information Table for invoices Currently I am typing in the number of miles for each item to be billed. The routes we run have a finite number of origins and destinations, so it feels feasible (if a little arduous) to calculate up how many miles there are between each origin and each possible destination and store them in a table. I’m just not sure how to set that table up and how to connect it to my first table, especially by being able to select the origin/destination via dropd

I’m experimenting to see if I can make API calls to AirTable from the Swift programming language. I’m able to get the table fields, but I also want to update a field. That isn’t working. Are there examples anywhere?

I’m not sure if I’m missing something, or if it’s even possible. When I Import a CSV file. I would like to have it add to one of my columns that has a Multiple Select column type. So, for instance, if I have a Multiple Select column with the following fields: apples oranges peaches and in one of my rows the column it has: apples oranges and then i import the CSV, and the import has peaches the result would be that it would add peaches to the column. at the moment, it over rights the column. at least in my experiences. thanks for any advice. hope i put this question in the correct section.