Other Questions

Hi everyone, I’m working on a table where there are two checkbox fields (yes and no) for each record (employee). I would like to track the total number checked on each checkbox field from all the records. So the total amount of yes and no selected by the employees. There are 100 records (employees) in total. Does anyone have a way to achieve this? Thanks for the help! -S

I saw that there was no solution to this in early 2021 (Is there a way to check if a script is run from a button field or the script app itself?). How about now?

Hi everyone! I’ve been building a calculator for B2B price quotes in Airtable. The idea is to put all the necessary info in a form and then display the end result. Since Airtable cannot add formula fields to a form, I’ve made a simple 2-page web app in Softr. The first page is the form, the second one displays the result. This is where the issue is: I cannot set up that the second page will pull up the result from the same record as the input on the first page. Has anybody else done something similar? I’m also not married to Softr, perhaps there’s a better way of doing this.

I used the API template code provided by Airtable, which includes a console.log of my data. That data is consoled just fine for me, but its not being returned to Postman (from where I made the call). The request in Postman takes up to one minute before timing out, with the “ERR: socket hang up” error. So I can only assume that I’m not properly returning the data in my function, but I’m at a loss, having tried returning it in every variation. Below is my function: (The return is inside the .forEach method, but I’ve also put it within the page function, and also wrapped the whole await base in a variable which I then returned at the end of the getStudent function. I also treid async/awaiting it). var Airtable = require('airtable'); require('dotenv').config(); const { API_KEY } = process.env; var base = new Airtable({ apiKey: API_KEY }).base('app8ZbcPx7dkpOnP0'); const minifyRecord = (record: any) => { return { id: record.id, fields: record.fields, }; }; export function g

I am moving my task management system from my existing provider to Airtable, but I can’t find a way to set up recurring tasks? Does anyone have a work around for this?

Hi everyone. I need some help with my base please. We have a monthly subscription business and all the customers are in the database. Linked to every customers is a set of products they receive this month. What would be the best way to send these products every month in Manychat to our customers (email would be fine too via Active Campaign). I’m think to create custom fields in either Manychat or AC. How can I send this data?

I’m testing the Google Cloud Vision app/extension. Is there a way to analyze/extract text for just new records? It appears as though, if you run the extension to extract text, then add new records to a base, there’s no way to limit the app to just the new records. Instead, you have to re-analyze attachments for which you have already extracted text. Am I missing something?

Hi, It feels really strange that when a user uploads data to my platform, anything from passwords/bank details /insurance policies, I (and my team) can just view their data without any blockers. Am I missing something? Surely no client is going to want to input sensitive data if the people who run the platform can view it with ease?! Any help would be appreciated Thanks

Hi guys! New user here, feel like this should be a simple one but just can’t figure it out. I have a table for Athletes and a table for their AthleteRecords. On the AthleteRecords table each record has an ID, and lists the Athletes schools (HS and College). I have a field in the Athlete table that is set to the ID of the most recent AthleteRecord for that athlete, and I would like to pull the SchoolType field from the AthleteRecords table that matches that ID and set it to a field in the Athlete table. This way I can have a field in the athlete table that shows the athletes “Current School Level” based on their most recent school entry. Thank you for the help I cant figure this one out!

I want to create a listing of freelancers. Would live to give everybody a way to view the listings/search and then see the details of individual freelancer on a page on its own. What’s the best template to create something like this?

On my view, it shows the form on the left hand side, and I can see that Jenn created it. On Jenn’s view, it’s not showing the form. Help! :slightly_smiling_face:

Hi Airtable Community, I have created new fields and an automation to allow me to automatically send out an email and Teams message 2 days prior to an observed holiday in our Company Calendar table. I have successfully figured out the date when the automation should fire, but now I’d like to take it a step further and ensure that it goes out at 9:00AM EST on the reminder date. Here are the relevant details: I have a formula field called “Remind Today?” that will either be set to “Yes” or “No”. Formula: IF(Category=“Observed Holiday”,IF({Reminder Date}=TODAY(),“Yes”,“No”),“”) ‘Reminder Date’ is a formula field. In the Formatting tab, I’ve selected “Date Format” = Local, Include Time, 12 Hr format, and use the same time zone (GMT) for all users. Automation triggers on conditions: Category = “Observed Holiday” and “Remind Today?” = “Yes”. Since the ‘Remind Date’ field shows a date with time = “12:00am”, I thought the automation would fire at midnight, but it actually fired at 8:52pm t

My base seems to be somewhat frozen. For example, if I’m trying to show a field in a view I’ll click on the hidden fields button and then select the field I want to see. However, when I click on the field the hidden fields box closes and the view does not get updated. Similar things happen when I’m trying to select an update to some fields. Like I’ll make a selection in a multi-select field and nothing happens. This is happening across several logins on different computers with different OS’s. Has anyone experienced an issue like this?

Hi, I am trying to get field names by request in table. airtable.table('Classes').select({ filterByFormula: `SEARCH(RECORD_ID(), "recr0DOF3YWjN9wAH,recwrHZ9zBIYFiU07,rectGHWsZVmkeRwGh,recJKCgej9ihrL2pK") != ""`, }).firstPage().then((data) => { data.forEach((data) => { console.log(data); }); }); In Students I get field ID’s, but I want to get it’s names by one request: I tried to search with select by record names, but it didn’t work. Table structure:

I have integrated Airtable tables into Power Bi desktop using API key. Now I want to set up the auto refresh of data on Power Bi online and it asks for credentials. I am not sure what credentials I should be using as I tried API key & Bearer token, but nothing seems to work. Authorization worked well on Power Bi desktop (check my post here: Airtable to PowerBI easy integration with API key). If anyone has any ideas, please help me to set up auto refresh. Anonymous authentication Modes of authentications available I tried using my Airtable credentials as Username & Password and API key & Bearer token as well, but nothing is working.

As you can see a formula that generates a date. Also as you can see, no filtering options by date for this formula field. Have tried a RAW and unformatted date in the formula which achieves the same result.

I issue invoices and progress reports on the 15th and last day of each month. My reports compile work that was done in the days leading up to that deadline. I also issue Payroll reports weekly - depending on the client - end of the week may be Sunday, Friday or Thursday. So any given record will be reported for Payroll on a weekly basis (if it is a time record) or invoicing / progress reports (time and receipts). At present I have created a Date table that matches each date to the corresponding Payroll cut off or Invoice cut off and then does a lookup to bring in the Payroll Report date and the Invoice / Progress date. My Date table needs to be updated periodically (right now it is good until Dec 31 2023). I just wonder if there is a formula I can use to get these dates to load automatically based on the Date_Actual (the date work was done or a receipt collected). Thanks!

How would one sync two tables in the same AirTable base? Is this easily possible? For instance, I have two tables in one base, each table is named Contacts, how would one sync those two tables so that if a contact record is changed/added/deleted on one table, it does the exact same change on the other table (all in the same base)?

Is it possible to create a unique page in the Page Designer extension for each table in a base or is the page created at the base level and applied to all tables? Thanks, Chris

Hi AT community. Looking for some advice and tips (btw, I’m new to Airtable). We’re creating an informal buddy/mentor matching program within our team. Our table is fairly straightforward and folks filled out a form: [record] Name areas of strength/expertise [open text] areas of growth [open text] paired for strength [hidden] paired for growth [hidden] The last two are to keep track of who’s paired up with whom. The ask: how can AT be leveraged to create matches between a listed strength/expertise with someone looking to grow in that subject. A few caveats, we don’t expect an automated pairing as other nuances will come into play (like time zones) but just something semi-automated that helps synthesize the blobs of input. Hope that makes sense. Many thanks.

I’m trying to create automatic due dates for video production timelines. We have different production timelines for different videos - ads and standard videos with a 5 week turnaround time, short form videos with a 1 week turnaround time, and instant videos with a 2 day turnaround time. I want to be able to select a final due date for the video and for the production due dates to calculate automatically based on the type of video. I’ve sort of figured it out - my problem is that the formatting is very difficult to read, and I can’t change the formatting. Here’s what I have: I’d like the due dates to look like a regular date without the time, but it won’t let me choose the formatting when I add the IF statements. Any suggestions? Thanks!

Hello, Not sure where to post that, so here we go :winking_face: I’d like to continue a series of data like shown in this example: https://support.airtable.com/hc/en-us/articles/208330098-Quickly-filling-cells-using-fill-handle However, it doesn’t seem to work when the number is a suffix like for example object1, object2 … I can’t believe it’s not possible ? am I missing something or ? Thanks a lot for your help, Regards. Nicolas Caplat

Zapier is saying that “New Record in View” is being removed by AirTable, is this true?

Hi Airtablers, I’d like to turn a normal link into a Rich Text Editor link automatically. See screenshot - “Link” is just text, “Zoom link” is a Rich Text link with the Zoom link as the click through. I’d love to automate turning the Link into a Zoom link whenever a new Link is added. Would this be possible?

Hey all - My client has a list of city addresses. When the public completes certain applications, their neighbors within 400 feet need to be notified. Is there a way to use Google maps to queue the addresses (in our dataset) within 400 feet? We’d like these addresses to then be linked in a postcard table. Data we have available to us: Full address Lat/Longitude Thanks Jake