Other Questions

Hi, I was wondering, is there a way to know when someone precisely has open an email sent by automation? Thank you!

Hello- I am trying to add in a concatenate formula in here that when the drop down is selected as in APPROVED FOR PRE-PRO, THE STATUS IN FORMULA WILL READ PRE-PRO-APPROVED FOR PRE-PRO not just PRE-PRO. SWITCH( {PRE-PRESS STATUS}, ‘APPROVED FOR PRE-PRO’, ‘PRE-PRO’, ‘’, SWITCH( {FINAL PROOFING STATUS}, ‘APPROVED FOR PRE-PRESS’, ‘PRE-PRESS’, ‘’, SWITCH( {SUBMITTAL STATUS}, ‘APPROVED FOR FINAL PROOFING’, ‘FINAL PROOFING’, ‘’, SWITCH( {DESIGN STATUS}, 'APPROVED FOR SUBMITTAL', 'SUBMITTAL', '', SWITCH( {PROJECT STATUS}, 'APPROVED FOR DESIGN', 'DESIGN', '' ), 'DESIGN' ), ‘SUBMITTAL’ ), ‘FINAL PROOFING’ ), ‘PRE-PRESS’ )

Is there a problem using a formula field in another formula field ? I have 2 calculated fields that I want to derive from 2 number fields. The 2 raw number fields are {Seeds per g} and {Plan2023}. I derive an {adjusted Plan} field using 1.1*{Plan2023}. I then want to derive the {wt of seeds required} field using {adjusted plan} /{Seeds per g} but this gives an error for every record. Even if I make the {wt of seeds required} formula something really simple like {adjusted plan}/2 or 0.5*{adjusted plan} it gives all errors. I can make the formula just = {adjusted plan} but as soon as I do any numeric operation on it it gives errors.

For the past week or so, when I update the category of a record in my Kanban view, the record no longer automatically moves itself to the new category that I assigned it to. It still remains under the old category. If I manually refresh the page, it shows up in the correct category, but only after I manually refresh the page. This used to update on my Kanban view automatically. Is this a known bug?

(Sorry if this is wrong group, but I found no other more suitable for this very basic question.) The questions really says it all. With the desktop Airtable app, are databases stored on the local computer (Mac, in my case) or only online?

Hi all - any suggestions out there for best way to do periodic (e.g. monthly or quarterly reporting) for an investment portfolio where things like cost, value would change from period to period, as would additions/deletions to the company records? I am referring to the data (not the visualization/reporting) of the data. Would I need to duplicate the base and simply have a series of bases, each for a different period? thanks!!

I have a list of URLs that I pulled from GA that I want to pull into my publishing process that’s tracked in Airtable. I have every piece of content on the site contained within its own card in Airtable and part of the card data is the URL. Is there a way I can take the whole list of URLs from GA and search for all of them at once? I want to use that function to quickly pull the cards I need into an August content plan. I know I could find each corresponding card one by one, but it would be nice if I could find them all at once and then flag them all for the August content plan in one swoop.

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 make it editable. An

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?