Skip to main content

Other Questions

Have other Airtable related questions? Post here!

  • 10,000 Topics
  • 40,679 Replies
10000 Topics
M
Matej_FaganelNew Participant
posted in Other Questions
Kind of Kanban view

Hi, I have a database where there is a column Company and there are rows where companies are repeating. Is it possible to have kind a Kanban view, but when you select the “card” with specific company you can see all data (eg. comments on specific date) on one card and not “endless” cards for one company, each with different comments on specific date… kind of simple CRM tool?

00
M
F
Faculty_SchedulKnown Participant
posted in Other Questions
Shared view URL filters in regular views?

With Shared view URL filters I am able to craft links so that I can basically look at the records dynamically, however I am unable to actually make any changes or edits to the views that I am creating dynamically. Is it correct to say that it isn’t possible to do URL filters with normal views? If so, I wonder why? It would be very useful to be able to create dynamic views where you can actually edit the records. Shared view URL filters for those of you that don’t know what I mean. Airtable Support Shared view URL filters After creating a share for your view you can add more filtering conditions to your records in the URL. For example, the URL https://airtable.com/shrsa57bWpEecPtzp?filter_Category=Brand%20identity w... I had no idea this existed until relatively recently.

40
F
D
Devan_KreitzerInspiring
asked in Other Questions
Transforming a call Duration (number) into a datetime string to use Stacker

Hello! I am currently putting call data from Twilio into Airtable to then transform and present via Stacker. Currently, I can put the call start time (datetime), the call end time (datetime), and the duration (number) from Twilio itself. I know there is the DATETIME_DIFF() formula, but the issue with this is that it produces an integer, where I am wanting h:mm:ss. I also know you can use the integrating formatting option that Airtable has on Formula fields, which works fine if I was only using Airtable. The difficulty comes in when I need to get this duration time into Stacker. Stacker does not do the same formatting option as Airtable and pulls in the duration integer (as seconds). Any ideas?

290
Justin_Barrett
M
Max_PollardNew Participant
posted in Other Questions
Import data from one spreadsheet into calander

Hello all! I am entering in visitor information into airtables. I am entering their name, contact details, and what time they will require access. When I do a calendar view, it shows the date I have them arriving and the date they leave, but I want it to display the entire time they’re there. If I put in that they need access from 8am-3pm, starting on date #1 and leaving date #2, is there any way to automate this so that in the calendar view it displays their appointments on every date inbetween?

21
M
J
Jeremy_CaiNew Participant
posted in Other Questions
Hiring FT Project Manager - deep Airtable exp required

Hi Airtable community! Reaching out with a quick favor - I’m searching for someone for a Project Manager, reporting to our VP Revenue. Ideal candidate is in LA or SF with a lot of experience in project management, Airtable (duh), and startups. Would you happen to know of anyone who might fit the bill? Figured it’s worth a shot asking! Thanks so much and hope all’s well!

30
J
J
Jesper_HolmstroKnown Participant
asked in Other Questions
Removing HTML code in the beginning of text

Hey Guys! Im trying to remove a text in the beginning from a lookup field, by formula. The text starts with "<div class="vaning"></div><div class="namn">" and I want to remove “<div class="vaning"></div>” in the beginning. I tried with the replace formula but only get error messages, does anyone know why? For example: REPLACE({field name}, 1, 26, “”) Thanks J

350
J
A
Alvaro_SanchezNew Participant
posted in Other Questions
Automations for Birthday Notifications in Outlook Airtable

Hello!, I want to create an automation to send an email from outlook using Airtable. I have everything, and for trigger, I want to use the date of birth, but in the current year. I use a formula that I’ve found in another topic that is DATEADD( Birthday, DATETIME_DIFF(TODAY(), Birthday, ‘years’),‘years’ ) But I have one problem. A lot of dates, when the formula runs, instead of 2022, put 2021, and I don’t know why. Anyone could help me? I don’t know if it is a format problem or what Thank you

10
A
Pete_Lindley
Pete_LindleyParticipating Frequently
posted in Other Questions
Week numbers as milestones on Gantt charts

I am using airtable to plan several jobs and projects. I’m looking to add week numbers into the gantt chart and defined table views. For the gantt, they could be milestones? Is there any decent way of doing this please? Thanks in advance. Pete

00
Pete_Lindley
A
Aaron_Schiff1New Participant
posted in Other Questions
Format multiple times

Hello, I have two tables. One table the primary key is dates. Every entry is a new date. On the second table, I’m trying to show the list of dates so that it can show up for calendar view. Since when I connect tables it doesn’t understand that the primary key is a date, I use the dateparse function. However, if there’s 2 dates, dateparse doesn’t work. Is it possible to get multiple dates?

44
ScottWorld
A
Antoni_IsclaNew Participant
posted in Other Questions
Parking lot bookings

I am creating a base to control the reservations of a parking lot. I have the seats and reservations created, but I can’t get Airtable to prevent me from reserving the same seat more than once in a day. I have only managed that if the place is already occupied, it does not offer it to me, but if the entry is on a future day, it continues to propose it as available.

312
A
M
Megan_Smith1New Participant
posted in Other Questions
Squarespace Product Block Data

How can I automatically create a new row of data in airtable from my squarespace account with the product data, custom product form, data, and customer data?

72
M
Ron_Daniel
Ron_DanielInspiring
posted in Other Questions
How to get info out of the JSON that an API delivered

I’m a total newbie to JavaScript, and pretty proud of myself that I’ve figured out how to connect to my company’s API to get store information. console.log(await storeInfo.json()); is displaying all of the JSON returned from the API call, but now how do I get that data out of the JSON? Example: CONSOLE.LOG :arrow_forward: (1) [Object] :arrow_forward: 0: Object 1. StoreNumber: “1234” 2. StoreName: “Joe’s Market” 3. :arrow_forward: StorePhoneNumbers: Array(2) :arrow_forward: 0: Object Description: “Fax” PhoneNumber: “800-555-1212” :arrow_forward: 1: Object Description: “Landline” PhoneNumber: “800-555-2121” How can I pull the store name and phone numbers out into individual variables that I can do stuff with?

11010
kuovonne
D
Dev_OpsNew Participant
asked in Other Questions
Paste sets of number data into a multiselect field

I need to copy sets of data from Google sheets over to Airtable’s mulitselect field. I have successfully copied the Example A sets of data into a multiselect and it works. But for some reason Example B data copies only 1 set of data, not the entire data set. How can I achieve the same results as example A for example B. Example A contentIdComplete: 5ff7f3ea61d89c3d4f1a00f6,5ff7f40f4d6d0a37a3879004,601bdf764ac7ca3c4ae31211,601be02d58c9a36f26a0f9b8,60226b2bca657c6d5a43ccd1,60226d622a2f924017052bcc, Example B contentIdCompleteDate : 1616704037,1616704037,1616704037,1616704037,1616704037,1616704037,1616704037,1616704037,1616704037,1616704037,1616704037,1616704037,1616704037, Watch the Loom video https://www.loom.com/share/825d9c899c7c4762817030d95def3ad1

80
D
S
Sam_SmileyNew Participant
posted in Other Questions
Calculating a Product cost based on options

I’m creating a table to help develop products. I would like to have certain parts determine pricing. So if I’m creating bikes for example - each type of seat or wheel will affect the price. Example: Seat A = $50 Seat B = $10 Wheel A = $100 Wheel B = $200 Seat A + Wheel B = $250 Seat B + Wheel A = $110 The real one would have several more options, but that’s the main idea. Ideally there would be a “Wheel” field where you could choose A or B. Same with a Seat field. The Pricing would then calculate the total of whatever configuration you’ve chosen. Thanks for any help!

404
C
J
John_VairinNew Participant
posted in Other Questions
Help with Snapshots

I just restored, using an automated snapshot, this morning, my work saved on Jan. 16th…simply because I needed to check back at something I did. Now, I can’t restore my work back to this morning, and I feel like I have lost my work from then to now. Are my automated snapshots, including this morning, going to eventually come back? Since it said when I originally restored, that my work from after Jan. 16 to this morning, wasn’t going to be lost, am I going to eventually be able to restore it? Or is there a way to restore it now?

01
kuovonne
H
Hector_SantiestNew Participant
posted in Other Questions
Adding Multiple Records via Automations

I’m trying to create a personal goal/habits tracker that updates automatically as I change the status/mark the checkbox. There’s two fields here the name of my goals and the categories I’ve called “subfocus.” The problem is that when I run an automation to my link the record into my tracking sheet, the automation replaces the record instead of adding it. I was going to use a “count” field to tally up all of the completed objectives, but it only gives a single record, it doesn’t update them. Any thoughts on how I can get the automation to add in the record, not update it?

10
H
R
Rowan_FernandoNew Participant
posted in Other Questions
Help with multiple recurring reminders for health & safety audit

I need to structure something that will help me keep track of and remind me of our weekly Fire Alarm tests, lighting tests and PAT testing etc. Firstly, I need a notification/email/reminder every friday to alert me to do the call point tests. Then a way to record that the call point test has been carried out. A way to make any notes that may be needed in regards to the call point test. A recurring ANNUAL fire drill reminder. (with checkbox/notes etc.) A recurring ANNUAL emergency lighting test. (with checkbox/notes etc.) A recurring MONTHLY lighting flick test. (with checkbox/notes etc.) An Electrical Asset register. A 3 yearly PAT Test reminder. A 2 yearly PAT Test reminder for small appliances. Thank you in advance for any tips you can give to help with these recurring reminders etc.

141
JonathanBowen
J
Justin_EppleyInspiring
asked in Other Questions
Update a field with all records from a separate table that meet the criteria of another field's value

Hello AirTable Community! I’ve been wracking my brain for hours now so thought I’d see if I could get some infusion of help from the group at large. Basically, I have a base with with a table called “Categories” in it that has 13 different product categories as the name field. I have a second table (in the same base) that has a full list of product names with their associated category. I would like to lookup from the “Categories” table and pull into one field all the product names that are in that category. This sounds weird ( I think? ) but it’s my current solution to an Airtable to Webflow collections sync so that I can have a category collection that still allows me to access product information, if that makes sense. I’ve been successful in linking the tables but this would require me to go through and individually select each item (like tagging?) which is cumbersome, ripe for error, and annoying because the second table will update relatively frequently with new product values

120
J
N
Neil_ThormanKnown Participant
asked in Other Questions
'Loading' a record

Is ‘loading’ a record the right concept. Up to now I’ve been using lines like: let record = await input.recordAsync("Who is Mum", view); and in my head this has then let me wokr with a chosen record. But now I want to ‘load’ a record from a ‘link to another record field’ and I suspect I’m missing a fundamental point somewhere: My code: let table = base.getTable("Characters") let deadMen = table.getView("Living Males") var deadMansRecord = await input.recordAsync("Who Died", deadMen); let theWiddow = deadMansRecord.getCellValue("Spouse") let theWiddowID = theWiddow[0].id console.log(theWiddow) console.log(theWiddowID) let widdowHome = theWiddow.getCellValueAsString("Nation of Birth") console(widdowHome) and the result when I run it for Albert. Why is my getCellValueAsString(“Nation of Birth”) not returning Germany? Reagrds Neil

20
Justin_Barrett
I
Ian_james_DuncaNew Participant
asked in Other Questions
Sorting tables with articles

Hello! Is there a way to sort tables and ignore articles? For example, if we are using a big list of movie or book titles with the words THE, AN, A before the title.

20
kuovonne
Ted_Willett
Ted_WillettNew Participant
posted in Other Questions
Is it possible to roll back a base?

I added a number of titles and instead of adding them to the bottom of the records, airtable randomly interspersed them into the existing records and linked and unlinked other fields - I need to roll back the base like an hour

2292
kuovonne
K
Kaleb_Penner1New Participant
asked in Other Questions
Scripting - update variable value using a 'number' from a single select field

Hello, new to scripting, running into an issue on a single line as I hack my way through. Just trying to update script var “totes” to be 10 times the value recorded from the single select field “Pts this week”. So if “Pts this week” has a value of 7, the script var totes should be 70 after this line is what I am trying to accomplish. The line below gives me NAN so I’m doing something wrong on this particular line. If I am not mistaken, NUMBER() should do the trick as the single select value of 7 will be a string if taken as is. Anyway, here is the line. Any help is appreciated. totes = 10 * Number(record.getCellValue("Pts this week")); Thanks in advance

120
K
Y
YetGenNew Participant
posted in Other Questions
How to hide/reveal fields in multiple views at once?

I have 15 different views in the same table. The field named “phone number” is hiden in each view. Is there any way to reveal this field in all views at once? (I guess batch update can’t reveal or hide fields)

70
Y
M
M_kInspiring
posted in Other Questions
Using Integromat…

Hi Airtable! I have a scenario that creates new records, from one base to another. I created a filter, but it does seem to be working. Did I create the correct filter? Mary

04
M
M
maxim_kulikovNew Participant
posted in Other Questions
Custom app, sending SMS

Hello. I’m trying to create a custom application for sending SMS from Airtable. Actually there already exist an app like that Airtable Support Send SMS app With the send SMS app, you can send a list of phone contacts in an Airtable base mass text messages, using the Twilio API. Please note that you need a working Twilio API key to use this app. The se... but for some reasons I can’t use Twilio service. So I’ve got a code from telecom provider which I’m working with, and this code is working when I run it on my own computer, it sends SMS. So I wrote the function in my Airtable custom app with this code, but it’s doesn’t work when I trying to call this function function sendSMS(){ const https = require('https'); const data = JSON.stringify({ auth: {apikey: 'API key'}, data: { message: 'TEST.', sender: {text:'TEST'}, recipients: [{phonenr:'+421XXXXXXXXX'}]

50
M

Badge winners

Show all badges
Terms & Conditions