Solved

I haven’t been able to access the example custom blocks for some time now. When I try to build one from the template, I get this: blocks|=> block init appFalshZ06hLqEPb/blkmXtdrOPFKUVPIW --template=https://github.com/Airtable/blocks-flowchart flowchart_example Using your existing API key from /Users/JMO/.config/.airtableblocksrc.json Initializing block using https://github.com/Airtable/blocks-flowchart template [git] Cloning into 'tmp'... [git] remote: Repository not found. [git] fatal: repository 'https://github.com/Airtable/blocks-flowchart/' not found ❌ Something failed! Cleaning up... Error: Could not get template https://github.com/Airtable/blocks-flowchart - please check you entered the name correctly And when I try to view the source code directly on github, I get this: My github profile, in case it’s a permissions issue: GitHub jmoglesby - Overview Software developer and test automation developer at BCBSAZ. - jmoglesby

I have a table, called ‘Industry,’ with 2 columns of Industry type codes. The first column has many repeat values in it, the second column are unique values, for example: Manufacturing Textile Mills Manufacturing Apparel Manufacturing Manufacturing Paper Manufacturing In another table I have a column called ‘Industry level 1’ which contains values from the first column of the table above (Industry). I’d like to add a 2nd column to it that’s a single select that looks up the values available for Manufacturing and displays them as the choices for the 2nd column. I’ve seen a range of questions like this asked but none answered that didn’t invoke JSON and code. Is there some way to do this natively in AirTable? Thanks!

Is it possible to either print out or email blocks/dashboards?

Hi all, I am a workspace owner on the Pro account. We have 19 billable collaborators. Is there a way for myself as the owner to see who has/has not enabled 2FA on their account? Thanks, Tom.

I have created a table for our small architectural firm based on the “project tracker” template I found in Airtable. Once a task is completed, I need to be able to hide the task in the table view so that it is clear at a glance where there is work to do for each project (and have the option to unhide for when I need to review task history). I have worked out how to filter tasks by their status in the Task tab but seem to be unable to do so in the main table. When you are looking at the table, there’s no way to distinguish completed tasks from incompleted without opening up the row, and looking through all the tasks, which is causing me problems in meetings. Right now, the owners have me manually adding asterisks to the text of completed tasks AND I’m having to delete most completed tasks anyway, because they really pile up on the table view since I can’t hide them. You can see an example of what I’m saying in the “project tracker” template. In that template, under the “Design Projects”

SWITCH(PageID, "18479402361", "NKH", "8532248414", “WWP”, "8271670852", “LLS”, "342294162453301", “PP”, "27817332304", “AFSP”, "55701226138", “AHA”, "15687409793", “WWF”, "12692786774", “ALS, "184404096774", “LUPUS”, "105229062888132", “SSS”, "25372476424", “BFAS”, "12596759677", “RAICES”, "14084625156", “SGK”, “13793312555", “MAW”, "1562713090633117", “OUR”, "20876805343", “MOD”, "100438444321", “CCA”, "8492293163", “EDF”, "111541054636", “BTM”, "10331123781", “SO”, "371566686229476", “ADAA”, "342091725962792", “M22”, "8047221596", “STC”, "11791104453", “NRDC”, "81517275796", “UNICEF”, "512423278811960", “DS”, "122531741163825", “ALF”, "22902828717", “BB”, "332378771195", “CF”, "97646191545", “HA”, "44224524016", “AKF”, "332077995968", “LCRF”, "84618074710", “CCC”, "95155519857", “BLISS”, "24470472733", “TP”, "7271534916", “FFB”, "N/A") Here is my switch formula currently. I have genuinely been looking at this for 45 minutes now and I cannot seem to figure out why it is erroring

I see that I can sort by 1 -> 9 or A -> Z, but is there a way to sort chronologically?

Where do I find my invoice? Thank you

Hi! Five users are working with thousands of records in a table, and sometimes records accidentally get deleted. Is there any way to prevent record deletion per user, but still allow editing on the records? (except the primary field name)?

I am wondering if I can take the column that’s titled “Client Lifetime Value” which is a numbers column… If the “Client Lifetime Value” is set at $37 I want it to print out “$37 Package Purchased” but if the value is $127 I want it to say “$127 Package Purchased”. I would like these to show up in a Single Select column at the end of it so that the options are colored and easily distinguished. We use the single select options to ensure that the filtering for the rest of the spreadsheet works correctly.

This seems like a dumb question, but I can’t seem to find a quick way so I hope some of you can help? I have a base with many hundreds of records on it. The first column is all data that I need to get rid of. I can’t delete the column as it is the mandatory one. So I need a quick way to just clear the data in column 1. All I seem to be able to do is select and drag down to select multiple cells in the column to then be able to delete the data and this is taking a very long time due to the number of records in the table! Is there a more efficient way to do this?

Hi, I’m a first-time Airtable user testing out the User Research template. Is it suggested to delete the sample data records and add your own records, or is there another place in Airtable where records get created?

Hello, I’m trying to do a formula that calculates commision due. I have the commission field, and I also have a ‘commision paid’ checkbox field. Basically I want the commission owing field to calculate the commission if the paid field isn’t ticked yes. Help please!

The records in one of our main tables are legal cases. Each case has the same set of tasks that need to be done to it. When we create a new case record, we want to automatically create the appropriate set of tasks in a task table and have them connected to the new case. Can we do this? If so, how? Thanks!

Hi guys. Trying to figure out the best way to overcome the limitations of the Page Designer and hoping a formula might be the answer. I’m collecting a lot of data in a table called “Rooms”. Each room record has linked products, materials, and concepts, and then I use a bunch of lookups to retrieve the information I’m hoping to display on my Page Designer. The problem is how the Lookup field combines my information. Here is my Product Name Lookup field for one room as an example: Aqua 2 Complete Shower Rail, Lapiana Towel Bar, Lapiana Towel Ring, Lapiana Robe Hook, Lapiana Paper Holder, Square Tubular Pull Handles for Back to Back Mounting, Square Trim for 1/2" Valve, Caso Single Hole Faucet It obviously collects the information in a list, but that’s not what I want. I would like to be able to hand arrange each name in my page design so that each text string can be under their respective images. For that, each name has to be in its own field. Is there a formula that would separate my

I have a simple question. I’m on the Free plan right now. I created 20+ bases in my workstation and sent my clients a link with editor status to the base I created for them so they can add info I need. Is this something I can do on a free account or what plan do I need to do this?

Is it possible to reference a specific Field in a Table from another Table in the same database not just the Name of the records but a specific field with in it. Such as currently only the first field shows up when you used a linked record. Is there a way to say pick a record and display a field from that record OTHER then the first field?

What am I doing wrong with this one? Please help! If ({Date Due} IS_BEFORE{Date to work on it}), “ :nauseated_face: ”))

Hi All, I’ve got a client that wants to be able to view airtable data in wix. This has been easy enough when using a grid - eg customer comments for the last month. But,… what I’d like to do is have a chart eg “customer satisfaction by month” grid data is “date” and “rating” (values of 1, 2 or 3). The awful solution i can think of is manually export to csv, generate the chart, save as image, the save to webpage - but that is awful. Is there something I could do with API? That is way beyond my capabilities though (but I’d happily accept help or pay someone via a freelancer app) I’m not committed to wix so if there is another way I’m open to that. Thanks heaps in Advance :slightly_smiling_face:

Hello, dear Airtable community. I want to generate a unique payment ID, based on the sum, date, cashier, and the type of transaction. Everything has been good by far, until I decided that I want to try using emojis. So, I assumed it should be a mix of CONCATENATE and IF, because I want the emoji to appear only in one field = meaning that IF it says ‘cash’ then show ‘ :money_with_wings: ’, IF it says ‘card’ then show ‘ :credit_card: ’

Can we have several sub-records for one primary field ? We make a quotation based on several quantity ranges. So all fields are the same and only the quantity and prices are different.

Is it possible to recreate this formula in Airtable? Where: i = IRR L = Loan amount F = Points and all other lender fees P = Monthly payment n = Month when the balance is paid in full Bn = Balance in month n This equation can be solved for i only through a series of successive approximations, which must be done by computer. Many calculators will also do it provided that all the values of P are the same. I’m trying to solve for i All items except for i would be supplied via columns inside Airtable

I’ve tinkered with a few ways of doing this, but wanted to get some ideas about the most efficient way. I have this full address string: Street address: 1600 Pennsylvania Ave NW # 15 City: Washington State: DC ZIP Code: 20500-0003 I want to extract the State (in this case, DC). I’ve tried LEFT, RIGHT, MID, etc but nothing seems to zero in on it. Appreciate the help :slightly_smiling_face:

There are more fields being returned than in my View through the API. Any suggestions on what could be the issue? Regards, Ruchika

Hi everyone! I have done several searches and cannot find exactly what I am trying to do. I am relatively new to all of this and my ADHD brain struggles with all of the technical stuff at first, so I apologize if this is very obvious. I want to simply have a “total hours” field that takes the start and end date/time fields and puts it in hours rounded to the nearest quarter. 2/27/2020 8:00AM to 2/27/2020 9:45 would automatically compute to 1.75. This is for a timesheet :slightly_smiling_face: Thanks!