Solved

Hey there, looking to create a simple slug and for some reason the apostrophe isn’t being removed. Example Title: Zoom Fatigue is real, so let’s deal with it. So make lowercase, remove apostrophes remove commas, remove full stops and replace spaces with dashes (etc) is what I’m after. LOWER( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( {Name}, "'","" ), ",", "" ), ".", "" ), " ", "-" ) ) I cannot fathom why the apostrophe is not being removed. I’m missing something easy… ideas?

Hello, Currently, this is the formula in the column to make it display the date of the upcoming Wednesday, but the times are random. I want to make the times in this column to all be 7:00am. Is there anyway to do this? IF(3-WEEKDAY({Submitted at})<=0, DATEADD({Submitted at},3-(WEEKDAY({Submitted at}))+7,'days'), DATEADD({Submitted at},3-(WEEKDAY({Submitted at})),'days'))

Hello! this is my first time using the scripting block and first time trying to use an API with code (I’ve used lots of no-code tools in the past; Zapier, Integromat etc.) I want to use a text field in my base to create a ‘tag’ in Toggl using the Toggl api; The Toggl API documentation looks good, and I think I understand most of it, but I don’t know how to actually start - what is the first think I need to write? All the toggl examples start with ‘curl’ e.g. curl -v -u 1971800d4d82861d8f2c1651fea4d212:api_token \ -H "Content-Type: application/json" \ -d '{"time_entry":{"description":"New time entry","created_with":"API example code","start":"2012-02-12T15:35:47+02:00","duration":1200,"wid":31366}}' \ -X POST https://api.track.toggl.com/api/v8/time_entries Is this what I would paste into the script editor? I assume I need the toggle api url somewhere ( api.track.toggl.com) so the script knows where to get/post the data but I don’t know where or how to add this url. Can someone plea

We can duplicate bases in pc, but is it probable in iphone?

We have a requirement like below. e.g. Consider a table with column as Names. Names abc xyz abc pqr pqr We want two columns in another table as below. UniqueNames NamesCount abc 2 xyz 1 pqr 2 Is there any way to achieve this?

Hello~ Airtablers~ Is it possible to set permissions to view and edit only a few specific tables in the base? For example, there are 5 tables in one base, and I want my collaborators to be able to see and edit only one table out of those 5 tables. Is it possible?

I have three fields like this: | Start Date | Billing | Next Billing | In the Start Date field, there’s a past date In the Billing field, there’s a dropdown list with the values “Monthly”, “Quarterly”, “Semi-annually” and “Annually” In the Next Billing field, I want a formula that calculates next billing date based on the values in the two previous fields. Next Billing should always be a upcoming date (or today). Examples: If Start Date is “2018-01-01” and Billing is “Monthly”, I want Next Billing to say “2021-09-01” If Start Date is “2020-06-18” and Billing is “Semi-annually”, I want Next Billing to say “2021-12-18” If Start Date is “2016-10-24” and Billing is “Annually”, I want Next Billing to say “2021-10-24” I have tried to do this myself but I can’t work out how to do it. Can someone please help? Thanks! Airtable Next Billing Problem - Airtable Explore the "Next Billing Problem" view on Airtable.

I have created a gallery view which I would like to share with my collegues. They should only be able to view, add and delete records (not configure the view or anything like that). How do I accomplish that?

Hi! I have a field in Table A that links to another field in Table B. How do I prevent a linked record in Table B from getting deleted? Shouldn’t I at least get a warning? Thank you!

Hello, I am using this formula to display a red circle if a character count is over 310, or a green check if its not. I would like to add another condition but cannot get the syntax right, any help? I would like to add a 3rd condition, so if it is over 260 but under 310 it has a third symbol… LEN({Description}) & " " & IF(LEN({Description})>310, “ :o: ”, “ :white_check_mark: ”) Thanks!

Hello. I am trying to sync Airtable with Google Calendar. In the form of “Add” the URL of Airtable’s “Calendar view” to Google Calendar. However, there was one minor problem. Airtable’s “Date” field now selects Date format and Time format, no more options. However, it would be better if there is a “predefined” time slot for Time when actually entering Airtable’s Date. (For example, 10:00/14:00/19:00 or 10:00-13:00/14:00-17:00/19:00-22:00) Creating a “predefined” time slot like this is " Single Select Field", but this field cannot be used in Calendar View. Of course, I know that it is possible by using an automation tool such as Zapier or Integromat, but as much as possible, I try to subscribe the URL of Airtable’s “Calendar” as it is to Google Calendar. In short, is there any way to use predefined time slots in “Date Field”? Or is there any way to use “non-date” field in “Calendar view”?

Hi, I have two linked record columns. Our users use a custom app to link records to these columns.,I don’t want the users to link records directly from the columns but instead use the app. since we cannot restrict permissions to a column, is there a way to open the app when someone makes changes to a column? I am thinking an Automation when the record is updated and open the app from Autmation? Thanks in advance

Input.fileAsync force change ID to Date. //read csv let latestStock = await input.fileAsync('Please CSV', { allowedFileTypes: ['.csv'], } ); console.log(latestStock); ↑It’s true ID"0002-3". But Date format. If Do you know resolve. Please teach me.

Hi everyone! In a client’s base, they have a form where applicants essentially fill out a job application. Applicants upload their resume, and then I have an automation set up that pushes their demographic information into a “Contacts” table and the job-specific information, including their resume, into an “Applications” table. This works perfectly about 90% of the time. Seemingly randomly, some resumes aren’t appearing in the Applications table. When I look at the record history, I see this: Why would the automation add the resume only to immediately delete it? Has anyone run into this before?

Hello, I am trying to write an equation for total pallets used. If the total cartons is over 4it gets palletized. My equation is IF(Cartons > 4, ROUNDUP(Cartons/{Cartons per Pallet}), 0). but Airtable wont accept it. Any advice?

Trying to create a formula that adds x number of business days if priority is x. This is what I have so far: IF(Priority=“High”,WORKDAY({Writer Assignment Date},3, IF(Priority=“Normal”,WORKDAY({Writer Assignment Date},5, IF(Priority=“Low”,WORKDAY({Writer Assignment Date},10)))))) It accepts this formula, but populates with an “#ERROR” in some fields and blank in others. All fields have the required selections. Trying to create a due date field that is customized by priority. If it is high priority for instance, the person would need to complete the assignment within 3 business days by that date.

So I have a table with a field Client that references a record from another table. Client column as such can contain a value such as ['rec1234abc']. Now I want to do a filter to return all records that reference a specific record. I tried this (using the Python client): my_table.get_all(formula="ARRAYJOIN(Client, '')='rec1234abc'") But that returns me no results. How can I accomplish this?

In Automation “Find Records”, only 100 records get found for the subsequent action. What are the work arounds for updating more than 100 records?

The Vision App requires an API Key. The API Key is visible to all collaborators. Google specifies that API Keys should not be exposed in code, as this is a security problem. I attempted to “restrict” the API so that I could at least limit usage to airtable / vision. But I got an error related to OAuth. Am I misunderstanding something about the potential security implications? Why would this app be designed to keep the API exposed? Thanks for any advice!

Hi, any idea why is Vega-lite displaying the last month July 1 2022 of my table as the first month in my Chart, even before June 1 2021 ?!! this happen with whatever Date I start the table on. It looks like a Bug (in Vega or AT) to me, displaying the last month before the first one… Anyone facing the same issue, Thanks ! See code used { "$schema": "https://vega.github.io/schema/vega-lite/v4.json", "title": "Debug Test Chart ", "width": "container", "height": "container", "mark": "bar", "encoding": { "x": { "timeUnit": "month", "field": "DateTest", "type": "nominal", "sort": "x" }, "y": { "field": "VALUE", "type": "quantitative" }, "color": { "field": "NAME", "type": "nominal" } } }

Hi there, I want to add a formula to result in a date. I have a delivery date column. and I want formula to calculate a date 7weeks (49 days) before the delivery date. I have this working in Excel & numbers, but copying the formula into Airtable does not work - results in NaN. Please may you help. Thank you, Sally

Hello I have converted an Excel spreadsheet into an Airtable base. In excel, I have columns that are formatted to show [month] & [weeknum] based on a date that is entered. Is this possible in Airtable? Kind regards, Sally

I have a table containing a PostCode column, and Address columns 1 to 6, all of type “single line text”. I wish to know which of the columns contains the PostCode and will use SWITCH(PostCode,Address1,1,Address2,2 …). However even when I can see which column contains the PostCode, let’s say Address3, a formula of PostCode = Address3 is returning false, when it should be true as they appear equal. Adding LEN() to both sides of the formula confirms they are the same expected length. The values I see in both columns appear identical. This behaviour is not the same in a table created with just these 2 columns and the values manually input. What differences in the values could there be that is not visible and how might the difference be eliminated?

I have a formula that’s doing what I want it to do. But I’d like the field {ACTUAL VALUE} to be currency formatted like {EST. VALUE} - I’d also like to get a SUM at the bottom of this column, so I need it to be a number. This is what I have so far. IF(STAGE="Executed", {EST. VALUE},"") What do I need to add? Thank you so much in advance.

Hi - please help, bit confused. I published a base up into the Airtable Universe (and luckily saved the link for it). If I search the Airtable Universe, I can’t find it anywhere. Any idea what’s going on? It’s a LinkedIn SSI Tracker (your Social Selling Index score on LinkedIn). The Universe base can be found here - but you cannot find / search for it via the Airtable Universe page. Any ideas? I’m presuming that nobody else can find / search for this? Here’s the direct link (to prove I’m not going mad :slightly_smiling_face: ). Airtable LinkedIn SSI tracker (Social Selling Index) - Airtable Universe Did you know that LinkedIn gives you a 'score' that determines how popular and visible you are on LinkedIn? It's called the Social Selling Index (SSI). If... It is real… but not searchable…