Other Questions

So I have a payment tracker in google sheets and am trying to figure out how I can get it to work similarly in Airtable. Below is an image of my google sheet. Everything in red has a formula. The “Monthly” is calculated by dividing the total by the length. The “Remaining” is calculated by multiplying the amount of the “Monthly” by the number of checkboxes, then subtracting that from the total. Google “Remaining” formula: =C3-(COUNTIF(E3:P3,TRUE)*D3)

How would I go about duplicating this in some way in Airtable since each cell can’t have its own formula? Cell formula: =COUNTIFS (Inventory!B8:B, "Tiny", Inventory!C8:C, "Head", Inventory!G8:G, "In Collection")

I have a discord bot written in javascript using autocode. When a user joins my discord server, my bot updates my airtable table called discord. I have another table linked to the discord table, called defense. The defense uses the discord fields of ID, User ID, Username, and Role from the Discord table. The defense table has some other fields which the user should be able to update later. How do I get the Defense table to update with the new users when they join the server? Right now, I insert a record into the Discord table with the user info. But even though the two tables are linked together, the Defense table is not updating with the new users info.

hello. is there a way to import outlook email attachments directly in Airtable? I have an automation set-up to import the data (e.g. subject, body) from the email, but have been unable to get attachments to come in as well. appreciate any insights.

Hi, Thanks for your time. I’m looking for some help with a form that allows facilitators to sign up for training sessions. These sessions happen every week and require multiple facilitators. I’m asking for their help, so I want them to have to do them minimum amount of form-filling possible. My ideal situation is: A form in which facilitators can select their name from a drop down list (that bit is fine) A form which lets them select which sessions they are able to attend (this bit is where I’m having issues) And a backend system in which I can see which facilitators are attending a session easily. I’ve been experimenting with three potential situations The facilitator chooses the date from a date field on the form :grinning: Upsides: I know it works :cry: Downsides: They might choose the wrong date, and they also have to submit multiple forms in order to share the

Hello fellow airtablers… So, im new to airtable, and i want to set up a base for tracking goods in our warehouse… So I made a row called “total in stock” and now i wonder if its possible to set up another row, that will subtract the number entered, from the “total in stock” row? The number entered here, would preferably dissapear afterwards, so that if someone else picks up from the same item, they can also put in the ammount, and it would get subtracted from the total… Hope I explained this understandable, and that someone is able to help. Have a good day everyone

Hi there, I’m using this script by @Justin_Barrett to batch duplicate some records: This is what it looks like:: let table = base.getTable("TaskLog"); let query = await table.selectRecordsAsync() let checked = query.records.filter(record => {return record.getCellValue("Copy") === true}) // Make new records based on those that were checked let newRecords = [] for (let record of checked) { let newRecord = {fields: {}} for (let field of table.fields) { // @ts-ignore if (field.isComputed || field.name === "Copy") continue let value = record.getCellValue(field.name) if (value === record.name) value += "" newRecord.fields[field.name] = value } newRecords.push(newRecord) } while (newRecords.length > 0) { a

This should be easy but i am not succeeding in getting it done. I have a field named “month” and i want it to change according to a date field. If the date is in October i want that field to have the word “October”. I have it as a single select field but i would like it to be automatic. How can i do this? Be it an automation or function or zapier or whatever. Thanks in advance.

Hi, I wrote a little script who : 1/ Delete some records of the table tableSuiviFacturation while (recordToDelete.length > 0) { await tableSuiviFacturation.deleteRecordsAsync(recordToDelete.slice(0, 50)); recordToDelete = recordToDelete.slice(50); } 2/ Insert some new recors in this table : await tableSuiviFacturation.createRecordAsync({ "Client" : [{id: clientsID[item]}], "Période" : Periode, "Solde début période" : montantDernierSolde[item], ......... And I 've a error SyntaxError: await is only valid in async functions and the top level bodies of modules If I remove the await, the error disappears but I don’t understand why ?!!

Hi Airtable Experts. Can you see if you can help me out? I am using Zapier to sync records with airtable (all 3 are free plans). All goes well, except for some date fields in hubspot. For Most airtable date formats it doesnt sync and when it does its the wrong date. Like 10 or 600 years from now. What am i doing wrong? Thanks in advance.

I’m curious: WHEN did field-level permissions arrive? I’ve tried dated-limited internet searches and can’t find anything before 2021.

Newbie question here! I searched the forum and couldn’t find what I needed. Wondering if it’s possible to share a read only link to a view with a URL parameter that filters to only show the records that match the parameter value? Specifically, we have a field called “Group ID” that serves as a parent/master identifier that we use to group records together. I would like to share a read-only link with the Group ID value added on the end as a parameter. The viewer would then only be able to view records that had that particular Group ID. I’m able to dynamically generate the URL and send each time with a different Group ID and only want the viewer to see the records for that Group ID referenced in the URL they received. The general idea is: www.airtable.com/viewid/?groupid=123456 would only show records that had a value of “123456” for the Group ID field. I’m not sure how to

Hello, I’m testing Airtable as our potential new tool in our agency, but couldn’t find a very important fuction, to sort these tables by collaborators to see only records connected to them. Let’s say we have a main table where every project is we are currently working on in our agency. For each record there is a collaborator pinned by his account who is responsible for this specific project. But as we have few employees, we want to create a main table where all the project will be visible for everyone, but also create a seperate tables or views, so a specific person will see only his records. If it’s going to be a table, obviously it would have to be somehow automated, so whenever someone create a new record with him as a collaborator, then it should copy this record into his personal table in the same time. Is it possible? It seems to be such important fuction yet I cannot find it…

I’m reposting this request because my original was closed 15 days after a single reply by a Mac user who suggested a solution that is Mac specific (thanks for the suggestion, though) that didn’t translate to Windows because as speculated, it maps to the Switch Applications hot key combination (). So let’s try this again and hope that some with Windows experience replies within 15 days. I’m on Chrome (latest) on Windows 10 (21H1). I cannot find a key combination that will move the cursor out of a Long Text field. The usual suspects including Esc, “Tab” in various combinations with Alt, Shift and Ctrl don’t do it! I hate having to take my hands off the keyboard to use the mouse just to move to the next cell and then try to find the “home row” on my keyboard accurately with barely perceptible index finger markers. Thanks in advance, /Gerard

I want to have a form question that is single select. I want the answers to be a long sentence. However, when the form is shown, the sentence is cropped after about 4 words. Is there a way to set this up so the form looks correct? Example. Choose one of the following: Blue is my favorite [form truncates here] color because of xyz Green is my… Red is my…

I think I have a “chicken and the egg” problem. I have created a task list table for freelancers I am working with. I would like them to only see their own tasks and not tasks I have assigned to other freelancers. I can create a view for each freelancer by having it grouped around them as a collaborator. But, in order to add them to a collaborator field, I have to invite them to the base first. So I can’t create the personal view until they are a collaborator. But I can’t invite them until I can restrict them to the personal view unless they are already a collaborator. Am I missing something? Thanks.

I would like to create a Table to check the number of items in stock by date and time. ■Order └ Product Name (Link Table) └ Unit Date ■Production Product Name (LInk Table) └ Unit └Date At this time, the same Product name and Date are used in Order and Production. Is it possible to display items that have the same product name and date in different tables? Even just a link somewhere or a general idea would be very helpful. Order Production

I want to send an SMS reminder to staff to submit their lesson plans if they haven’t yet submitted it for that week. What formula can I use to look at the most recently submitted lesson plan for that teacher and if it was after a specific date then include/exclude from the sms reminder?

I have a table with ~5k records which I filter to show a subset of, then I create a PDF report of the filtered records including the images in the attachments field. This has been working perfectly until last night, when the images started to output as solid black boxes, but the preview of the PDF in the Apps sidebar was fine. Nothing has changed in my base, except that I hit the 20GB attachment limit which prompted a warning about the base exceeding limits and needing to be upgraded. I modified the structure to avoid this in the short term (but will need to upgrade to Enterprise ASAP anyway), reducing my total attachment storage to 16GB and removing the warning. But the problem with Page Designer still exists even though i’m now well within the limits of my Pro plan (50k records, 20GB attachments). Images attached with private content blurred.

I’m trying to make a column show different currencies. I’ve got a column for price and a column for € price and formula field that is controlled by a 'currency switch' which determines if the price in the formula field is shown in or €. My problem is I need to multiply the formula field with another field but it’s now a string as it has either a $ or a € attached to it. Is it possible to take and convert the numbers in the string back into a decimal?

I am using WPForms → Zapier → Airtable. The situation: In WPForms I have a Form to upload 1-5 Files (Pictures). With Zapier I pass the data from the form to Airtable. The Pictures seems to get into Airtable as a link. The field in Airtable which receives the Link is an Attachment so I get an Image in Airtable. Which is perfect. The Problem: I only get the first url as an image. I want all the urls as an image in the attachment field (up to 5) Any ideas?

We need customers to enter an address, typeform doesn’t have this and neither does airtable, using jotform which is poorly designed. Does anyone have a solution? I mean the maps block uses google api? Why can’t a field?

Is there a formula I can plug in to see their age (so I don’t have to calculate anything?)

Hi everyone! Im new here so thanks in advance! My problem is simple , I have listing manager with a full record of my clients | Name, last name, phone,webflow member ID, Photo of listing, price and etc… I Want to split it that I will have one table I can see all the listings with a record of who submits that Flat. I use it to make a “status” function to send the data to my webflow site. Please help me out here :slightly_smiling_face:

Hi, I’ve created a shareable Calendar link following the steps described here. Integrating Airtable with external calendar applications – Airtable Support However, in Google Calendar the generated events don’t have an end date. Most events in my Airtable last more than 1 day, so that’s a big problem for me. Anyone else had this problem?