Other Questions

Hi Guys Sorry I am still a newbie and I am having a problems setting up the new button field to send an email to a customer in my base. I have entered the following formula “mailto:” & ENCODE_URL_COMPONENT(Email) & “?subject=” & ENCODE_URL_COMPONENT(Subject) & “?body=“ & ENCODE_URL_COMPONENT(Body) which gives me a problem saying Sorry, there was a problem saving this field. Invalid formula. Please check your formula text. My main email programme id Spark for Mac. The email address I want to send from is a Gmail address. Please can someone let me know what I am doing wrong. Because the button field is new there is not much online to go off

Hi All, Basic question here - we have a lot of collaborators in our Account who all want to use filters concurrently. Whats the best way to manage this? Currently, I go into our table and if someone has a filter on I cannot use the system - definitely something im missing here Thanks all in advance!

Hola, tengo problemas con el login en el móvil, en la PC funciona el usuario y la contraseña y en el movil da error de sesión expirada Ya desinstale la aplicación y reinstale y el problema persiste.

Hello, I am looking for someone to lead a custom Webinar/Workshop for a group of theater professionals. Would take place in late August 2020. I have sample bases that could be used to teach the workshop. Would possible be looking for two sessions- a Intro to Airtable session and a more advanced session. If this is you, please send me your credentials/CV and anywhere else you might have led webinars or workshops before

Can Airtable be made to work like a task manager? I currently use Things 3 as my daily list of tasks to be done that I then ‘tick off’ to clear them from my list. Can Airtable function like this? I’ve been playing with it today and have set up basic stuff, but can’t find any way to create a sort of to do list like my Today view in Things whereby when I tick a task to complete it, it disappears from my Today view (and is stored in the log).

Hey, is it possible to let viewers who are shared the view by link can click button which run scripting block? In my case, when I was logged in as a creator, I can click the button to run script. But when the view is shared, and I tried to click the button as a viewer (not logged in), the button is disable. Because I share the view to my customer by link, and they just watch as a viewer (not signed in), I hope that viewers also are available to click the button running scripting block.

The calendar view in specific table in one of my bases has inexplicably become distorted such that it is impossible to read what appears in the columns for Saturday and Sunday in the month view of a particular calendar. It prints that way too. I normally print this calendar to see all the due dates for my painting commissions, so this has become inconvenient. Other calendars in the same base have been unaffected. I have tried refreshing, logging in and out, switching between day view, week view and back again and duplicating the view. None of those have worked. Has anyone else experienced this? Any ideas on how to remedy it?

I’m seeing references to a charity discount. How do you apply for that? We are a Canadian non-profit and would like to move to a Pro plan but our budget would benefit from a discount. Thanks.

Is there a way to find out which collaboraters were billed in previous months? We are constantly adding and deleting people, and I the invoice we receive does not give exact details of which collaberators we were billed for, eaxctly who was added etc. Please assist.

Hi again, If I share a base from the share button, I have no problems with collaborators who use a mobile app. What I would REALLY like to do is interface with the shareable, read only, grid view link. That works great on the desktop version and even shows up on a phone through a web browser but NOT through the Airtable App. Thoughts? Suggestions? I’d really like to be able to have my non-editor/owner team members have that flexibility when accessing information. Thanks so much!

All, I’m quickly learning the power of Airtable. As I am developing our base, we are creating views that group fields that are relevant to different users. When we do that, Airtable defaults to adding the summary bar with all numerical fields summed. I love the summary bar but it is rare we need those groups to be summed. So I find myself changing most fields back to “none” from “sum.” If I don’t, it provides misleading and/or nonsensical results. Is there a way to update the default summary bar option to “none?” Thanks, Matt

I am sure this is super easy, but how do you write a script to just trigger a webhook “https://hook.integromat.com/xxxxxxxxxxxxxxxxxxxxx”? Thanks for any help :slightly_smiling_face:

Is there a way to: • Export all current Airtable contacts to Google Contacts • For each transferred Google Contact, add a “Label” (it’s a tag) for each selected option in an associated Multiple Choice column. • Sync all future additions and changes made in Airtable contacts to Google Contacts.

Hi I have a set of data in BCP format from SQL Server that I’d like to get into Airtable. It would be great if there was a direct mechanism for doing that but I am guessing there isn’t. So, I really need a quick and simple mechanism for taking that data and converting it to CSV. Does anyone have any experience of doing this? Regards Tim

Hi, Our Typeform integration has been working well until a few days ago when responses stopped autofilling in Airtable. Does anyone know what could have caused this? Thanks Michael

I saw a similar question to this but was not able to get the solution to work. I am creating an inventory base. Column A is the number of days (how often to restock), Column B is the date last stocked, and I’d like Column C to take Column B’s date and add Column A’s number of days to get a new date (when to next order). So if I ordered something on 7/20 and need to order more in 90 days, I’d like the date to reflect 90 days after 7/20. I’ve tried every DATEADD formula I can find. I can’t quite figure it out. My columns are: Date Last Stocked (date) Stock Up Every # Days (#) Date to Stock Next (fx) I currently have DATEADD({Date Last Stocked}, Everything I’ve tried after that results in an error. Would really appreciate some help, thank you!

Today I’m seeing this error on multiple accounts. The failures occur uploading attachments (by URL) with the API and manually. It has similarities to this known issue in that the attachment appears to load into the field and then vanishes a short while thereafter. Anyone else seeing this? UPDATE: And of course, as soon as I posted this, the issue has vanished [again]. All systems are now working. UPDATE #2: Now it is working for manual uploads and failing for API-driven uploads. UPDATE #3: Now both manual and API uploads are working. UPDATE #4: I believe there may be a workaround for this issue, or at least of more precise URL for making such requests into Google Drive for non-native Google Docs artefacts. Here is what I’ve noticed: I discovered that in cases where attachments are pervasively failing from time-to-time, the updates seem to depend on these attributes: Any URLs used for attachments or viewing into Google Drive must be HTTPS; and… The URL for attaching documents must spe

If I add a record to the table using the API, it is not displayed in the list (via the API). There are 5 records in the table. 3 out of 5 added manually, 2 out of 5 added via API. I am trying to get a list of records via the API - I only get 3 records that I added manually! Only gives 3 records via API There are 5 records in the table: Sorry for bad English

I am working on an org chart built using the startup org chart template - my base is available here. I am looking to roll up the salaries for everyone who sits below a certain person in an org chart. Is this possible? For example, I want for Tawana Muro in the org chart below I would want a column that has the salaries of everyone contained in the red box. I need to be able to do this for many different levels – for example, I would also want to be able to know the salaries of all of Bonnie’s reports. If helpful, I have already found a way to get the parent and children of each of the employees and I am able to roll-up the salaries for the direct reports. Each of Bonnie’s 4 reports make $100k per year, so you can see that the rollup in column “Children – Total Salary” is $400k total. For Tawana, she has 4 direct reports whose sum is $420k total. The issue that I seem to be running into is that I need a column summing each of the different “levels” of the org chart otherwise salaries a

Hey everyone, I’m running into a problem adding .ics attachments to an email from an Airtable to Outlook zap. Background: I created a form for an event with different sessions, people can choose up to 10 sessions in the form, and it’ll send a custom schedule with their picked events through Outlook, I formated it so the sessions they don’t pick just look like free space in the schedule, but are still technically present in the zap. Originally I planned to just have the links to the video chat for each session, but the client would like those replaced with an outlook calendar event. I tried adding an .ics file as an attachment in AT, and then putting that into the Zap, but it doesn’t work. It doesn’t look like a multistep zap would work since they want different events for each session chosen, which can be random. Does anyone have a suggestion, or is this not possible? so I guess the basic question boiled down is: how do I add an .ics file, or other outlook calendar event option, to an

Hello! Does anyone know how to add a table to a block for my Dashboard?

Im having trouble searching on mobile. When I scan my barcode with a 5 digit number, it puts a space after the number. Without the space, it finds the item, but with the space I get no results. It works fine on desktop and I have a similar table in another base which does not do this. the new base I started with the “inventory tracking” template. Any ideas? is it a settings thing? Any advice would help. Thanks.

Hi, I have an accommodation business, I am trying to calculate a due date for the final payment which is based on the number of days (generally 60) prior to their arrival date. I appreciate any assistance. Thanks!

If there a way to write a formula that queries, basically, IF value X is in column C OR column D, then Y. I just want to be able to filter a base to show only the records where a Name appears in either one of two columns, if that makes sense. I wish the filter options weren’t by default AND, and could show all records that meet one of two filter conditions. Am I overlooking an easy way to do this? Javier

My base is designed to track testing results across multiple applications. All application testing results are housed in a single table with a column to identify which application the test results refer to. We have testers in the field that complete a test form for each test case which writes back to the results table. I am able to create grid views to show the results for each different application. I’d like to create form views on each of these grid views. When I try to limit the record selection to a view, my only option is the standard Grid view. My newly created and filtered grid views are not listed as options. Any suggestions?