Other Questions

I just restored, using an automated snapshot, this morning, my work saved on Jan. 16th…simply because I needed to check back at something I did. Now, I can’t restore my work back to this morning, and I feel like I have lost my work from then to now. Are my automated snapshots, including this morning, going to eventually come back? Since it said when I originally restored, that my work from after Jan. 16 to this morning, wasn’t going to be lost, am I going to eventually be able to restore it? Or is there a way to restore it now?

I’m trying to create a personal goal/habits tracker that updates automatically as I change the status/mark the checkbox. There’s two fields here the name of my goals and the categories I’ve called “subfocus.” The problem is that when I run an automation to my link the record into my tracking sheet, the automation replaces the record instead of adding it. I was going to use a “count” field to tally up all of the completed objectives, but it only gives a single record, it doesn’t update them. Any thoughts on how I can get the automation to add in the record, not update it?

I need to structure something that will help me keep track of and remind me of our weekly Fire Alarm tests, lighting tests and PAT testing etc. Firstly, I need a notification/email/reminder every friday to alert me to do the call point tests. Then a way to record that the call point test has been carried out. A way to make any notes that may be needed in regards to the call point test. A recurring ANNUAL fire drill reminder. (with checkbox/notes etc.) A recurring ANNUAL emergency lighting test. (with checkbox/notes etc.) A recurring MONTHLY lighting flick test. (with checkbox/notes etc.) An Electrical Asset register. A 3 yearly PAT Test reminder. A 2 yearly PAT Test reminder for small appliances. Thank you in advance for any tips you can give to help with these recurring reminders etc.

Hello AirTable Community! I’ve been wracking my brain for hours now so thought I’d see if I could get some infusion of help from the group at large. Basically, I have a base with with a table called “Categories” in it that has 13 different product categories as the name field. I have a second table (in the same base) that has a full list of product names with their associated category. I would like to lookup from the “Categories” table and pull into one field all the product names that are in that category. This sounds weird ( I think? ) but it’s my current solution to an Airtable to Webflow collections sync so that I can have a category collection that still allows me to access product information, if that makes sense. I’ve been successful in linking the tables but this would require me to go through and individually select each item (like tagging?) which is cumbersome, ripe for error, and annoying because the second table will update relatively frequently with new product values

Is ‘loading’ a record the right concept. Up to now I’ve been using lines like: let record = await input.recordAsync("Who is Mum", view); and in my head this has then let me wokr with a chosen record. But now I want to ‘load’ a record from a ‘link to another record field’ and I suspect I’m missing a fundamental point somewhere: My code: let table = base.getTable("Characters") let deadMen = table.getView("Living Males") var deadMansRecord = await input.recordAsync("Who Died", deadMen); let theWiddow = deadMansRecord.getCellValue("Spouse") let theWiddowID = theWiddow[0].id console.log(theWiddow) console.log(theWiddowID) let widdowHome = theWiddow.getCellValueAsString("Nation of Birth") console(widdowHome) and the result when I run it for Albert. Why is my getCellValueAsString(“Nation of Birth”) not returning Germany? Reagrds Neil

Hello! Is there a way to sort tables and ignore articles? For example, if we are using a big list of movie or book titles with the words THE, AN, A before the title.

I added a number of titles and instead of adding them to the bottom of the records, airtable randomly interspersed them into the existing records and linked and unlinked other fields - I need to roll back the base like an hour

Hello, new to scripting, running into an issue on a single line as I hack my way through. Just trying to update script var “totes” to be 10 times the value recorded from the single select field “Pts this week”. So if “Pts this week” has a value of 7, the script var totes should be 70 after this line is what I am trying to accomplish. The line below gives me NAN so I’m doing something wrong on this particular line. If I am not mistaken, NUMBER() should do the trick as the single select value of 7 will be a string if taken as is. Anyway, here is the line. Any help is appreciated. totes = 10 * Number(record.getCellValue("Pts this week")); Thanks in advance

I have 15 different views in the same table. The field named “phone number” is hiden in each view. Is there any way to reveal this field in all views at once? (I guess batch update can’t reveal or hide fields)

Hi Airtable! I have a scenario that creates new records, from one base to another. I created a filter, but it does seem to be working. Did I create the correct filter? Mary

Hello. I’m trying to create a custom application for sending SMS from Airtable. Actually there already exist an app like that Airtable Support Send SMS app With the send SMS app, you can send a list of phone contacts in an Airtable base mass text messages, using the Twilio API. Please note that you need a working Twilio API key to use this app. The se... but for some reasons I can’t use Twilio service. So I’ve got a code from telecom provider which I’m working with, and this code is working when I run it on my own computer, it sends SMS. So I wrote the function in my Airtable custom app with this code, but it’s doesn’t work when I trying to call this function function sendSMS(){ const https = require('https'); const data = JSON.stringify({ auth: {apikey: 'API key'}, data: { message: 'TEST.', sender: {text:'TEST'}, recipients: [{phonenr:'+421XXXXXXXXX'}]

I have a form for a Contacts table that collects specific data. I have another table for Leads that I need to pull this data into. I already have it linked and that works fine. The problem lies when the form is submitted. I would like a way to auto-match this data. For example, the Contacts Table contains an “email address” field. The Leads table is set up to pull the Contact info from the new record into different sort options. As it stands right now, I have to go in and manually link the contact info. I thought that by adding an email address field into the Leads table I could somehow auto-match it. Any ideas? Thank you.

This doesn’t seem to have been asked before, which suprises me. Is it possible to do this? ie use an existing script like a procedure?

My phone application has frozen and is showing an orange screen

Hello Community! I am having a little trouble configuring something in my base that I’m hoping you can help with. Essentially, my team runs clinics in the community (daily, different locations). We have the following set-up: Table 1: Clinic Schedule Table 2: Personnel (organized by staff type) I’d like to figure out a way to assign staff to clinics in Table 1 using a linked field, but in a way that allows a process of elimination - meaning that if somebody has already been assigned to that particular date, they cannot be assigned to more than one clinic. The caveat here is that we obviously need to schedule those nurses for multiple days in a row. Is there a way to set up my base to support this? Thanks in advance!

Hi, I use Airtable to track information for film and television production. I frequently need to sort a list of scenes by scene number, but scene numbers often have letters added to them, which screws up the sorting. Example list, which I would want to sort in this order would be: Sc. Number: 1 2 3 A4 4 5 A5 B5 C5 5 6 6A 6B 7pt1 7pt2 8 A9 9 10 The logic (for those unfamiliar with scene numbering) is that once a script is officially released to the crew, the scene numbers are locked. Then, when scenes are added, they add letters to indicate the scene. So if it’s a scene that comes before scene 6, it would be A6 (and if there are more than one scene added, it would be B6, C6, etc) If the scene is added after scene 6, it would be 6A, 6B, 6C, etc. And then sometimes a scene is split up for production. Often when there is a phone call happening it’s only written as one scene, but when filming, both sides of the call are filmed, so the scene gets split into parts. Ex: 7pt1, 7pt2. And it

Hello everyone? I there any way to merge cells and split cells in Airtable? Like in Word or Google Sheet? I want to combine two cells into one? What can I do?

I tried sharing a view to a group of co-workers, but they could not see live updates unless they refreshed the page. If I shared the entire Base - Read Only, would they see live updates to entries? Thanks!

Hi there, I have a pretty simple question. I have a database that includes some math defintions and in the long text field (rich text enabled) I would like to have for example pi*r^2 as a formula but using symbols. Can I do this in markdown in airtable? Thank you!

Hello community - I’m a week on form ‘Hello World’ as far as scripting (and coding in general) is concerned so apologies if this is basic - one of my issues is knowing correct terms and without them it’s hard to search for answers. I’m creating a script app that adds a record to a table called ‘Characters’. The new record will incorporate some info from other records on the same table so to feel my way I’ve done: dynastyNow = record.getCellValueAsString(“Dynasty”) motherNow = record.getCellValueAsString(“Name”) fatherNow = record.getCellValue(“Spouse”) countryNow = record.getCellValueAsString(“Country”) output.text(dynastyNow) output.text(motherNow) output.text(fatherNow) output.text(countryNow) It all works as expected except fatherNow - which returns: nothing if I use getCellValueAsString and ‘null’ if I use getCellValue. It must be because the spouse field is a linked record field (the others are either single selects or single line texts- how do I interogate the linked record to pr

Hello ! I am deactivating quite manually and inefficiently many forms that have been created on a base by clicking on each one of them and desabling their shared view link (share form menu) Is there a way do it in a faster or mass deactivate forms on a base ?

Hi there, First question in this forum , first of all thanks in advanced to the Community and Developers for such a tool. I have a table that has different rows according to the image I want to select from my links. The images are not directly uploaded but are in Google Drive so I get links such as https://drive.google.com/uc?id=1-6HRbJh-x_ivBbhO5hdanGnlD1K7XCL- I wanted a column to display a little thumbnail with this image loaded. Is that possible? I have tried with Gallery View but seems that I may not be understanding the point. Thank you

So new to this and posted some code in another thread - its’ been pointed out to me functions would save some repeats in my coding and make them easier to read and correct. But I’m missing a subtly - the let instruction within my function results in this error - yet the same instruction (commented out in the screenshot) seems to work just fine - what am I not grasping?

I created a base and shared it with someone trying to access it on a bank computer. Understandably, the bank’s IT infrastructure is highly locked down and as part of that, presumably in their firewall set up, this user is unable to view attachments. She shared her screen yesterday with me and I can see that when clicking on a PDF attachment she can see it for a second but then gets a pop up saying the content is blocked. She can otherwise access the base just fine, so it’s not that they have blocked Airtable.com altogether. And when I have an attachment loaded the URL is still an Airtable.com URL, so it seems there must be something embedded in the PDF viewer code or attachment server that is triggering the block. She’s going to ask her IT people about this but does anyone know if there a URL unique to my base serving the attachments, such that she could ask them about whitelisting just that URL? I’m going to give her the base URL and and see if their firewall can whitelist PDFs fro

I have added 3 collaborator accounts, I have also received a bill and have paid the bill. but I accidentally deleted the 3 collaborators, if I am invited back to be a collaborator in the same workspace, do the 3 collaborators have to pay back?