Other Questions

Hi, I have a M query below which works fine in Power Bi Desktop but fails in Power Bi Service due to Query 1 Dynamic Source Refresh error. I understand that I need to add amend to add a Relative Path to make this work but after numerous attempts am now stumped. Any suggestions please? let Pagination = List.Skip( List.Generate( () => [Page_Key = “init”, Counter=0], // Start Value each [Page_Key] <> null, // Condition under which the next execution will happen each [Page_Key = try if [Counter]<1 then “” else [WebCall][Value][offset] otherwise null, // determine the LastKey for the next execution WebCall = try if [Counter]<1 then Json.Document(Web.Contents(“https://api.airtable.com/xxxxx”, [Headers=[Authorization=“Bearer keyxxxxxxx”]])) else Json.Document(Web.Contents(“https://api.airtable.com/xxxxx?offset=”&[WebCall][Value][offset] , [Headers=[Authorization=“Bearer keyxxxxxxx”]])),// retrieve results per call Counter = [Counter]+1// internal counter], each [WebCa

Used the page designer to do an 84-page presentation to a client. Then tried to save this presentation (single pages) as a pdf using Mac (running Catalina). It initially created a pdf but then gave an error message when I tried to open it saying I needed to “Save as Adobe PDF” because the file was corrupted. When I tried again and saved as Adobe PDF nothing happened. Every time I try the Airtable app screen goes black or freezes and I have to force quit and start over. ADDENDUM: I am able to create a pdf in the web version of Airtable, just not when using the app. Additional question - is there a way to retain live links.

I get this exception: Exception thrown: ‘System.Net.Http.HttpRequestException’ in mscorlib.dll An error occurred while sending the request. - System.Net.Http.HttpRequestException The program ‘[10796] Test.vshost.exe’ has exited with code -1 (0xffffffff). The code of Airtable.net in github is at link: GitHub - ngocnicholas/airtable.net: Airtable .NET API Client The code I wrote for using of Airtable.net APIs: private async void GetRecord(string id) { using (AirtableBase airtableBase = new AirtableBase(appKey, baseId)) { Task task= airtableBase.RetrieveRecord(appTable, id); AirtableRetrieveRecordResponse response = null; try { response = await task; } catch (System.Net.Http.HttpRequestException ex) { Console.WriteLine(ex.Message.ToString() + " - " + ex.GetType()); //throw; } if (!response.Success) { string errorMess

Super newbie question, but hoping someone can help! I have a table with about 15 fields. I would like two of these fields (full name and email) to be synced to a DIFFERENT table, so I can easily export to CSV these two fields ONLY for email newsletters. What is the easiest way to do this? Thank you!!

For the past few days, I have been trying to upgrade my account from Free to Pro. However, whenever I click on the upgrade button, I get the “An error has occurred message”. I need to urgently upgrade to the Pro plan, I have already send out numerous requests to the support team, but to no avail - does anyone know how to fix this?

Please read and consider. There are NO iPhone apps that do this. Can Airtable be designed to perform this ? ----/ I would really like to have a new shareable, cloud-based, private , encrypted iPhone contacts app that has these major points of functionality. Ability to share the app itself and its contacts a. Share the app to a family group b. Share the app to members of a club, or to specific employees c. Share its online, encrypted database of contacts to those in these groups d. This online contacts database would be completely separate, standalone from all the other contacts databases (Gmail, iCloud, etc). e. Possibly import from other Contacts to this contact database. f. While I personally would like a iPhone contacts app so that I can share people, companies, and facts to family members, I believe that many organizations would also desire this capability. Security levels a. Each contact in the database would have a clearance or accessibility level. b. There would be several

Hello how are you? I work with lead capture and a lead has 2 types of registrations. Simple registration with name, email and phone; Complete registration with simple and other information such as age, sex, profession and etc; By default, the capture is only with simple information, but I would like to create an automation with the Record URL for the lead to complete the registration. I saw some prefill form solutions, but when testing, I saw that a new record is created, I would just like to ‘complete’ the lead’s unique record.

Hi, Am new and wondering how to share projects in between several companies: partners: read/write suppliers: for comments customers: read only Is it possible and how it works for the billing? Thanks for inputs Serge

as a user of airtable for personal and professional life i need to set up an alert or email to remind me of projects or tasks i need to submit ,can anyone give me a clear guide how to do this?

Has anyone created a subscription website around content stored on airtable? If so, can you provide details? Mark

This seems like it should be intuitive but I can’t find the info. I have a field with two lines of text, formatted as “long text.” I want to convert that field to “multiple select” so that each line of text becomes an option. However, when I convert, only the first line of text remains. How can I retain both Item1 and Item2 when converting?

I would like to use scan barcode feature in Airtable. I created a form and shared the “shareable” link of the form with another person. But he was not able to scan a barcode with the link on his phone. Only if he logs in to the app and I make him creator or editor, he was able to scan a barcode. Is there a way to make it work with the link because I don’t want to share the base with him.

Both yesterday and today, I’ve had problems with AirTable freezing up, and being unable to update records etc. The program does not respond to keystrokes ad I have to force-quit to get out of it. Anyone else having this? How do I fix this?

I’m absolutely loving the vega-lite app. Any chance we can get upgraded to vega-lite v5?

Quick question. I have a series of classes and I’m trying to display as well as track multiple time zones as our courses are led by different instructors across various timezones, so we list all three that we deal with. What would be the best way to deal with this(also so that Google Calendar will recognize it) Right now I just have them set up as text fields. Is there a way for it to display timezone based on the user’s(like myself) ? I want it to show up in a calendar properly in my time zone(PST). I’ll just let the pic show you what I mean :).

Hello - I’m new to Airtable and having trouble configuring a custom date field. I would like to have a date field with MM-YYYY format (01-2021). This is for a large dataset and records do not have a full dd-mm-yyyy date available (only month and year). Is it possible to create a custom format for the date field type? Thanks in advance for any tips.

Hi! Our team uses a collective base for task tracking, but folks are interested in being able to house both those tasks and their own separate to-dos in a separate base. Our initial thought was to have everyone create an individual base that would pull in their to-dos from the team bases via a synced table, but the issue is that they are then unable to add additional records to those tables for their own personal to-dos. Any suggestions?

Hello, I’m building a table to track sales and inventory. Each product has a number of components, and sales/resupplies impact the total inventory of components. For instance chair 1 = 1 wood structure + 1 leather canvas chair 2 = 1 wood structure + 1 velvet canvas So a product can have multiple components, and a single component can be found in different products. I think this qualifies as a many to many relationship, as explained by the airtable guide. I built a quick prototype, and managed to do so without using a junction table, and it seems to work just fine. Why is that? By bypassing the junction table, am i missing something that might become a problem down the road? You’ll find the table in read only here: Sign up - Airtable thanks cedric

Hi, I have been having troubles with the ‘rollup’ field function. Every time I use it, it gives me this error message: Sorry, there was a problem saving this field. Invalid formula. Please check your formula text. Some context: As you can see, the field all the way to the right is linked with the other table: The second table is a feed of forms being submitted. In those forms being submitted, I want the “flight time” (duration field) to add up to the Flight time field in the first base, which is not working due to the formula being ‘invalid’. Thank you in advance.

I used Zapier to create a connection between freshbooks and airtable. Every time a student pays their invoice it automatically updates the record in airtable to list them as “paid”. However the field is a drop down with two options - paid and invoiced. After I sent data through Airtable the single select field now has paid twice! What am I doing wrong? “Paid” is spelled exactly the same way in Zapier and Airtable

I am trying to create a mentor request form & table for our community and I haven’t been able to figure out the setup to meet our requirements. Here they are: There will be a mentor request form that is sent out to all users in our community asking them to select an available mentor from a dropdown list. available means that the mentor has less than 2 mentor requests in the current month We would then keep track of mentor requests and close them as they get done How would one go about setting this up? Thank you for all your help!

Hi, I’m using airtable right now for some research - and I’m looking for a way to smartly collect notes, comments, observations, trends about a specific question in my dataset. Use case: 20 colleagues responded to my survey Question B asks for hobbies, multi-select, keywords the result will be 50 different keywords, approx Now I would like to go through the column B, check through the responses, identify trends, clusters etc. In the moment I’ve just created a fake dataset #1 to take notes in – but that doesn’t seem like the right way to go. Any suggestions how? thanks

Greetings Team, OK - Airtable Date Time values are confusing the daylights out of me. I do realize that Airtable likes to present datetime values in local timezone but to run incorrect math by using incorrect hours in GMT, even when we’ve explicitly set the values to local. What I can do in Excel in literally 1 minute has taken me hours and I’m still lost. For example, TODAY() with 24 hours turned on shows up as 3/4/21 16:00. Why 16:00 when I’m in PST? Today() should be set to the start of today at 00:00, no other random number will do. OK - then I try with the crazy SET_TIMEZONE examples (just to get today to behave). DATETIME_FORMAT(SET_TIMEZONE(TODAY(),‘America/Los_Angeles’),‘DD/M/YY HH:mm’). The result is still 3/4/21 16:00. My problem is that these random hour shifts mean that orders placed on 2/16/2021 at 8:52 am are being treated as placed on 2/17. I’ve tried the DateAdd formula and subtracted hours only to realize that Airtable doesn’t take the modified values. It’s still worki

Hi, I’m having a problem regarding data transfer from my Google Form to my Airtable account. Previously, when I’m doing testing, all the data can be transfer. After few times of testing, suddenly, none of the data been transfer to my Airtable account. Is there anything that I shouldn’t click but I clicked ? Please help me. Thank you in advanced.

I am using ZZbots to populate Airtable from a Google Sheet but I am having 2 behaviors: a pizzas field contains the list of pizzas for a given event. This field is populated wih up to 8 pizzas recipes that are comma separated Behavior 1: Airtable picks up the list an automatically split each pizza and link it to the correct linked pizza recipe from another table Behavior 2: Airtable does not split each pizza and considers the whole pizza list as a single recipe Any clue what’s going on?