Other Questions

Hello, Airtable hivemind! :slightly_smiling_face: I want to embed a table view from my base within an announcement post in a private Facebook group/community. The Airtable part is easy, it’s finding info about how to make it work at the Facebook end - or whether embedding an iframe in a post is actually possible - that I’m having trouble with. Rather than get even more dazed and confused exploring Facebook for devs (as a non-dev!), I’m hoping the much less daunting Airtable community can help. Many TIA for any wisdom! :pray:

I’m have some datetime fields that I’m trying to format down to isolate the time. However, I’m seeing that there are some glitches with how the time renders based on time zone. My source datetime field is formatted to PDT, but the output appears to be GMT. I don’t see a way to correct this because switching the datetime field to GMT for all collaborators produces bogus times that cannot be used for local dates. Is there an operator to add in the formula that corrects the glitch from the source datetime field, or is there a way to “lock-in” the time in the base so that GMT doesn’t muck things up?

I have requirement where I need to make link between two tables based on some conditions through code , Is this possible ?

In Filemaker I was able to set my field names to list alphabetically or in creation order or in custom order. Is there a way for me to have my field names list alphabetically?

I’m using a “record review” layout in interface designer to allow our team to review categories assigned to objects. I can’t seem to make the category field editable in the interface, even though I have no trouble with this for other fields. I’m wondering if you just can’t do that for lookup fields? Background: We have a table with all the items in our system. We also have a form that allows our wider team (who do not have airtable accounts) to assign categories to those items, then a lookup field in the main table to display those category assignments. We want the internal team to be able to use an interface to approve and, if needed, revise the category assignments. I am hoping that the interface can display all the items in the main table, whether they’ve been assigned categories or not, so I picked the record review layout and connected it to the main item table. I can display the category field (which is a lookup field connected to the form table), but I can’t ma

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:

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

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 Usern

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.