Other Questions

Wondering if it’s possible to format within the chart block. For example, I have a scatter chart, and the dots are tiny. I want bigger dots!!! Possible? I didn’t see it. Thank ya

Greeting, I am using airtable as CRM with all leads being managed and assigned via airtable. One of the main challenge I have is that a lot of the Sales team are missing their appointments (Whenever a lead come to the system, it comes with the best date and time to call) I want to create a reminder and email notification to be send to the sales team 10 minutes before each appointment so they can call the customer on time How can i create such column with 0 or 1 Whenever the time of appointment is 10 minutes earlier to the current time it turns into 1 then i can create a view with filter for all the value of (1) And finally i can create a zap for each new record on that particular view (I can take care of it afterward) Is that possible? If yes, then how? Thanks in advance for your support and collaboration. Regards

airtable VIEW’s UI is slowly improving, and in the right direction! Bravo and thanks AIRTABLE DEV team ! I’ve already often weighed against the VIEWs in the SCRIPT-BLOCK section but when it evolves in the right direction, it doesn’t leave me indifferent. Most importantly, AIRTABLE DEV team, keep going, read the Product Suggestions about the most requested VIEWS UI and features and don’t stop on the way ! olπ @Jason @Kasra

I’ve created a Zap to create a calendar event based on a Field (formula) from a filtered View on a specific Base. When testing on one specific event, it works and the event shows up on my calendar. However, it is not creating events for all the records in that particular view. I’m thinking it may be possible that the reason is that the trigger is a new record (even though the test event already exists in the base). Anyone have any ideas on how I can get Zapier to trigger off of all of the existing records in this view and create all the events for those records, as well as new ones I will create going forward? Thanks!

I have the first column with a start date (Date Submitted). I am wanting to know how to code so that the next column will show how many days are passing since the start date (Date submitted). Then if the status (another column) comes back as closed it’ll then show closed.

I have been getting inconsistent results when inputting data in a linked record field. When I paste a comma separated list into the field, I randomly get one of the following results: Linking to each comma separated record Creation of a single new linked record with a long name of the entire list. I have performed the paste action several times in a row and gotten different results. Can anyone explain why? Has anyone else had this? Scenario 1 is the result I am expecting. Thank you!!

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?