Lookup vs Rollup Fields

[@GarethPronovost]

Join us for our *FREE LIVE TRAINING* that teaches the building blocks of automation: www.garethpronovost.com/webinar-registration

[@markpoultonsrules]

Your explaination on the lookup field here is exactly what I needed.

[@GarethPronovost]

So glad to help!

[@davidhillmer5958]

Great video! That solved for my problem of having my Task table tell my Project table what phase each project is in. Keep em coming!

[@JasemAlqaseer]

The advanced segment starting after minute 9 is very useful. thank you so much

[@GarethPronovost]

Glad it was helpful!

[@buildwithk]

Thank you. Was looking for great examples like this to help me get my head around this and how the relationship functions work

[@GarethPronovost]

Glad this helped and thanks for watching!

[@khaidang6074]

Thank you Gareth for this very helpful tutorial! As a newbie to Airtable, I was concerned that I would not be able to use Lookup like normally do with Excel, but this clears up. It helps a lot as I'm working on creating a database for my students.

[@GarethPronovost]

Glad it helped!

[@riccardovannozzi568]

I'm crazy with access but since I discovered Airtable I'm excited

[@MorganBuchanan]

Exactly what I needed! Thanks so much!

[@GarethPronovost]

Glad that helped :D

[@jeirmeister1276]

Thanks for the info Gareth! I find your videos very helpful. I work in a similar field as you, and have been wondering how I would use AirTable to automate the tedious invoicing process. I was struggling to understand the Lookup field and now it makes sense that it would literally "look" into another linked field. This is going to be extremely helpful, as I'm designing a database to coordinate volunteers and event participants.

[@jeirmeister1276]

On that note, I just started using the Time Tracking block today. I'm wondering if that can be plugged into the process for invoicing?

[@GarethPronovost]

@@jeirmeister1276 - glad to be of service. Yes, you can use the time tracking block with an invoicing process. I'd suppose you'd want to calculate a subtotal for an invoice based on the (1) duration and (2) rate. This could be done pretty easily with a formula. I'd caution that you might want to build some sort of function that pushes your automation. For example, you might send this invoice to QBO only after you've reviewed it and checked a box. Otherwise, you might have your automation fire prematurely before you've put all the information in (depending on how you construct this).

[@dantekapi5796]

Exactly what I wanted. Simple...Thankyou!😊

[@GarethPronovost]

Glad to hear it! 🙌

[@BrunoPelosi]

Great video again

[@GarethPronovost]

Appreciate that - happy to help!

[@anarosaamorim3851]

Nice explanation! Thank you!

[@GarethPronovost]

Glad it was helpful! 🙌

[@ziggerwebdesign1704]

Excellent, thanks so much.

[@GarethPronovost]

Glad it was helpful!

[@hoboronin]

I will be in touch your.. your videos are very informative

[@GarethPronovost]

Sounds good - thanks!

[@parasmehta7793]

Thank You, Boss!

[@GarethPronovost]

Thanks for watching!

[@kaylebdasilva7415]

Thanks for the videos and info. is there anyway to set notifications to pop up on your desk top instead of having to go into the bell icon? would be good to have so you dont always have to go check for notifications. i know on the mobile it has push notifications just want to know if we can set it up to push on desktop, like whatsapp msger does when a msg comes through. thanks,

[@GarethPronovost]

Hey Nelson - you can set your notifications to push to the mobile device and you can also choose to receive an email notification. Other than that, the bell icon is the only other way to receive notifications with the native app. That said, you might also consider building a Slack integration. If you don't use it already, Slack has a great free plan and you can integrate this with Airtable rather nicely. This might help you get alerts when important things require your attention!

[@chiragjain101]

Great👍

[@simdoolaege7982]

Is there a way to use the number of records for calculations? meaning...if I have a table with 7 records (as stated under the table)... can I retrieve that counted number in a formula? sorry for bothering... is for a COVID 19 programme.

[@ahmedalbusaidi9538]

Thanks, Gareth for the useful videos. I have been watching your video for weeks now and they are very valuable to me. 1 question: Is there is any way to create "nested single select field" ... for example, I have 3 single select fields "Block", "Floor" and "Room/Location" ... If Block A is selected for example in floor field only values which are related to Block A will appear and if floor GF is selected only rooms and locations related to Block A+GF will appear. Thanks Ahmed

[@GarethPronovost]

Hey Ahmed - sounds like you're looking for a parent/child relationship between datasets, which Airtable doesn't easily offer in it's current form. That said, a developer built a cool tool to help with this if you are submitting a form response. Check out this video for more info: kzbin.info/www/bejne/mJDac6aCmb96f5Y Hope this helps!

[@homahealthcarecenter]

field in air table is column, row is record, so people do get confused in the beginning for excel, if you can have a design with primary fields with3 tables and primary field A with and primary record B like that upto G ,you will get good airtable,prmary table key is he heart of airtable

[@nicmamom]

Thanks so much for all your helpful videos. Is it possible to use a roll-up to trigger a Zap when a total is reached in one field?

[@GarethPronovost]

You can trigger a zap from Airtable when a record appears in a specific view. So, to do this, you could create a view called "Automation Trigger" - then set a filter on this view so that records only appear in the view when certain conditions are met. For example, "Roll-up amount >0" - This way, only after a rollup sums more than 0, will the record trigger an automation. Hope this helps!

[@homahealthcarecenter]

first half is enough for new comers, use airtable for amounts, and database, for invoice and task and project motion a i is better

[@epj-m8s]

Is it possible to do a lookupfield and filter by a view of the other table, or filter by a select option? for example, Project A contains 2 members, 1 with membership A and 1 with membership B. Can I create a lookup so that I can get membership A info and memberhsip B info only? for automation purposes.

[@GarethPronovost]

Not in the native software, but you can build an advanced form with dependencies using a plug-in/widget. Check this out for some tips: kzbin.info/www/bejne/mJDac6aCmb96f5Y

[@sarangapani7830]

Hi, thank you very much for your video. I have multiple dates from the tasks table, in the main project table. In project table I need the earliest and latest date of the particular type of task. Please hep to write this code

[@GarethPronovost]

Hi! To bring back the earliest date from a linked record, use a rollup field along with the MIN function. Similarly, to get the latest date, use a rollup field with a MAX!

[@mohsenuss91]

I would like to know if it possible to search in all fields of a table while looking for a linked record (in another table)?

[@GarethPronovost]

when you start typing for a record to link to, the only thing that will be available to search from is the primary field of the records you are connecting to.

[@thugg4lif]

Can I lookup across multiple tables? Currently it only lets you choose 1.

[@GarethPronovost]

You can only lookup to one table per lookup field.

[@dangelneira]

Hi Gareth, how can I extract the email domain in the email field?

[@GarethPronovost]

I'm not sure what you mean, the email lookup will already extract this data

[@RubyAmorVilla]

How do we fix a lookup not showing the values we need?

[@homahealthcarecenter]

hide option i think, usually look up is used for a table to bring other table into present table, it has no purpose, then use a roll up or another look up to get exactly what you want, so always primary table is the key.

[@softwretesting]

hello sir, I am new at kodular, My question is how to find Automatically Row number, I have student db but i every time not look up in table and write Manually row number into code section. so what is the solution of that…? please help me i am very confuse in Index in list thing its find air table row number…? If yes then how we can find Air Table row number…? I am waiting for Your Response…? I NEED HELP PLEASE HELP ME…

[@GarethPronovost]

Row numbers aren't a thing in Airtable the way they are in a spreadsheet. This is because the row number isn't consistent - it changes from view to view. The closest thing you could do is use the 'autonumber' field type to fill out a new number every time you create a record.

[@Max-ip7ix]

I have two tables are directly linked. “Look up” is not an option to choose from when creating a new field. I’m on iOS. Is this a pc only feature? Not sure what I’m doing wrong

[@GarethPronovost]

Yes, this is a browser only feature - unavailable on the mobile apps. That said, if you build it in your browser, you can then see that data from your mobile app.

[@timmycorini]

Gareth, I just booked a consult call with you. It's 2 weeks out however. Any way to hire you directly, before the free call? I need help asap. Thanks!

[@tommycoe2333]

He endorses people that do that on his site. Also you can post the question here and he may answer or someone else might know the answer

[@AmyMorosini]

What's the formula you used to create the full name primary field? I’m truly a beginner.

[@GarethPronovost]

Most likely a concatenate field to combine multiple pieces of info. This is something that I address on our weekly webinar, if you'd like to sign up it's a free event I hold every week: www.garethpronovost.com/webinar-registration

[@jnschaub1]

Can a Rollup field be used with qualitative data? Or just with quantitative?

[@GarethPronovost]

Qualitative is possible too, in the form of arrays (unique array, for example)

[@taylorborders351]

I'm having trouble using lookups when I have multiple tables linked on my base. The table I want to lookup from isn't coming up as an option. The two are linked however. What could I be doing wrong?! Help!!

[@GarethPronovost]

Are the tables linked directly, or are they inferred? If you have tables A, B & C... Table A can link to Table B - then Table B can link to Table C. With this relationship, there's a relationship inferred from A to C. Table A links to Table C THROUGH Table B - however, you can't use a lookup under this condition. The link must be direct (you can lookup A from B, or B from A, or B from C, or C from B). Hope this helps!

[@alessandroscaltritti7092]

Hi, after plenty of tries I have to ask for help. I have a table with a list of clients with a "Last modified time" column. So I can track the last interaction with a client due to some changes in the status or notes fields. In a second table, I would recap how many records have been modified on a specific date (ex: 1 April). I don't understand how to explain to Airtable this logic. Basically, I would check the number of interactions with my clients on specific dates. This data can really be useful for me to monitor the number of my activities and relate them to my goals. Can someone help me out with this issue? Thanks a lot in advance.

[@homahealthcarecenter]

primary table is the key, design 3 tables , 1st one with clients ,3rd one with last meetings, 2nd will be junction table where you can modify and add or delete.airtable is only relationship database, primary table or key is the heart of it

[@vickyk72]

How to do sumifs() in airtable???

[@GarethPronovost]

They are not quite the same as Excel. Instead you'll use a ROLLUP field type, aggregate with a SUM(values) formula, and set conditions to only count the records you want to include! 💪