Other Questions

The Timeline App is still broken – no response here: Timeline Block and Record Stacking Apps Didn’t records in a Timeline block used to stack to avoid overlapping like this?

I’m very new to airtable and trying to do what I imagine should be simple. I just want 7 rows with dates, starting with today, going forward 7 days. I want these rows to update every day so that I don’t have to do it manually. I’d like to be able to do something similar with hours of the day, showing the current hour of the day and listing the next 8 hours in each row. How can I accomplish this?

Hi Airtable Community, For a payroll automation base I’m developing, I need to figure out how to set a payroll date which will be 30 days after the first of the next month or the first of 2 months out, depending on net terms. For example, if someone logs time worked on 11/15/2020, and their payment terms are Net 30, the payment would be due to them by figuring out the first day of the next month, (12/1/2020), and adding 30 days which would be 12/31/2020. If someone logs time worked on 11/15/2020, and their payment terms are Net 60, the payment would be due to them by figuring out the first day of the next month, (12/1/2020), and adding 60 days which would be 1/30/2021 (or so I think). I’m trying to automate this calculation if possible. I’ve set up multiple calculation fields to take the number of the month, add 1, adjust if it’s past December. But then I have to address the year as well. So I wondered if there might be some kind of date formula to hel

I have 2 rows in table A, each with a URL. I am linking them to one row in table B, then making a page builder app off Table B to aggregate the URLs into one nifty PDF. However, the links are not clickable on page builder. Is there a way to solve this?

Hello Airtable Community, I have never used Airtable and I am evaluating it to determine if it would meet my needs. I am looking to build a web app (using a no code tool) and am trying to determine the best backend to use. I am planning to build a social networking app. By its very nature, the hope is to gain a huge number of users on the app. The part I am a bit unclear about with regards the pricing structure of Airtable is that, will one license suffice for such a social networking app that would have many users? Or would Airtable require billing for every user? If one user license for the app would suffice, how can someone implement user level permissions, user logins and signups using Airtable? Also, is there a potential downside that Airtable could start to slow down as huge amounts of records (posts) are saved to Airtable? I would appreciate any guidance on my above questions. Thanks!

Just got a notification from Google Drive informing me that if your account is inactive for 2 years, all your data in Drive will be deleted. I’m wondering and haven’t been able to find the answer anywhere, is there anything similar with Airtable? Is my data stored forever, or will Airtable ever delete it, if it’s up there long enough?

Disclaimer: I have a basic understanding of Airtable. We created a database with a shareable link. We downloaded the descriptions app, but I can’t figure out how to get the description to show up in the shared view. Same goes for any other app. Can someone explain how to do this?

Are you looking for some free-to-use photos for inspiration? Here’s a recipe using CSS selectors to automatically grab an image from Unsplash, along with the page URL, photographer name, photographer handle, specified image location, and image description. In your target base/table, you’ll need to have the following fields (or you can make a copy of this base) Link (URL field) Image (attachment field) Photographer name (single line text field) Photographer handle (single line text field) Location (single line text field) Description (long text field) And here’s the snippet you can import: "schemaVersion": 3, "fieldMappings":

I recently add Airtable Matrix App. Looks really awesome. Can I print it? Or export it as xlsx / pdf / others? Can’t seem to find the button. Thanks

Is it possible? I need the timestamp feature that I can record the current time just with one or two click(s) but still can be modified manullay. I use ‘date’ field for this purpose but it displays date that I dont’t need. Duration field shows only time but it does not support one-click current time insertion. The only work-around I found is Column A: date field: 2020/12/15 17:56 Column B: formula filed: DATETIME_FORMAT(‘Column A’, ‘hh:mm’) There are two problems. I have to use two columns to show only one field Column B has a timezone issue. (I live in UTC+9 area. The column A has a local time but column B shows UTC time. So A is 2020/12/15 17:56, but B is 08:56 Thanks.

Does anyone know why they got rid of reverse order toggle for linked records and what an alternative could be? https://support.airtable.com/hc/en-us/articles/217521267-Reordering-record-links

Hello All, As someone who knows nothing about JavaScript, I am trying to write a script that creates a one-to-many link between two tables. I found some code elsewhere on the forum and have modified it slightly. I have a “Facilities” table that lists out each facility from which we will be collecting data. I also have a “Results” table that has the results from all data collection at every facility. (This table is quite large and new records are added everyday.) The common link between these two tables is the Facility ID. I would like each Facility to have all their results linked (one-to-many relationship) in the “Facilities” table. Currently, I am able to run the following code and return a one-to-one link. I’m assuming that the output gets rewritten each times it goes through the FOR loop, resulting in only one output. Is there a way to modify the code to have it output multiple links instead of just one? Here is the code that I am using:

Hi! I’m new to airtable and I’m trying to transfer all of my databases over to this platform from access. One thing that I’ve really liked about access forms is that I can have the form value appear to the inputer as “yes” or “no”, or some other wording input like that, and then in the backend what gets filled into my database for “yes” would be something like 1, while “no” would be 0. So essentially what I’m wondering is with airtable forms is there a way that I can have these options on the front end but then have specified values filed into my table based on what the user chooses? Thanks!

I’m wondering if this scenario is possible - I cant seem to figure it out… Table(A) includes generic contact data: Email(Primary), Name, Phone#, Address, etc. Table(B) captures an event as a record. The use case I’m hoping to figure out is how to link Table(A) into Table(B) by populating either the Email OR Name. I’m familiar with the Lookup field, however, my understanding is that it can only be populated via field data pulled by the Primary Link(Email). I tried creating a 3rd table to link Name to Email but was ultimately unsuccessful in getting Table(A) to capture the record in Table(B). Any advice/suggestions? Thanks in advance.

Hello, we are entering a new phase of business. We operate an uber like business. We have a list of outer UK postcodes, with sub regions etc. We have around 400 companies / partners. We need to allow partners to sign up, and select the postcodes that they operate in, as well as define their prices for 3 services in these areas. Then I want to be able: a) to lookup a postcode and service and see who offers the lowest price service for that area b) to see all the carriers that operate in that area, this would be to distribute

Thought this was a no brainer, create 3 different views & lock them down. Example: 3 different yearbooks, one of three views applies to each yearbook. However, when I edit one it affects all of the views. Need to show only student pages that are related to each yearbook. In the lookup field, I pick a field to filter by and it works for one yearbook. But when I edit a second view (second yearbook) it changes the first view (first yearbook) to reflect the second view.

As in, businesses X, Y, Z each have separate cards in my CRM, but are also owned by Alphabet (and this relationship is visible when I open my Account card for X or Y etc) Thanks a/Community!

Is there a way to add a hyperlink in a Form? I’m creating a form to give donors multiple options to donate online. I’d like them to be able to select an option in the form (not the message page after the form is submitted) that links to a specific PayPal donation page based on their selection. Is there a way to do this? Thanks, Dave

Hello! I am trying to use Zapier, to take information gathered from an AirTable form to create an outbound text message. I have everything working except for the use of the date / time in the outbound text due to the Airtable format of date time (2020-12-17T06:00:00.00). Is there a way to change the outbound formatting of the date time to something more legible? Thanks in advance, Jackson

hi all i make apps with java html and on airtable,it and kodular… I’m a starter I have one project hardly … is there any way u guys can help me with basic… after completing basic ill then learn advanced and how to implement them… thanks if u help

Hello objective: Fill a table with forms using iPhone or Android phone. Problem: 10 PHOTOS To insert = 10 times selecting a photo from the gallery. Do you have a solution, to select 10 photos in one time in the gallery, to insert them at once in the form.?

Hello, I’m trying to figure out what size I should be setting my document to. I was trying to create a canvas with the intended size: 8.127 x 10.253 in. When converting this to pixels at 300dpi in photoshop, I show 2438 x 3076 but when I entered this into the page designer app and exported, my document was something like 24 inches wide (3x the size). Please help!

Hello everyone :wave: In this post, we show how to store realtime messages straight into Airtable in the exact order they were originally published from anywhere on the globe, all thanks to Ably and Webhooks. Using Airtable as a database to store realtime messages :file_cabinet: Hope you like it, feedback is always welcomed :v:

Hi Folks, Brand new Airtable user here. I am using the sample template: Social Media Planning + Design but for the life of me I cannot figure out how to add a new record. See the attached screen shot. I would like to add a 4th and 5th and more records to the Table but so far I can’t figure it out.

Hi all, I am trying to get a similar sidebar menu as shown in the attached image (I got this example from ‘Universe’), can anyone tell me how to create a similar display? Thanks