Claribase (Formerly AirOps Consulting)
Claribase (Formerly AirOps Consulting)
I'll teach you how to use Airtable and Zapier in quick 5-10 minutes videos. We cover how to set up your own custom databases and integrations with other tools so you can harness the power of your data and work for efficiently.
Пікірлер
Hi I am unsure you still monitor this. But when I create the interaction it is not automatically connected to the Contact. I have to manually add it to the list of interactions associated with that contact. What have I done wrong?
💯 *promosm*
Thanks so Much!!!
You are welcome!!
Why zapier instead of integromat/make?
Can you read the table from right to left
Thank you for this series! Super helpful and informative. Please post more tutorials/projects videos.
super helpful! Thank you for the tutorial
super helpful
Super helpful! keep these coming!
Great tutorial! If I link a Table to another Table the Link appears in both records... If I link a table to itself the link only appears in one record. can I make it appear in both records (two-way relationship)? thank you!
Thank you for watching! If you link a table to itself, there will just be one linked field and there is no secondary field that automatically gets created.
Thank You so much It is very useful to me pls do more videos on Airtable which must be very useful:)
Thank you, interesting content.
Thank you for watching!
Thanks so much for sharing - 7:53 - Conditional Rollup Fields are absolutely something that I needed to know. As a side project, I'm figuring out a JS script that rolls up the Rich Text Markdown text of fields, cause unfortunately Rollups don't support Rich Text formatting.
Thank you, your delivery is so clear and easy to follow.
Great to hear you are finding our videos helpful!
Excellent explanation :)
thank you!
Girl, You are a genious!!
Thank you for watching!!
You would be a great professor. I love this series.
Thank you! We are glad to hear you are enjoying our videos!
?prefill_Date="&{Today's Date}
Great Tutorial Cherry Yang!!! Thank you....
Thank you Oswaldo!
Great Tutorial!!! Thank you Cherry Yang...
Thank you for watching Oswaldo!
Cherry, you're the best! Say you have a meeting with multiple contacts. The Helper - Most Recent Interaction Date will then have 2 dates in it... any tips?
Where is the information re the Airtable Bootcamp?
Hi there, You can pre-register for our course here: www.airopsconsulting.org/resources Thank you!
Please help me 😱. Tab1: I have a daily sales of 10 products in 30 days (ex: 16th April, Orange, $100). Now how could I show the total sales for each product for all days (ex: Orange, $10.000) in tab2. I dont want to see group or filter "Organge" in tab1 then I want it in tab2. Thanks a lot.
Simple explanation with short video session, really useful:)
Thank you Ashique! :) Glad you enjoyed our videos!
Hey thanks for this video, very informative. Any ideas why my Interactive ID formula isn't working please? DATETIME_FORMAT(Date,"L")&" - "&Type
Hi Thomas! Is the date field in your Airtable called "Date"? Or did you rename it to something else? At a glance, your date formula does look correct!
@@Claribase Thanks for confirming!
Great and useful content. I’ll wait for more. Thank you. You are beautiful by the way :)
Great video! Can you share this base that we can duplicate/review in detail please?
I AM SO HAPPY TO HAVE FOUND YOUR PAGE!!! THANK YOU!
Thank you! You did a great job helping me get started!!
Thank you for watching May! :)
Awesome! Thank you!
Thank you Akmadin! :)
So well explained! Thank you for making it so clear :)
Thank you!!
Thank you very much! you are great! i just finished all your 7 chapters on Air table. Whats next!? how can we get in touch? Thank you very much again, cheers!
Glad You found my link. Here's the URL to schedule an initial consultation with me if you'd like to get in touch calendly.com/cherryyang/initial-consultation
That formula pasted at 6:35 isn't correct, is it? Did your xls do a bad job and you didn't fix the video? One Prefill has the field name in it (Rep) (and the matching field value afterwards) and the others don't...
Hi Frank! Thanks for watching! You are totally right, we made a mistake while editing the video. Mistakes happen and we appreciate you for taking the time to kindly share the feedback! In the video, the correct formula should be the following: "airtable.com/shrX5pG2mYYTEMuAa"&"?prefill_Date="&ENCODE_URL_COMPONENT({Today's Date})&"&prefill_Contacts="&ENCODE_URL_COMPONENT({Full Name})&"&prefill_Rep="&ENCODE_URL_COMPONENT({Rep})
How are ya, AirOps Database and Automation Consulting. it's a fairly beautiful video. thank. :)
Wonderful insights. Great work !
Thanks Babu! :)
Great to hear you appreciating about people learning from KZread. Indeed, its a great learning experience & I strongly believe. Wonderful thoughts, suggestions. Thank you so much.
Thank you Babu! Glad you are enjoying the tutorials 😀
This is brilliant, thank you! I followed everything and the Today's Date field does indeed pick up today's date. When I click my button to fill out a form, however, it's filling in yesterday's date. What did I miss? It's about noon where I am (CST) so it isn't "yesterday" anywhere in the world.
Im having the same issue!! Would love to use this! Any ideas?
Thanks for watching! There are two things you can try: 1) toggle the field setting for "Use the same time zone (GMT) for all collaborators" 2) Try starting a new fields and use the set time zone formula to display the time zone in CST. (support.airtable.com/hc/en-us/articles/216141558-Supported-timezones-for-SET-TIMEZONE#:~:text=The%20default%20timezone%20in%20Airtable,(GMT)%20for%20all%20collaborators.)
@@Claribase Thanks, I don't follow though. Do you mean that I should have the 'Today's Date' field, plus another date field where this is converted into CST (and should show the same date), and that this second field is the one that should be pcked up automatically for the primary field? GMT is not interesting as all my CRMs are for companies in CST or EST. But mostly, I don't understand why it picks up yesterday's date in the primary field or date field when I open the form via the button.
@@Sieva04 Try setting the formula in the "Today's Date" column to the following: DATETIME_FORMAT(TODAY(),"l") Timezones can be finicky to deal with sometimes. Let me know if that works!
@@Claribase I ended up skipping that function and just fill in the date manually. I don't use l either, I want ISO. Maybe I'll give it all another try later.