Other Questions

hello guys, i am looking for this apps to manage my several projects. i proposing to use table as my “portofolio” and use category as my “project”. I am little bit confusing how to add more category within the table. maybe some of you willing to share your experience in using Airtable to manage several projects and oversee project statuses in a glance. thanks you

I am maintaining a contacts CRM database for my supervisor in Airtable. We imported LinkedIn contacts, however, now with everyone changing jobs, the companies and positions are not updated. I attempted to download the connections from LinkedIn and then do an Import CSV merge so that the contacts can update. Zapier does not have a linkage between LinkedIn and Airtable for this kind of trigger. However, my supervisor has many contacts that have similar last name, first names that are repeated. The Last Name and First Name columns were originally separated, I then tried to combine them with a formula into a new column. When I import the CSV file and try to find the drop down menu for merging, the new 3rd formula column is never available. (I had already formatted the CSV file to have a “Last Name, First Name” column with a space between the comma, etc.) So the CSV cannot find the right columns to merge with. Since there are 1000+ contacts, I did not want to copy and past

Is it possible to access the Base View after clicking on a View only link? In other words, if I send a “View-Only” link in an email blast to people in and outside of my organization, is it possible for a collaborator to click on the view only link and then easily proceed to the same View in the Base? I am thinking of a handy “Go to Full View” button that if clicked checks the users credentials and forwards them to the View in the Base. If this doesn’t exist I’ll move this to Product Suggestions. Thanks!!

Hi Airtable community! I am working on a table that inputs schedules for our contractors. Their schedule is then linked to their dedicated record in our database. An issue arises when they schedule for next week before this week due to the sorting of the linked records. I found a way to sort linked records by the week they’re scheduled for by placing said week in the name of the record that we are linking. I can then order these by the week using the Batch Update block. So that solved my problem, now the issue is that the Batch Update block needs to run every time a new record is inputted into the schedule table. In essence, is there any code I can write in the scripting block that will automatically trigger when a new schedule is inputted that will trigger to run the Batch Update block?

Hi everyone, Having issue embedding my ‘view’ on a Carrd landing page: https://freshtradecaribbean-logistics.carrd.co/ This is the URL link I’m trying to émbed: https://airtable.com/shrXf1BLuH4TomVwP Any advice? Thank you!

My team uses the dedupe block quite a bit. When we open the block, the fields are displayed in a random order. They do not appear in the orderI have them in my table, nor are they in alphabetical order. It would make more sense if they appeared in the same order as they are in the table. Does anyone know how to do this? Thanks in advance for your help!

I’d love help on this. Having trouble with the attachments in Airtable at the moment, so I would love to preview the attachments in either a block or open in new tab (not download). Preview URL doesn’t work as the links are not proper format (Jotform/Zapier Uploads) and we would like to preview resumes without downloading to computer. If there is the basics of a script somewhere, I would take that too! I just need a quick save for this one as the attachments aren’t working and it’s holding up processes. Ever appreciative of any help! Jen

I’m having trouble viewing more than the Title and Date on my quick view while selecting an item on the calendar. Image for reference: How do I add an additional field to view so I don’t have to “Expand record?”

We use Airtable for our own campaign planning, but also have partners that use Airtable for various other reasons. They don’t have shared workspaces or bases, but they use the “share” link (see 1st screenshot) to provide visibility into certain views. Screenshot #1: My question: is there a way for me to save their view somewhere in my Airtable home? I have the view bookmarked in my regular web browser, but it would be awesome if there was a place I could store specific shared views somewhere within my workspaces? I know I could do something with blocks or in a different table or something like that, but it would be great if, just like workspace and block organization, there was also somewhere I could save shared Airtable links (see 2nd screenshot). Screenshot #2:

Yesterday 6/4/2020 a new view chooser (not sure what to call it) popped up. It used to be a simple drop down box which worked fine. Now I have this side panel that pops up and stays there. I hate this… I hate all extra mouse clicks, now have have to do extra mouse clicks to hide this. Any way to disable this?

Is it possible to create a new table programmatically When the table reaches 40,000 rows or when a week has gone by? I don’t want to click anything to make it happen. Planning on doing this for a lot of clients. I can do it in google sheets but I’d prefer airtable.

Hi Airtable fam, I’ve tried everything at this point… After banging my head against the wall for a full two days, I decided to stop being a dummy and ask for help. Full disclosure… I am a complete novice on Airtable, having just started to interact with it about a week ago. In essence, what I’m attempting to do is: Retrieve all the records of one table (exercises) Filter by two metrics (match difficulty of the exercise with a “difficulty selector”, + or - 1 on a different table, AND make sure the required equipment for the exercise matches what the user has, again, on a different table.) Paste the RECORD IDs of the exercises that pass the filter into a field in another table (there are usually about 20-30) I’ve been able to get pretty far down the road on my own using Integromat. The only step giving me grief is step 3… Here’s what my Integromat scenario looks like: Airtable - Watch Records

Hi there I need some help on how to configure dates in BC/AC thanks

I have a users table which has a user_id and points field. I have a points_events table which logs each time a user_id receive points for an action I need the points field in the users table to sum the total points associated with that user_id from the records in the points_events table. How can I do this? I need it to be as automatic as possible. Thanks for any help you can offer!

Their must be a way, but I am banging my head trying to figure out formula :frowning: I have a form that asks for First & Last name that goes into an Airtable Grid View, which then is grouped by First & Last Name. Problem is, when someone changes the format or accidentally adds another space when submitting a new form it gets sent to a new group. Example - “John Doe”, " John Doe", "John Doe ", “john doe”, etc… all get sent to different groupings. I am trying to covert all formats to “John Doe”. Thanks for any help!

We need to sporadically export PDFs from our Airtable in order to make these PDFs downloadable by users of our own app. We are using the Page Designer block to create the layouts, but we want an automated solution to export these layouts as PDFs, because the only other way is to “print” the Page Designer block using browser print and then “save as” a PDF. This is time consuming. Currently it looks like the best solution for us is to use the MiniExtension “PDF and Document Generator for Airtable” coupled with Docupilot to be able trigger batch PDF exports: https://miniextensions.com/airtable-generate-pdf/ Please note, this method does not need the Page Designer Block Also, this method will cost hundreds of dollars because we will have thousands of PDFs. Do you agree? Is this the best way? Is there an easier way, perhaps with the Airtable API? Ideally we would

Hello, I am new to airtable and i have a challenging task. I am using airtable as a CRM for my business. We want to create a view for records (Leads) with created time between 08:00 PM and 09:00 AM The reason for doing that is because i want to use this view as a trigger for zapier. I could not find any available filter that handle time of the day. I have already created a column that show only time of the day by using the below formula: DATETIME_FORMAT({Date Of Creation}, “LTS”) Please check the image how this data can be used to filter certain time? Thanks in advance for any support or advice on this. Regards,

Is anyone else having an issue/glitch with the Description block, where the curser keeps jumping to the top of the page while you’re typing? It’s very annoying… I hope I am not accidentally hitting a shortcut key, but it keeps happening? I’m using a Lenovo PC.

I have been perusing the community forum and topics trying for hours to create a new date in a field for 6 days out by using a different date field as the base number. For example, I have a field named ‘Lead Mag Date’ where the date is input manually. I would like another field named ‘Day 6 Call’ to automatically populate the correct date for 6 days later. (i.e., Lead Mag Date 7/14/2020; Day 6 Call 7/19/2020. Here is the formula I was trying to create: DATETIME_DIFF({Lead Mag Date}TODAY(),‘days’) + 6, {DAY 6 CALL} = ‘MM/DD/YYYY’) Any suggestions? Thank you for your help. It is much appreciated.

My organization is in the final stages of determining a project management tool to use. While I love everything Airtable has to offer thus far, a critical need for our organization is the ability to have a “portfolio” or “Executive” view of all ongoing projects etc. I know that this can be done within a specific base, such as “project tracker” by using the blocks feature, however, I am curious if this can be done across multiple bases. For example if i wanted to present to a board of all the updates from the last month, i would like an easy to read one page document with visualization to show the number of social media posts alongside all of the ongoing projects at a high level overview. Is there a dashboard view to create a high level overview across all bases? I have provided a sample image of what I am looking for.

What’s the best way to do a simple analysis of data? One of the most basic things I want to do is count the number of records that match a set of filter criteria.

Here is a simple clipper intended to be used with YouTube to pull basic video info { "schemaVersion": 3, "fieldMappings": [ { "fieldName": "Video Title", "fieldType": "singleLineText", "defaultValue": { "type": "cssSelector", "opts": { "cssSelector": "h1.title" } } }, { "fieldName": "Video Description", "fieldType": "multilineText", "defaultValue": { "type": "cssSelector", "opts": { "cssSelector": "#description > yt-formatted-string" } } }, { "fieldName": "Video URL", "fieldType": "singleLineText", "defaultValue": { "type": "pageUrl", "opts": null } }, { "fieldName": "Video Duration", "fieldType": "singleLineText", "defaultValue": { "type": "cssSelector", "opts": {

I’d like to use a Kanban style view for assigning categories to items, with the categories being values in another table. The items I want to sort are Organizations, and I want to sort them into career interest areas: e.g. Tech, Government, Design, etc. These Interest Areas are in another table, and are a linked field in the Organizations table. If I group the grid view by Interest Area, I can’t drag and drop the orgs to categorize them. I’d really love to do this in a kanban view - it’s easier to drag and drop items. But when selecting a group by field it doesn’t seem to allow me to use a field from another table, even if I set the field to only allow a one to one relationship. Any other ways to do this that I’m missing?

As the owner of our Airtable database, I get automated email messages when a collaborator adds a record. The message begins with, “Someone has responded to Add a player. A record has been added to the Players table in Directory.” I’ve confirmed that I get those messages when someone adds a record but I don’t know if I get automated email messages when a collaborator updates a record. Can someone here confirm that I should or should not expect to be informed when a collaborator updates an existing record?

Hi there, I have a question about files being deleted from records by an anonymous user. We have our Final Information records, which is made when someone fills out a Final Information Form - in the form people fill out their information and upload files of relevant documentation for us. When a user submits the form, it says “Anonymous submitted via form” since they are not logged in, and it’s not possible for them to edit the form afterwards. But then I can see in the history/timeline on the right side, that files/documents have been deleted with the caption “Anonymous edited this record”. As mentioned, it’s not possible for the person to edit the form after it has been submitted. Can you please help me understand how these files are deleted? It causes a lot of trouble for us since we have to reach out to these people and ask them to send us these documents again. I have attached a screenshot of the timeline. Thank you in advance Emma