Other Questions

Is there a way to make an interface view static, or “archived” so it doesn’t update say after a certain date? There’s probably a better way to say this, help please!

I have a formula field as follows: DATETIME_FORMAT(DATETIME_PARSE(RIGHT({Webhook Data},20), ‘^DD/MM/YYYY HH:mm^’), ‘DD-MMM-YYYY HH:mm’) But it returns a string - Is there an easy way for this same formula to return. date/time field that I can use for sorting please?

I have a form that prefills a unique ID for each customer. They then need to select an event that they are signing up for from a drop down menu linked to another tables primary key. The problem I am running into is that I cannot autofill the event they are signing up for and I really want to limit the view on the events to events that have not occured yet, or even better yet, event that triggered this form being sent out. Eventually there will be 50-100 events and I do not want them all to show up, and I don’t want to have to delete events etiher. Is it possible to run an automation that sends all information from events to a past event table that has the same options and then delete the event record form the ongoing events field? Any other thoughts or suggestions would be greatly apreciated. Justin

I’m trying to print out my records in the expanded view but have only figured out how to print one at a time. Is there a way to print multiple expanded records at once? Aka create a PDF with pages that are of the expanded record view?

Hello- I am looking for a formula that I am stumped on: I have a field with a single select that is called Campaigns. Campaigns has three categories, A, B, C. A, B, and C also represent tasks which is another field. These tasks have 20 options that represent a lead time. That lead time needs to be a workday add formula to a set lookup date that is driving these dates. So I need the option for all noted: As an example I’ll use this, when you select A from campaigns that equals -30 days, allows you to select all tasks that each have a different lead time associated to then auto subtract workdays from the static look up date. Does this make any sense, need multiple switch functions? Thanks!

There isn’t a button to share a view in the app

The link to the questionnaire form no longer leads to the form, but now leads to the registration page. As a result, unregistered users cannot fill it out. Has anyone encountered this problem recently? Previously, everything worked fine and you could use share form.

Hello- I have 4 buttons in my interface designer and they all point to a single select field for reviews and approval status stages. STATUS -On Hold -In Process -Needs Review -APPROVED On one of my buttons, when clicked it is APPROVED. How do I prevent anyone from just approving and clicking the button? Can I set it only one person is allowed to change this button with still allowing the other people to click the other 3 buttons?

Good Morning, I am trying to create a “Weeks Active” field in a base. I have a “schd_start” date field and a calculated “Today’s Date” field. I would like to determine the difference between the two dates and have Weeks Active then calculated. Thank you in advance! :slightly_smiling_face: Dan

i am a beginning user of airtable, and i feel i may be missing something. what do the rest of you do for joining/linking/merging tables with more than say a few 10s of records? i have a dimension table (properties) and a fact table (transactions). i need to join them so that each transaction has the right properties added. i tried multiple times to figure out how to do that with linked records, and lookup, and rollup, till it dawned on me that those only work when you, for each record, MANUALLY CHOOSE THE LINKED RECORD?! in my use case there are only a few thousand transactions going through per month, (and a few tens of properties) but that scale is obviously beyond a manual method. i have been looking around for ‘merge’, ‘join’, ‘auto-lookup’, ‘vlookup’, etc but nothing presented itself. i am quite surprised. i thought for sure that somewhere there’d be an automation, or a script, or an extension, or something that would provide this capability, but it rea

Hi everybody, we are a small French NGO supporting family carers. We use Airtable since last year. We need to develop simple online training courses for carers : do you know with which LMS (Learning Management System) Airtable can interconnect ? Is there any you would recommend ? We need something quite simple - to push video contents & have simple quizz and interactions - and cheap (or free) ! Thank you for your reply! Helene

Hello, Any help here on this Error for a blank date? WORKDAY( {PRODUCT LAUNCH DATE}, SWITCH( {TASK TYPE}, “BOOTH DESIGN”,-21, “SHOWCASE VIDEO”,-21, “SHOWCASE PHOTOGRAPHY”,-21, “LIFESTYLE VIDEO”,-21, “LIFESTYLE PHOTOGRAPHY”,-21, “APPAREL”,-14, “BACKLIT AD”,-14, “ADS”,-14, “SNAPCHAT ADS”,-14, “PR MARKETING GRAPHICS”,-14, “END SLATE”,-14, “PIN”,-14, “PRE ROLL AD”,-14, “EMAIL BLAST”,-14, “DISTRIBUTION ADS”,-14, “PRINT AD”,-14, “DIGITAL GRAPHIC”,-14, “QUARTERLY DIGITAL SPEND AD”,-14, “WEB ADS”,-14, “RETAILER KIT”,-14, “PRINT GRAPHIC”,-14, “OTHER”,-14, “GOOGLE DISPLAY ADS”,-14, “TENSION BANNER”,-14, “DIGITAL SCREEN GRAPHIC”,-14, “COPY ONLY”,-7 ))

We have 10 projects to vote. 15 people to vote. Each one need to give a evaluation between 1 and 5 for 7 parameters with diferent ponderation. Anyone can help me?

I’m not very sure this is achievable or not. Basically I want to automatically order all records sequentially all the time even i Reorder them. I have auto-number field. when I insert new record anywhere or move existing record I want to maintain the sequence, but that was not happening in Airtable. Am I missing any formulae or anything else?

Hi guys, So I am not new to Airtable, but I certainly do not consider myself an expert. This is the first complex project I have worked on, and I am hoping to get the community’s help in building it. This is a business model template with a cash flow analysis. The goal is to enter a set of assumptions in the scenario table, and then Airtable builds a business model with these assumptions with a cash flow analysis. The area I have the most trouble with is referencing certain records that fit dynamic criteria. In this specific case here the money from sales generated in month x is collected in month x+4 Each record in the sales table is for a month with a unique month ID. I want to have every month show the sales made and the sales collected automatically based on this formula Sales Collected for Month n = Sales Made for Month n-4 I tried doing it with a rollup function, but I wasn’t able to do it without manually linking each record independently.

Hello, I have an airtable dataset that includes: Customers: all the information about customers Trainings: all the information regarding each training (including the date) Inscriptions: that combine Trainings and Customers and also add extra info (e.g. how much the customer payed for the training) I want to build a Dashboard Interface where someone could state a “start date” and “end date” and the dashboard would show: All the trainings in those dates: this seems easy, just used a grid of trainings filtered by those date inputs) The total of revenue from those Trainings In the last bullet, how can I get the SUM of the revenue from all inscriptions in the trainings that are filtered by those dates? Thanks a lot

Hi, I am using the project tracker template and I want to be able to add a task to a specific project. I can get the projects, But how do I add tasks to that specific one? Now I only get existing tasks Any ideas?

Hello everyone– UPDATE: Nvm. I FOUND IT. I am an idiot. Please ignore this post. :slightly_smiling_face: I’ve been staring at my db for a few hours now and cannot seem to find the source of a discrepancy in values. My DB stores cash advance transactions on one table for a set of customers (found on another table). To get the total of advances to display on the customer table, I simply do a rollup. HOWEVER… the rollup value is inconsistent with the total I’m getting in the other table. I’m stumped. It’s maddening. Any ideas? Screenshots are attached if they can help. *T

How can you move or transfer images in one base to another base? Without downloading to desktop each image and uploading to new base? Is there a move to feature like GoogleDocs?

Hi there! I’m trying to develop a base to manage my company’s work and break out tasks effectively. We create artistic assets for clients, where each asset involves multiple stages of production (each stage roughly corresponding to a discrete task). I’ve created in my base an “Assets” table and a linked “Tasks” table - for ease of use, I was in search of an automated way to batch create multiple records linking “Tasks” to specific assets. I found the “Create child linked records script,” which is a great solution for this. However, this script only creates empty records (excepted for the linked field) - after records are batch created, I need to go in and manually enter the stage of production for each new task record from a single-select field. I’m wondering if there’s a way to further automate this function by “templating” the script so that it creates a record for each production stage? This would be especially helpful, as we create multiple different asset types that invo

Hi, For a desk booking system I am looking for an app maker. The app I want to create is an visual desk booking app. Clickable available desks/seats on a 2 floor map of our building. The pointers need to be marked a colour when booked later today, or another color when free (or by a filter on a later date for that day) Is it possible to add a custom map to a Maps solution would be the most simple solution or is there another way in Airtable? Much appreciated! Arno

I have a Table for Product Creation that is linked to individually tracked Inventory on hand with a rollup to count down available inventory left as it is used in production. So, when I get to a point in production, I need to select multiple matching ingredient records with separate record ID’s because, let’s say, I need 2.5lbs of Flour but I have a 1 Lb bag remaining and a ten Pound new bag in inventory. Using multi-select you can choose booth ingredients, but the rollup removes the value from both instead of using the last of the 1 lb. bag and then removing the remaining amount from the 10 lb. bag. So instead of having 1 bag left at 9.5 lbs. I have 2 records 1 showing -1.5 lbs. and the other showing 8.5 lbs. left. Do I want to combine first so when they are removed in the process tab there is only 1 linked record to rollup, or is there a formula to cascade a value between records?

I’m using airtable to track maintenance work orders. The issue I’m currently running into is tracking parts quantity used in a work order. A work order is a task that I assign to my technician for them to complete. When they’re assigned a work order, they’ll have to attach the parts they use to complete the work order. Right now I have a 1-1 relationship with the parts which works well when they select one part, but when they select two parts, the quantity in the Parts table is thrown off. I’ve read about junction tables and many-to-many relationships, and I’m struggling on how to get this set up. I want my technicians to still select the parts and quantity they used in a work order, and then I want my parts to get updated. For example - Work Order - Test Parts Used - Filter, Screw Quantities Used - 1, 5 This should deduct 1 filter and 5 screws from my parts table.

Hello! Since 2018, I have been running the registration system for an annual week-long conference using Airtable. So far, each year of the program has been run out of a separate Airtable Base. People attend for many years and it would be nice to be able to give them a way to view all of their data accrued over the years. (There are various challenges and assessments that generate data year-to-year, and it would be beneficial to give attendees a way to see all of their data over the years.) What is the best platform to create user accounts tied to Airtable data? The users would ideally be able to sign in to a profile with a username/pw and see their data from all years of attending the conference. I know that you can sync bases and have messed around with this, but it requires all user input to be put in exactly correct, or it will not automatically find and sync records from different bases. This results in a huge manual process of finding correct matching recor

Hi! I am trying to update an event in google calendar with the event ID but an error comes up saying: “Google reported an error while processing this action: The calendar or event you requested could not be found, or you do not have permission to it.” Does anyone know what can be?