Solved

I have a list of tasks in my table and a date range for each task. The date ranges are entered into two different columns, Start Date and End Date. Each of those are formatted as dates. I’d like another column to list all the months that are included in that ranges of dates. So for example, if Start Date is Jan 1, 2020 and End Date is April 30, 2020, I’d like the Months column to list Jan 20, Feb 20, March 20, April 20. Is there a formula for this?

Happy weekend all! So I have built myself two awesome automations: Creates 10 tasks for each record added Email me the list of ‘tasks’ for each new record added So when I ran the 1st automation it ran flawlessly! It was #2 that boogered me all up! It sent 10 emails for each new record… each with all 10 tasks listed beautifully! PROBLEM/OPPORTUNITY: The issue I am running into is that the 1st automation is running from where the new record lives. I found that if I add the ‘send email’ option with the same trigger, it emails an empty list (I’m guessing because it is sending the email before the list is populated). I’m sure this is an easy one, but Its been a loooong week already. As always, thanks for your time! DG

Hi there, I need to calculate the difference between the {Date} and today in days, and display “todo” or nothing if the number of days is >1. I tried this but I keep having errors : IF(DATETIME_DIFF({Date}, TODAY(), ‘days’)>1),“To do”, " ") Any ideas?

Hey y’all – I am working on a local school board campaign and looking to map both the precinct locations in our district as well as our yard sign locations to make sure we’re balancing visibility across the district. I’ve got a Precinct table with address, # of registered voters, # of voters in our universe, etc. as well as a Signs table with address, location type, sign size, etc. I’ve already created an Map app block to display sign locations which is working great, but I’d love to pull in the precinct locations onto the same map block so that we can visualize around those locations. Is this possible? Suggestions on how to do it? My clunky workaround is that I’ve just been adding the precincts in as sign locations and making them a different location type and color coding the markers, but I’d love to have a cleaner experience that maintains the precinct name from the precinct table. I might be overthinking, but would love suggestions!

Hello, I am trying to work with three levels of categories that each have their own totals. This is the way they should work. The top category has a sum of all the sub- and sub-sub categories, the secondary level sums itself and the tertiary categories. I realize that this is simple in Excel but it seems as though it might work with some linked fields. I have a budget entry table where you can select the three types of categories for each record, as applicable, And then I have tried various scenarios to get something similar to this table that has an overall total for the first category. Are there better ways to try and do this? Thank you for any help you can give!

I’m trying to workout a formula to identify a text field that starts with “The”, or “A”, and move the “The” or “A” to the end of the text string with a comma. So if the field said The Blue Book, I want it to say Blue Book, The Or at the very least I want to delete “The” or “A” from the start of the text string, but not from Elsewhere in the string. Can anyone point me in the right direction?

Hello :slightly_smiling_face: Need help with the Attachment field, please. For some time now I use the attachment field to store images, and I had “show attachments in reversed order.” option toggled on. Now, I want to toggle off “show attachments in reversed order.”, but keep photos in same order. How can I accomplish that without doing it manually, since I have a loot of files and reccords? Thank you, Pjero

Hi all! I’m new to Airtable and trying to figure out how to pull multiple variables out of a single long text field. I’m pulling the Description from an event in Google Calendar and syncing it into a Description field in Airtable. This field will have some things defined in a predictable pattern, such as the Zoom URL, name of the presenter, etc. - each corresponding to a field that exists in Airtable. What is the best way to set this up to be parsed through in Airtable? Is there a tutorial out there that could point me in the right direction? Feel free to suggest something else if I’m going about this the wrong way. Thank you!

Hi there, I am creating a participation tracker that I can use for an upcoming project. The concept: There are 10 different groups, and each group can have 3-10 members. One “leadership” group contains at least one member from each of the other groups, so theoretically each member can belong to up to 2 groups. I have used a many-to-many relationship to link members to groups. Here is what I have: A table that lists all members with their group(s)(& other pertinent info) A table that lists all groups with their members (& other pertinent info) A table that lists all meetings with the members that attended and their group(s) as a lookup field A table that lists all emails and phone calls with the member they’re with and their group(s) as a lookup field What I need: identify how many times a group has participated in some way (meeting, email, or phone call) identify which groups did not attend each meeting identify how many meetings a group has attended A group “attends” a mee

So, a co-worker is leaving our company and she’s set up some Airtable workspaces for her duties. I’ll be helping to train her replacement and am considering moving my collection of Google sheets over to Airtable at the same time. There are some stumbling blocks I’m trying to work through that I don’t have answers for yet and I’m hoping some of you can point me in the right direction. Mostly the issues are coming from importing existing Google Sheets where I track television programs and all the data associated with them. Issues so far are as follows: In GS I have a column containing program titles. On the program titles I have a note that shows up when I hover over the cell. With 1500+ rows I don’t want to have to recreate all these notes. Is there a way to bring them in? I will be doing a lot of my work in AT in the Grid View. Some of the data I have in cells is long and I’m hoping to a way to wrap text within the cell and ideally set row height to automatic based on the con

Hello! I am trying to set up a timesheet in Airtable and I want a formula or automation to assign a new pay period every two weeks. I don’t care if it is just a number (pay period= 1,2,3,4…etc.) or a single select field or something else! I just need to indicate a change in the default entry every two weeks. My first thought was to set up an automation and set the trigger as a scheduled time (every two weeks). But, I keep hitting a roadblock when trying to set up the action. I do not want to FIND, UPDATE, or even CREATE records… I just want the default field entry for new records to change every two weeks. In my mind, the sentence would be “Every two weeks, add 1 to the pay period number.” Any thoughts on how to get this done?? Thanks to anyone in advance!

I have a field called: Branch Name I need to extract text from it using a formula field. I’m just not sure how. Examples of data in the field: #2828 - Clarksville Branch - Clarksville, TN #4109 - Aiken Branch - Aiken, SC What I need to extract: Clarksville Branch Aiken Branch I tried this formula, but it doesn’t work (returns #ERROR!) and I don’t know enough about REGEX to troubleshoot: REGEX_MATCH({Branch Name}, '/(?<=-).*(?=-)/g')

I have one table that is a Roster of team members with various fields of data pertaining to each record. This table is imported for certain fields and other fields are manually imputed. The data on each record set has the potential to change at any given point. Changes are done manually. The second table is Synced data from an external source that contains some of the same data that is on the first table. I would like to setup a Validate field (checkbox) on the Roster table, this field will be checked if multiple data points (4 or 5 fields) matches exactly from the 2 different tables. Is there a way to compare this data across 2 different tables and if all matches correctly check the validation box? Additionally, if data changes in the Roster and now is different uncheck the box? Any help would be greatly appreciated.

I’d like to use Airtable to help me speed up the processes of responding to multiple RFP’s. Often a same or similar question is asked on multiple RFP’s. Rather than make a database I’d like to use Airtable to categorize and log the questions and answers that I often re-write from scratch each time. I would like to do a quick search in Airtable and and pull already answered questions or document content and pull it into a blank RFP template to partially automate the response process, and quickly access the questions Airtable database. Is this possible? Has anyone done it? Any know templates to start from? Thanks to you my Airtable Gods! :slightly_smiling_face: (not looking for an approval workflow at this time. may use my CRM for that)

Hi I’m creating a tournament ranking system. I have a table for each tournament played and within each table, I list all the players and their individual scores and then their ranking position and ranking points for that tournament. On a separate “rankings” table, I list all the players and lookup their score, ranking points from each of the tournament table. I can then add the total ranking points across all tournaments and sort them by male/female/adult/senior categories. However, the end of season rankings after 8 tournaments will be based on a player’s best 5 results/points scores out of the eight events. Therefore, I need to take the 5 largest (not necessarily unique) points from the 8 fields. I’ve looked at various formulas to try and find the answer (similar to LARGE function in Excel), but I’m stumped. Does anyone know how to do this? Is the answer to structure my tables differently? I feel database design is always my downfall :frowning: Thanks in advance.

Hello again all, I believe there is another topic titled “Using Automations to Check a Box When Record Matches Conditions”. (I posted there but got no answer) That thread seemed to have strayed a little off track. Because while “Update Record” IS a condition that ‘could’ be used, it’s only one option. And the steps seem to be different for each “Action Type” selected. So, if someone could walk me through another one, like “When a Record is Created”, I would greatly appreciate it! So, WITH A SCREENSHOT (please), can someone please explain how to use an automation to check a box? I’m putting true, false, one’s and zero’s everywhere and nothing is working! As always, THANK YOU! :pray: DG

I have built an automation that fires off an email to a key stake holder with information found in different fields. One of these fields contains a link. When the automation fires, the email is sent along with a slack notification. The slack notifaction contains the same information the email should, BUT the link in the email is altered by the automation and the link in the slack message seemingly works. The automation is grabbing the same URL from the same field. I am not sure why the URL is changes in the email but not the slack message. To add additional information, the email is removing the under-scores from the URL and the Slack message is not. Can anyone help?

Hello, So we have a “Survey Results” table that… wait for it… collects our “Survey Results”. It basically runs off an automation. The 'initial trigger is a checkmark in another table. When you tick the checkbox, the “Survey Results” table starts a new row by adding two items - a four-digit RO# and the subs email. Jotform then takes that information, and adds it to a form and sends it out. It then returns the results back to the “Survey Results” table… BUT IN A NEW ROW! This doesn’t seem that hard to figure out, but it sure has stumped me! Please advise, thanks DG

Hi All, I’m parsing JSON files into Airtable Long Text fields, and then setting up Formula Fields to relay the contents of that JSON. For example, the JSON data looks similar to this; {"NAME":"Colour","VAL":"Red","ID":"1"}, {"NAME":"Shape","VAL":"Square","ID":"2"}, {"NAME":"Size","VAL":"500","ID":"3"}, {"NAME":"Scale","VAL":"2","ID":"4"} At the moment, I’m using a fairly hacky method to display the data in a formula field, for example; ABS(SUBSTITUTE( RIGHT(MID({Log Content},FIND("Size", {Log Content}),17),4) , '"','')) But this is buggy as. Obviously if Size is more or less than 3 digits, the output fails or works simply by chance. What would be the correct way to write a formula that retrieves the entire value between the inverted commas, regardless of the length?

Hi there AT Brain-trust, I’m building out a pipeline dashboard using Airtable for my company, and I want to be able to show essentially a comparison of what the data was last month compared to what it is this month. For example, I would want my dashboard to read something like: Number of Opportunities (Current): 1 interest, 3 submitted proposals, 5 won, 2 lost Number of Opportunities (As of 30 days ago): 2: interest, 2 submitted proposals, 4 won, 1 lost I’m sorted on the current opportunities using the current state of data. I am also aware there are ‘snapshots’ of data that I can retrieve but not download (is that still true?). Even if the snapshot was downloadable, it doesn’t seem to be a very elegant solution because it means creating two sources of data. Fields I have that might be useful here: Date Created (record) Date Modified (record) Date Status Changed (i.e. when a user updates the opportunity stage, it triggers a date update in this field) Would really appreciate any tip

Hey. Thank you in advance or your help on connecting data between two tables. Linked records does not seem to apply here, but maybe I’m missing something. I am using Airtable to track disciplinary data for a school. We have two tables, one to track Pink Slips, and a second to track historical Disciplinary Cases. The first table “Pink Slips”, is where new pink slips are entered, using a primary field of a sequential ID assigned by Airtable for each new pink slip. One of the fields in this table is “Student ID”. The second table, “Cases” contains a historical record of all disciplinary cases (some resulting from pink slips), akin to a court case, with all data related to the resulting actions, dates, etc… The primary field in this table is “CaseID”. All of the data in the “Cases” table is imported from a school database, and also contains a “StudentID” field. For reasons that i would rather not get into, the two tables cannot be merged into one. As/after the admin enters new pink sl

I am trying to make a simple inventory of 50+ items I have one table called Inventory which has columns “Name” and “Quantity”. I would let other people borrow my inventory, so there are a lot of ins and outs. Anyway, On occasion, I need to do an Audit of my inventory, so I want to make sure that my personal inventory matches with the global inventory system. So what I would do is download the global inventory and put that into the Airtable as a separate table called Global Inventory. This table would also have columns “Name” and “Quantity”. I was thinking to create a “Global Inventory” column under the Inventory table and use the formula that would compare the two tables “Name” and output the Global Inventory Number so I can easily see if it matches or not. I guess this would be like reconciling a bank transaction in a way. Any help would be much appreciated. I know how to do this in Excel with SUMIF but again, this is not the same here.

Hey there, i am new to Airtable and have only understood half of the features yet. As I had to learn, that it is not possible to hide views from specific users, I found the sync feature. I do have a database with a lot of personal information about people living I a camp. I was trying to find a way to give some of my users (in this case security guys) the ability to put in the date of the last Covid Test of a person. As this does not work in one base (because I can not hide views) I have done a sync to another base of al relevant information. Is there a way I can let a limited amount of users change information in one or two rows, without letting them see all the rows and letting them change all the rows? Right now I can only see the information in my synced base, but not alter them. Thx for any hint.

I have a contacts tab with all of my customers and their contact information. I’d like to add a ‘sales rep’ column. The sales rep information is on my second tab, interactions. Every time my sales rep enters an interaction for one of my customers multiple times, their name shows up multiple times on the contacts tab for that customer. I just want the sales reps name to show up once. I’ve attached an image to help illustrate what I’m talking about. Any help would be appreciated.

Airtable Grid view - Airtable Explore the "Grid" view on Airtable. I have created this database to catalog those buried in a cemetery. I understand that I can’t use formatting in a formula–unfortunately. In a perfect world, I need to format “short name” in quotes (or bolding) and “maiden name” in italics. Could any of the experts suggest a different approach if indeed formatting is not available in formulas? Thanks, Sam paynegap.info