Other Questions

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

Hi Airtable Community, I am working on a table and I would like for the first column to be sorted in alphabetical order (A --> Z), but when I do this the whole column erases. However, when I do (Z --> A) it does work. Could you please help me out but telling me how to sort the column (A --> Z)? Additionally, Is there any way I can have two different field types applied to the same column? For example, if I want to have both long text and multi-select on the same column and be able to pick which field type I want to use for each cell of that specific column. I would highly appreciate your help and I am looking forward to hearing back from you soon! Thank you, Yael

Hello! I am trying to add in a picture (or a link to an attachment) to a SendGrid email template. I have created a field for the URL of the Attachment, and added the img tag in the SendGrid email template, as I saw in another email on this topic, but, when I test the email, the image appears as “broken.” Am I missing something?

We are an educational institute and we were given a 50% discount but we can’t redeem this dicount before January 15th 2021. This offer is available until December 22th, 2020. Can we apply again for the 50% off offer after the 30 days are up? Best regards.

Hey yo I have a simple use case, I have an airtable form receiving submissions. I can see the submissions in grid view in the same table. But now I want to make changes to those submissions without changing the original submissions. How do I do that? What I tried, Creating sync table in the same base, but that doesn’t seem to be an option. Help appreciated.

Hi, I have a google sheet set up to keep an updated list of stock prices that updates hourly, I would like to connect the recent price column to a column on my airtable. I somehow managed to do this with one stock only on Zapier, but another user deleted the column and I was unable to replicate what I did. I am happy to use any method, but to date cannot do it. Any suggestions? Jill

Hi All, I’m trying to find a way to sync selected records from within a table to a table in a base I share with a client. The client only needs to see the records I select. How do I set it up so only those records are synced to the client’s shared base?

Hey! I’m trying to connect data from different bases into one, and that data from the different bases have it summed up. So what I’m trying to do is these: I have a different base for each soccer tournament in which contains the stats of every player, and I want to have in the SAME base the stats of that same player in the different tournaments like: Have “Lionel Messi” stats from 2018 season + 2019 season + 2020 season, etc in just one record… and add all the stats in one base. My idea is to have a general base with a few stats but from ALL tournaments (bases). I know I can sync bases but there’s a limit of 20 synced bases and I have more than 20. What do you guys suggest me? Hope you can help me! Thanks! Sum data from different bases into one

Hello, we are trying to compile the numbers of calls received per week on a spreadsheet. We would like a break down by day, week and Month. Should we use pivot table or scripting? What should be the configuration? Thank you

I’m new to Airtable (and databases generally) so I apologize that I can’t articulate my problem better than this. But here goes: Through Zapier, every day I send an Airtable form to my clients. When they complete the form, a new record appears in the base. So far so good. Ideally, they would complete the form every day of the week so there would be one record per client per day. But they sometimes forget… Is there a way to automatically create a blank record (with null values) for the days when they forget to complete the form? I need to track these no-response days and don’t want to create the records with null values manually. I’ll be (extremely) grateful for any help. -Jason

New user with just a basic (not Pro) plan. After “Submit” form, no record ever gets added. Also, the “Email Me” does not seem to work. Please help!

Hi, I’m trying to make a formula that gives me the last day of the current month. So, while we’re in March I want it to return 31 or 2018-03-31 and when we get to April return 30 or 2018-04-30. It seems pretty simple in JS (https://stackoverflow.com/questions/1184334/get-number-days-in-a-specified-month-using-javascript) - but don’t know how to do it on Airtable. Any ideas? Thanks a lot! Best Sune

Hello, I have spent the last two days looking through the community post and can’t seem to find an answer to the solution I need. My best bet is that I either need a nested if statement or a possible Switch command. I am trying to create a formula that gives me the status on a row based on blank rows in a column. For example, I have a workflow that is an eight-step process. My goal was to create a column for each step. The steps are (Get approval, Get Quote, Make Purchase Request, Print Purchase Order, Receive Items, Tag Items, Install Items, Update Asset information) As each step is completed I will fill information in that column. I would like the formula to let me know which step we are on next. If there is no data on the row the formula will state that we are “Waiting on the approval.” If I type something in the first column, the formula will know that column is no longer blank and provide the next step. (Waiting on Quote, Enter PR, Upload PO, Waiting on delivery, Tag items, Insta

I am using Zapier to send an email using a webhook. The email has an attachment (picture or PDF, can be either at time or both). when the email sends, it only grabs the URL for the attachment. i want the actual FILE. i know that if i use the UI inside of ZAP > OULOOK, i can call the FILE out and it inserts it properly… but i want this occur while using the webhook… anyone know the TAG i can use in the webhook pre-fill link to pull the FILE and not just the URL?

This is my first post to the community, so please be patient if I haven’t gotten this formatted right on the first go. Also please be patient if I don’t provide enough info right off. I can update as necessary :slightly_smiling_face: Also please not that due to project limitations I am unable to use Node.JS, so I am prepping all my queries “manually” and sending them out via XMLHttpRequest(); once I have them built. I am also not using any other frameworks or services like Adalo or anything. I am working on a small web app using Airtable, and I’ve come across a couple oddities when getting records. I’ve tried searching for info on this but haven’t had much luck. 1: When i send a request like this: https://api.airtable.com/v0/[BASE ID]/Studies?maxRecords=5 I get back five records, but my expectation would be to get either the first five records or the last five records of the table. Instead I get what seem like five arbitrary records. The table I’m testing with has records with a Uniq

Hi All! Been thinking about this for a while, but cannot wrap my head around it! Looking for a bit of help. I have multiple tables with lots of lookups all connected together, but am struggling to get a same table lookup to work. Thinking maybe scripts or automations? My table is as below: I am trying to accomplish the following: When the current row is updated to ‘Existing Supply Rating’ it (ie the automagical widget or script) searches for similar rows and returns the file associated with the most recent similar matching row. It then copies the URL of the file into this record. Kind of a fuzzy search which then returns and inserts a file for my current row. if ({Existing Supply Rating}=True) return Attachment into this ‘cell’ where {Site Type} = this {site type} and {in/Out} = this {In/Out} and {Proposed Config} = this {Proposed Config} and {Existing Supply Location} = this {Existing Supply Location} and {Existing Mains Supply} = this {Existing Mains Supply} and {Existing Supply Rat

Hello! I’m looking for some advice as to how to recreate some of the timesheet functionality that I currently get from Harvest within Airtable, considering my Airtable base has a lot of the data about our projects that I end up entering manually into Harvest. Right now, our Harvest usage looks like this: The records are “tagged” with the project, and the task that the time was spent on for that project. I have the projects and tasks already in tables in my base, and the only way that I can see to set this up is like this. Is this the only way to recreate the Harvest functionality in Airtable? What do you recommend I do differently?

Hi everyone, I would like to ask you for help: I have the MAIN database and then couple others (A,B,C…) in tables next to it. To fill in new records within a particular a field of MAIN, I was choosing informaton from the database A. These were linked, such that I started typing a new record in MAIN and it automatically showed me options from database A and I chose a desired option. Then I copied the whole database and this link has been lost and I do not know how to restore it. I would really appreciate your suggestions! Thank you very much. Margareta