Solved

I used a simple formula for column C (it is A-B), it shows up as -0 in one case and 0 for another? Why should zero have a negative sign? In my case although all 3 columns are setup to round to 2 digits, I am certain that there is no third decimal digit in either column A or B. Reason for asking is that it messes my colour codes where I’ve setup anything less than zero as red.

I have two tables, one that is built in-house (say, INTERNAL) and one that is supplied externally (say, EXTERNAL). I don’t trust my external data source, so what I want to do is find all records present in INTERNAL and missing from EXTERNAL. If I were working in SQL, the query I would write would be something along the lines of: SELECT a.*, b.* from INTERNAL AS a LEFT JOIN EXTERNAL as b ON a.primary_key=b.primary_key where b.primary_key IS NULL I want to avoid using record linking; there are over 100 records to do this for, and my understanding of linked records is that they have to be done manually. Having to do this manually would defeat the entire purpose of using a database tool to speed up my workflow. Can the above analysis be done strictly within Airtable, or will I need to write an API script to emulate a JOIN?

IF(AND({Total Pages}<“50”,{Total Pages} >“43”,"$3.12"),IF(AND({Total Pages}<“12”,{Total Pages}>“1”,"$1.67")) What am I doing wrong? I’m trying to calculate postage by ranges…stating if Total pages is less than 50 and greater than 43, then $3.12, if total pages is less than 12 and greater than 1, then $1.67 and so on.

I think this can be done, might just need to add a new field! On table ‘seed packets’, I have a manual number field to log how many seeds in the original packet. On table ‘sowing log’ it calulates how many seeds I have sown by N numbers in N numbers of stations (manually logged, auto answer (I didn’t set it up so language may be wrong). On the ‘seed packets’ table I appreciate I shall need to create a new field for the answer. I want it to take off the number of seeds sown from the original packet number I am familer with formulas in excel but not here so please, if someone could give me a simple starter I’d be most grateful; or correct me if I am heading down the wrong path

Can someone help my brain wrap around this type of formula? I’m trying to get different amounts to populate based on what is selected in a different field. For example) Field 1 is State Trying to get Field 2 to calculate: if Field 1 is Missouri, then Field 2 should equal $2.00, OR If Field 1 is Illinois, then Field 2 should equal $1.00

Hi, I’m very new to Airtable. I am crafting a budget base for freelance business. I have an Income table and I am trying to only calculate tax for untaxed income. I have a multiple choice selection with options “FREELANCE” and “PAYROLL” then I have a field for calculating the tax (amount*.25) I want to be able to only calculate tax for the records that are selected FREELANCE… IF multiple select = FREELANCE then (amount*.25) IF multiple select = PAYROLL then 0 I have no idea how to go about doing this, all my attempts have failed.

Are we not supposed to be doing this yet, or did I do something wrong? schedule_conflicts| |master=> block release building copying package.json files installing node modules [npm] [npm] > core-js@3.6.4 postinstall /private/var/folders/lx/d2z19t052vx3m9jb9xpd71nm0000gn/T/airtableBlocks/build/1583468310281/transpiled/user/node_modules/core-js [npm] > node -e "try{require('./postinstall')}catch(e){}" [npm] [npm] added 77 packages from 133 contributors and audited 672 packages in 17.866s [npm] [npm] 2 packages are looking for funding [npm] run `npm fund` for details [npm] [npm] found 0 vulnerabilities [npm] [npm] npm WARN user No description [npm] npm WARN user No repository field. [npm] npm WARN user No license field. [npm] transpiling and building frontend bundle uploading build artifacts failed to upload build artifacts Error: Failed to upload /var/folders/lx/d2z19t052vx3m9jb9xpd71nm0000gn/T/airtableBlocks/build/1583468310281/build_artifacts/bundle.js at /Users/JM

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: ”))