Other Questions

This may be the wrong category, but I need to join two tables for output of our data. I have two linked tables: Person and Classes The person table looks like: Name | Classes ---------------- John | A,B,C,F Sally | B,F Max | B,C While the linked classes table looks like: Class | Date | People --------------------------- A | 1975 | John B | 2000 | John,Sally,Max C | 1823 | John,Max D | 1492 | E | 2020 | F | 2010 | John,Sally What I need is: Person|Class|Date -------------- John | A | 1975 John | B | 2000 John | C | 1823 John | F | 2010 Sally | B | 2000 Sally | F | 2010 Max | B | 2000 Max | C | 1823 How can I achieve this in Airtable?

Good Morning! I am having some difficulty with getting an automation to connect with Teams. My admin said he logged in and granted access, but when I try to log in, it doesn’t work. Do I have to be on his Airtable account? Or have him perform the Teams login on my account? Any similar experiences out there? Thank you!

Hi All, Struggling with a formula if anyone can help! I would like the fee to show in the field, if the date booked is a 2018 date. Then I’ll have another field pulling out all the 2019 fees etc. Then use a roll up to bring in the totals to another tab. When I do the formula below it pulls in all Fees no matter what the date is, and when I click back in to the formula it has removed the ,0 part. IF({Date Booked}>=(01/01/2018),{Date Booked}<=(31/12/2018),{Fee £},0) Any help much appreciated! Thanks Neil

We built an agile Gantt chart in AirTable. We’ve got tables with Sprints, Epics and Tasks. Is it possible to disallow the start of a sprint date that is before or after an epic? So the idea would be if an engineer schedules a Sprint to start after the Epic closes, they wouldn’t be allowed to.

Every time I open Airtable and go to my most-used table, the same Personal view always loads. I think it is the first grid I set up in the table and right now it’s my only Personal view. However, I would like to have a different view load as a default. Per the suggestins in a previous closed thread (Change Default View), I tried moving the desired view to the top of the list, and also to quit Airtable on the desired view and reopen, but it still goes to the Personal view. Is there a way to change this? I’d love to see an option in the view controls to set ia particulare view as the default for the table. Thanks Helen

I would like to sort my gantt chart by the end date not the start date. how can i do this?

Good afternoon Airtable Community Members, We are a new small business to the Airtable platform. We are in dire need of learning how to integrate our applications. Is anyone able to provide step-by-step processes for application integrations or refer me to this information? Your review and assistance are greatly appreciated. Thank you in advance. Have a great rest of the day!

Hi All, so this might be dead simple but its killing me. We are rolling out airtable to many people within the business, however some have access/are visably able to see the “Views sidebar”, and some it is a dropdown. i mean this: but some can only see this: so what my question is, how can i switch between the two. I have tried the SHIFT+ CONTROL+K, but this just opens the dropdown menu. surely there is a way to toggle between the two. thanks! Rob

Hello Everyone, not sure if this question needs to be here or formulas? My Company is a VOD service, We are creating a content programming grid and a calendar view for our episodes daily content: We want to address each episode to its specific date in an automated way to know the volume of the content in a daily bases. For example, I have Release Date, Pattern Release/Week “7”, and No of Episodes. there are some conditions excluding weekends, not applicable with all titles though. I have created that formula that gives me the end date IF({Release Pattern}=5, IF(DATETIME_FORMAT({Start Date}, ‘dddd’)=“Sunday” , DATEADD({Start Date},IF(INT(Eps/{Release Pattern})=Eps/{Release Pattern},((Eps/{Release Pattern})*7)-(8-{Release Pattern}),(ROUNDDOWN((Eps/{Release Pattern}),0)*7)+(Eps-({Release Pattern}*ROUNDDOWN((Eps/{Release Pattern}),0)))-1),‘days’) , DATEADD({Start Date},IF(INT(Eps/{Release Pattern})=Eps/{Release Pattern},((Eps/{Release Pattern})*7)-(8-{Release Pattern}),(ROUNDDOWN((Eps/{Rel

Can you prefill fields that are not available/visible in a form?

Hi, I have below table which I track all the transactions each per row. Transaction No Description Income Category Total Amount N1 Apple Social Media 100$ N2 Nike Production 120$ N3 Mercedes Content 310$ N4 Adidas Production 170$ N5 Toyota Content 210$ N6 Porsche Social Media 305$ Using the above detailed table, I want to create another table where I summarize the total sum of respecting categories. What I want to do it, I want to sum all values belonging to a specific category in another summary table. Income Category Total Amount Social Media 405$ Production 290$ Content 520$ Tried to use Rollup but no luck. Any idea how I can do this? Thanks

I have a form with a lot of questions, which I’m sharing with people as a questionnaire. Is there a way to have the questions numbered? My questionnaire looks good otherwise, but I’d really like to have each question numbered. I hope there’s a way to do this. Thanks in advance!

Hi everyone, I’m looking for a way to update records from multiple tabs into one single tab automatically. For background, I have a base with multiple tabs in accordance to my org’s departments. Every department has its own unique deadlines in accordance with a program/task. Is there a way to: Create a link, automation, or script to take all of the deadlines from the multiple tabs into one overview tab automatically? That is, every time a new deadline is created in the individual department tabs, it will automatically transfer that date into the overview tab. Create/update records from the individual department tabs and include them in the overview tab? I had a free consultation that ultimately expired so any help is greatly appreciated, thanks!

Is there a way, in a form, to collect the lat-long of the location where someone is (say, from their cell phone) when they upload a photo? Or at least is there a data field format for lat-long? I’m also interested in a time stamp data field, but I only see date, and time modified - I want the user to input the time they recorded the data. Elizabeth

2 Tables - Constituents and Constituent Types. Constituents holds contact information. First Name, Last Name, Email, Phone, etc. Constituent Type holds the taxonomy (so it has a hierarchy) to organize the Constituent data a. Individual a. Organizations b. Foundation b. Business c. Healthcare c. Retail c. Personal Activities-Interests b. Government c. Local c. Regional c. Federal b. Nonprofit b. Religious-Educational b. Club-Membership-Association I have three fields in Constituent to link to the Constituent Type Constituent Type Links to Constituent Types with a Limit record selection to a view only a. Works great because there are only 2 options. Constituent Organization Type Links to Constituent Types with a Limit record selection to a view only b. Works great because currently, only Organizations have multi-levels. Constituent Organization Area. This is where I want to link to “Constituent Types” based on the “Constituent Organization Type” selected in the “Constituents” table. Crea

I am a lifetime Excel user, so forgive me thinking like a spreadsheet and not a database, but…here is my problem: I manage an Oyster farm. I have a table that logs the oysters that are harvested. I have another table for the demand for the oysters. I want to net the two against each other and see whether I have enough. As my table of Harvested oysters is set up so each day the team either enters the number of oysters they harvested (a positive number) or the number of oysters they delivered (a negative number). Thus, choosing “sum” at the top/bottom of each column will show me exactly how many oysters I have (summing all the postive/negative numbers to date). And as my table of Demand for oysters shows the number of oysters requested by each client on each date, I can group those by day/week/month, and look again to the “sum” of the column to see how many oysters are needed. But I can’t see how I create the Sum of all the oysters I have (the sum of Harvested Oysters table) less the su

I’m trying to keep my team’s resources all in the same place, including some very simple fill-in-the-blank text boilerplates. The text contains and tags for styling already because one of the platforms it will end up in, for some reason, interprets strings of more than one line-break character as something it needs to preserve, so it automatically adds a   to “preserve my intent”. I’ve noticed that I can copy text into an airtable long-text field (with or without Markdown turned on) that’s formatted like this: Some random text More random text And some more but when I copy it back out to plain text it looks like the invisible \r\n at the end of the line has been turned into \r\n\r\n like this Some random text More random text And some more Is there a setting to fix this, or will I need to remove the extra line breaks from everything that comes out of an airtable interface? (I already have the expression for it (\r\n){2,}, I just don’t look forward to teaching people who bare

Hi there, I’m a pretty novice developer so would appreciate any help here… I am making API calls using AJAX and get URLs. I use this helpful tool a lot to help me write the URLs: https://codepen.io/airtable/full/rLKkYB?baseId=appSzxZJK94yvza3a&tableId=tblYFuqRveHg52vvb My question is can I do two FIND formulas in one URL? I’m getting a 422 error in console, just trying to narrow down the problem here. Example URL: https://api.airtable.com/v0/appID/base?filterByFormula=(FIND(“player”,{players}))&filterByFormula=(FIND(“match”,{matches}))&fields… What I’m trying to do / the problem: In one base there are various amounts of players that have played various amounts of matches. Each record is a one match for a player. I am trying to dynamically return 1 specific record / match for a player. I need to tell the API which player and which match and after that there can only be one record - I just don’t know how to tell the API that… Cheers, Thomas.

We use our AirTable for content management for our blog. I’m looking to randomly assign a collaborator when an article updates in a “For Review” view. Any thoughts on how I might be able to do this?

Hi All The link from within Startups.com for the Airtable Redemption Benefit is not working airtable.com/startups.com. Hoping to redeem the offer and apologies if this is not the best community forum to ask. It seemed like the closest compared to the others. Appreciate in advance any assistance! Cheers Matt

New user here, I made a mistake in my view, not my grid is all out of whack and I can’t get the rows to the order they were in before — help!

Hi All, I am attempting to embed the scripting block into stacker, but am not having any luck. the block keeps showing up as greyed out. (Image below) Any idea on how to fix this? P.S. i’m not having this issue with any of Airtable’s built-in blocks. Not sure this is an Airtable limitation because they do give you the option to embed the scripting block. Thanks

Hello everyone. I have built a robust task management system in airtable. I run my own business and i wanted to track the time it takes me at various tasks so that when I am ready to hire out/hire intern etc I have an idea of what i’m spending the most time on. I have started using the time tracker block to accomplish this, but i’d love to be able to add BUTTON right next to the task in order to accomplish this. I don’t have scripting experience but I was curious if this was possible? The fact that I cant just be working down my task list and say “start time tracker” drives me crazy and I was hoping to just integrate. Thanks!

Hi, we have been using AT for the last couple of month and it is going very well on most of our projects but I’m stuck on the following. I would like to have a view where we can show all records with the same date. We produce a daily publication and it would be helpful to have a view where our sale people can add an advert booking for a specific date and page. It would also be good to have the same thing but for editorial notes. I wanted to upload a screen shot to help describe the problem but can’t as I’m a new user.

Hi, I’m looking for a solution to add the working hours to a record. Should work like the comment field where anybody could just log his hours which he has worked for this record. I know I could do this with another table and crate a record for every work-log. But it would be much easier for the team if they could log work like they can make comments to a record.