Other Questions

Hi I have a main base where I store all member information. I have another base where I have other information but not every field in the main base. If I change the information in the main base I want it to change in the other base. How is this done in Airtable?

Hello. I am having some trouble with automations for email reminders. I am using the formula below to create the condition that will be used in the automation. When entering the start date and time, I can’t seem to enter this information quickly enough without either a) the date appearing as a partial of the real date (eg “9/1” instead of “9/16”) and thus triggering an email immediately, or b) the auto-populated time for the date (the current time) appearing and thus triggering an email. I can tell this is happening because the start time field appears in the email header as “9/1/2022” instead of “9/16/2022” for example. Is there any way to get the system to give you a few seconds to enter things before jumping the gun? Thanks! IF({Start date}, VALUE(DATETIME_FORMAT(SET_TIMEZONE(NOW(), “America/New_York”), “YYMMDDHHmm”)) >= VALUE(DATETIME_FORMAT(SET_TIMEZONE(DATEADD({Start date}, -30, “minutes”), “America/New_York”), “YYMMDDHHmm”)))

Hello. I want to make the receipt based on the form that user have been input. I have add new table for the name and price. Is it possible to do with basic plan? If yes, how do you make it? For example user will input [ TV - 1, Washer - 2 ] and the next page, the airtable will calculate the total price and print as receipt I would appreciated if anyone can help me solve the problem. Thank you.

Hi, I’m using a dynamic PDF tool (ELEDO) which gets info from Airtable to populate a contract. Sadly, this tool can’t loop through a list of record and extract informations I need. In particular, I have a link field of which I need to extract each individual record to populate fields which its linked content. I’ve look into the automation but there’s no option to split infos of my linked field. The closest think I read was this article but the link inside is dead and I don’t want to create new tables but populate fields inside the same table. The entire Use case is this. I have a children table I have a parent table -I have a link field which contains the list of children inside a parent record I want to split the link record into other field: child 1, child 2, child 3… which are populated with records inside the link record Any idea ?

When having longer field names (eg Email address: private and Email address: organisation) it’s guesswork which field is mentioned in the popup. Yes, you can hover over the field names to see, but you can not hover over the corresponding field names to the right. This is very annoying. It would be great if the width of the popup is bigger or if you could resize it like we can do with eg the formula field.

Hi there, I posted a topic earlier. When I edited it right after, the Akismet moved it into spam. Is there someone here that can please move it?

Hi there, I am trying to obtain data from an airtable link. I only have a basic link (not API) and an API key. example link: Sign in - Airtable example key: keyMYCOOLKEY When I use the link above, I get a HTML page back with data, but I can see it asks me for login. This causes a JSON syntax error on my end because my system can’t process the HTML when the data does not exist within it that it needs to see. When I use the link and change the app, tbl it viw characters for testing I get a page not found back and then I know that the original link should actually give a result - just need to have a way to “sign in” using the API key. If I add the API key at the end of the URL, it makes no difference. If I pass the api_key as Bearer with curl via a local Test PHP, then I only get back Found. Redirecting to /login How do I use the link and API key as they are and pass them correctly to get HTML data back, which contains the data required, instead of having the login issue? The aim is that

I’m looking for a way to create a calendar for our courses in airtable. I have our courses loaded in to the database with the start and end date but I need to be able to tell it certain things like, this course meets every Monday AND Wednesday. Is there an easy way to do this while also telling Airtable that it will occur every week until the given end date.

I am looking for an extension or integration that will allow me to chart data within a record and compare it to data in another record. For Example if record a contained the following data 1,2,3,4,5 I might get a plot of that data on the y axis with a standard x axis which might be 6,7,8,9,10 etc The second record might have the data 2,4,6,8,10 that would appear as y data points and again the standard x axis would be used. Please do not tell me to turn the table sideways this would not work for numerous reasons. Here is a very small example of the data I would like to plot i Wishon S2S Blue 45 A Wood 1 808 839 853 831 789 Wishon S2S Blue 45 A Wood 2 784 823 837 831 829 The text in bold is the record name and the remainder is data. The record name would identify the line and the data would be plotted as data points where the x axis would be labeled 6,7,8,9, etc

Hi, I am using Airtable as our database and CRM. Is anyone else doing this? These are the “user stories”: When I click on a contact to send email, open a window where I can select from a template, customize, and then click send. Sending should send through my gmail account If I receive a response, it should go into Airtable The contact should then be added to my Lemlist for follow-ups based on the Template selected Thanks! Tim

How do I get my projects (which is a primary field), to be linked to my tasks records? For some reason when I link two tables, they do not appear on the table to be linked. Here is the project tab, with the projects being the primary field Here is the Tasks field where the project field should be linked to I add the linked “tasks” field from the Tasks table And the linked field from the Projects table does not show up in the Tasks Table

I have a a base that has a set IDs (600+ unique IDs). I need to update their status’s weekly but the report to update has over 9000+ IDs. I only want to update my 600 without adding any other records to it. Is that possible with the CSV import extension?

I’m trying to create a field (Bulletins) that will return one of three values, based on the presence of one of three phrases in a record’s long text field. Basically: If Comments contains Advance Notice, then populate Bulletins field with Advance Notice If Comments contains Time Sensitive, then populate Bulletins with Time Sensitive If Comments contains Update, then populate Bulletins with Update I’ve tried a couple configurations to get it to work and can’t quite get there. Any help would be much appreciated!

We use Airtable to “process” company data (ie. add additional information about a prospect). I have interns enter a view called “Data Processing” where each row represents a company, and there are several fields for them fill out before clicking a checkbox to mark the row as complete. Each intern has their own Airtable login, so I’m wondering what’s the best way to track “companies processed per intern?” My first thought was to create a multiple select field called “Processed By” where they would select their name from the list, thus marking the company as processed by them, but that seems a bit tedious and error prone. Is there a way to automatically populate a formula field with this information? Such as “capture who the last editor was within a certain view?” Or “who checked the checkbox in the 'Data Processing view?” Another similar example: the interns must write “icebreakers” for companies as well. Today once they’re finished writing their icebreaker, they click the checkbox to m

Hello, it is possible to use the Sumproduct formula for Tier Pricing in Airtable? I am trying to calculate the revenue for a marketing agency and it´s based on tiers depending on the total amount of media spend, in Excel it looks like this, example: =(SUMPRODUCT(–(sum($D205)>={0,99999,200000,9999999}),sum($D205)-{{0,99999,200000,9999999}},{0.2,-0.025,-0.025,-0}))

I am trying to filter my Rollup sum value by like items identified in the record but the conditional rollup option only gives me static filter conditions that would apply to all records, not the specific ‘Component Name’ that is in the record I am trying to rollup. The Rollup function works great for summing the batch quantities for Rack R3, but I have 3 different types of items on Rack R3 and I need to filter the Rollup to the record ‘Component Name’. Note: Batches are created whenever inventory is added or subtracted from the Rack.

Hello all. I have a quick question about scripting: is it possible to run a base sync using a script? I’d like to create a button on an interface I’m working on to run a sync, so that the users don’t have to go back to the base to run a sync. Is this something that’s possible, and if so, could you point me in the direction of how to make it happen? Thank you!

Is it possible to lock some tables under the same base which not everyone can view

I am working to build an Airtable base that allows employees to request paid time off (PTO) from their managers via Airtable form. The form requests the start date and end date of PTO. Ideally, from there, I’d have a field that populates the number of days PTO amounts to MINUS weekends and company holidays. I’ve used a workday_diff formula, but I have to update the holidays listed each year manually. Is there a way to use the workday_diff formula that automatically updates the holiday dates each year so they don’t have to be manually updated?

When I try deleting a record, it says “Unable to delete record. This table is configured so nobody can delete records”. Might it be something an administrator set? I duplicated the base and its still not allowing me to delete. Any suggestions?

I want to use an Airtable form for a program sign in. I have previously collected emails, etc, for most attendees. It would be great if they enter their name and then the address I have pops up with a “Is this correct” question. I tried just doing a simple form where it asks their name, but it shows nothing more. I would like to not make people re-enter info. Thanks.

Hi all Hope all well. I am working on a touring exhibition of 100+ objects. I am having custom crates made for each object before they travel. There will be approx 40 crates in total. I’d like to pop a QR code on each crate, which the crew can scan to take them to the relevant Airtable page so they can see notes / contents without opening crate - they can also check it in / out. Does anyone have any recommendations for a QR code generator which will create a link to an Airtable URL? There are loads out there - so a recommendation would be good if possible. Thanks, Andrew

Sendgrid Essentials program is fine for mass emails, but useless if you need to have all records delivered. The Sendgrid Essentials program puts you into a shared IP/Server pool with up to thousands of other users. If there is a spammer in the bunch, all users suffer. I cannot send a single, one-off email to aol, yahoo, or comcast as my assigned IP is blocked by most ESPs and blacklisted by spam services. Sendgrid will not allow switching of assigned IPs, so the service is useless. Airtable support only suggest using automations. Are there any other ways of sending emails other than using automations with jury rigged triggers?

I have a really big complicated thing I want to do, but I am trying to break it down into smaller problems. I think I have many parts that I don’t quite know how to do, but we’ll start with this one. Big picture: We currently use a spreadsheet of expenses and that spreadsheet also has columns which calculate how much of each expense is allocated to each of 3 fixed/known people, according to a predefined split with each person’s allocation being in a fixed column for that person. I want to convert this to Airtable and make the people part table driven with the People table listing the person, and their allocation percentage: Person 1, .5 Person 2, .4 Person 3, .1 So if there are Expenses: Item 1, 100 Item 2, 200 Item 3, 300 Then I want to have a table or view that ultimately gives me: Person 1, 300 50 + 100 + 150 Person 2, 240 40 + 80 + 120 Person 3, 60 10 + 20 + 30 The math is not hard, but I don’t know how to configure a new column in the People table to create this conditi

Hello all, Been using Airtable as a personal budget manager for a while now and I’m trying to tidy it up a bit more. I have a few sheets, Income, Expenses and Individual Overview. Inside of the Individual Overview I have Person_1 and Person_2. Inside of Income I have the multiple income sources and I link Person_1 and Person_2. Now where it gets hairy is inside of expenses; I list all the monthly expenses and link Person_1 and Person_2, though there are some line items we have that require us to split the bill where there are other items we do not. For example, we can link both Person_1 and Person_2 as responsible for Rent, Groceries, Electricity (split expenses) and also link them to Gas, Student Loans, Spending Money (individual expenses). When I do a rollup inside of Individual Overview, I’d like to be able to designate those split expenses to have it allocating the total income towards the appropriate amount of the bills that are due.