Other Questions

Hi all, I use Airtable to be the database of my Webflow website (through syncing via powerimporter). One of the important field is a rich text field (a summary for a marketing resource). It’s great that we can include links, but my problem is that I need a link that could be “relative” and send to a specific section of the page (marked with an id like "). The problem is that it seems Airtable automatically adds “http://” to whatever I type ("#example4" in this example). Is there a workaround? Thanks! Sylvain

Does anyone know a script that I can use as follows: 1) take a field that has a string of 10-12 Comma Separated Values (CSV) and 2) randomize the order of those 10-12 values? I’m not a technical person, so I’m sorry if this is a rudimentary question…

Hi Airtablers! We have a lot of helpers from WWOOF & WorkAway. We have a capacity of a maximum of 10 people at a time and I need a good overview to not be overbooking at any time. We have an arrival and departure date, so we can see how many people we have each day in the calendar view. But it is not an easy overview. I would like a chart on a dashboard. But how do I get a count for each day of how many people are booked, so I can make the chart? All the best :high_brightness: James Family in the Forest

We are using SendGrid and want to insert a field into the email. We’re able to do it, but since our field has multiple values, the results are that all of the entries get listed one after another which makes it very difficult to read. Is it possible to set this so that there’s a line-wrap to make each piece of data coming from that field appear on a separate line? Thanks

Hello! Is it possible to change the text color of some fields in the form via e.g. script?

For example, I notice it seems possible to create a table and link a form to it in order to gather the data. What added benefit is there say here to using an MS Form and Excel? I would just like an idea of the potential benefit before investing too much time researching Airtable. Many thanks. PS. For context my job role so use of the software would be for managing and coordinating projects.

Uploaded Excell spreadsheet satisfactorily, but when press Upload, it says ’ An Error has Occurred, Sorry your request conflicted with another change’. This occurred a couple of times with the first Sheet being imported but then it suddenly it worked ok, despite not changing anything. Trying to import into another Sheet in the same Airtable Table it unfortunately just keeps on repeating the error message.

Importing spreadsheet from Excell, Column headings ignored, first data row below Excell column headings are taken as the Airtable sheet headings. Ok headings can be manually corrected in Airtable but as there are over 50 columns, that’s a bit tedious. What might be gong wrong, any solutions?.

Hi all– I have a function that requires a rollup to concatenate values in numerical order. But I can’t seem to control how the rollup is determining the sequence. I’m basically using this type of logic: Either: Display X most recent linked records OR Display all linked record up to a year prior to most recent record - #2 by Justin_Barrett And yes, I want to show the last three records… but the rollup function is aggregating the results in a weird sequence. The result is that it gets the last 3 entries according to the rollup, but it’s not actually the last 3. It sometimes throws an entry out of order, although for the most part the results seem to be as predicted. Hmm.

Using the google sign-on in the desktop app now shows an error from Google: “This browser or app is not secure” and then does not allow logging in Please resolve

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(“

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 = a

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 databa

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 :).