🔥 Looking for more content, further content, and a helpful community? Why not consider joining The Digital Pro's #Nocode Academy at www.thedigitalpro.co.uk
You should be the ambassador of the century... why all this patience? Passion? And competence? Like its my first time meeting a teacher... well thank for everything sir
4:05:44 For those that are unable to update a task and are getting the trigger error in console, don't forget to add the ELSEIF (TG_OP = 'UPDATE') statement as well in the update_goal_task_count function.
Ah you are a superstar thank you for your comment. I was not aware of an issue here and this helps others. It's a shame I cannot update the videos on UA-cam to support any challenges or changes.
@@the_digitalpro you're the real superstar for creating this exceptional content and sharing with us! Thank you! Learning a ton from you. BTW, I posted this comment shortly before I realized you added the second trigger update_goal_task_completed_count with the UPDATE event. So I went back into my update_goal_task_count function and deleted the ELSEIF (TG_OP = 'UPDATE') statement to see if the error persisted and it did. I then went back in Supabase and disabled the first trigger (update_goal_task_count) and recreated it without the UPDATE event checked. That seemed to work. Otherwise you'd have to add the UPDATE ELSEIF statement to both triggers and make sure that the no_tasks is not incremented for an update. Without your call out of using console to debug earlier in this lesson, I'm certain I would have been stuck for some time on this issue!
You are a life saver @DanVanDamme 🤟I think we should combine two functions and triggers or uncheck the UPDATE for the first trigger. Because when we update a task, it looks for a return for update in first function.
@DanVanDamme @the_digitalpro Hey there, I'm finding now after adding the triggers to the update_goal_task_count I can't seem to tick the completed box within the task at all. Stuck on this point at the moment and I was just wondering if you could have any idea as to why this would be occurring?
Please disregard my comment, I've found the solution. I went to the playlist for the individual episodes to episode 12, in the comments had the solution. In Supabase update_goal_tasks_completed_count function, SET no_tasks_completed = no_tasks_completed + 1 WHERE id = NEW.goal_id; ELSIF (NEW.complete = false) THEN UPDATE goals SET no_tasks_completed = no_tasks_completed - 1 no_tasks_completed originally did not have a "d" on the end. Also in the no_goal_tasks_count function I needed to add "RETURN NEW;" on line 13.
took your advice and yes i did not regret any of it. took me longer than the video length i had to keep pausing it and rewinding it to make sure i understood a concept before going forward
I always appreciate the level of effort that went into creating such an organized tutorial. This is so good. Well explained. Well structured. Professionally designed. I've started sharing your videos with my friends. Well done and huge huge thanks.
This is amazing thank you for such generous feedback. I am really pleased you like my content and appreciate you bringing your friends to channel. Thank you so much.
I am now at minute 1:05 , and when I heard the phrase 'we will put all the hard work on the server side,' I felt an extraordinary happiness. This is because this is the first course that will explain these things using Supabase. This exactly what I want 😍😍😍 thank you sir 👮
No problem at all. Thank you very much for your kind words. Also in one of my more recent videos I show you how to setup Edge functions as delete users. This is a pretty useful video too.
I just finished following the tutorial! Thank you so much for making it! It really helped me get some of the basics of flutterflow and supabase. I am now going to follow you 2024 series :)!
You are so welcome! Enjoy the 2024 series. Some stuff has already been covered but this is more of a slow paced series. It progressively gets more advanced.
@@the_digitalpro Awesome! I was wondering: Will you cover also how to manage offline data? (so for example using supabase, caching the data so the app can still be used offline and then syncs when it has a connection again... some things like that)
@@the_digitalpro Ah no, not yet! I will check it, thank you. For this offline functionality, is firebase required or does is it possible (but more difficult to implement) with supabase? :)
My God I just started learning flutter flow with your previous tutorials on creating UA-cam searcher. I was at the third video and was kinda worried at the lack of using firebase since I wanted to learn user authentication and you just dropped this! You're a life saver! Love your teaching methods from just the initial videos. Since I'm new, could you explain why you preferred supabase over regular firebase.
Hello thank you very much and glad you are enjoying my content. Appreciate it. To be fair I could have used Firebase for this application and Firebase integration is more mature than Supabase. I purely selected Supabase for this course on the basis that popularity has been increasing for Supabase and additionally Supabase works more like a relational database. However Supabase does have some shortcomings when it comes to integration with FlutterFlow. It's evolving but is not the powerhouse it could be or will be in the future. I do plan to do extended courses on using Firebase within FlutterFlow in the future including some lowcode training with using cloud functions. Watch this space!
What are the shortcomings? I got frustrated by the firebase api. The fact that supabase is relational and has good api and a great http extension makes me wanna go for supabase and never look back.. but now the supabase shortcoming start to worry me again. Why can’t there be just one clear winner her?!
@jimvh7557 Well it is great to have a choice but Firebase is clearly more integrated in FlutterFlow at this time so if you are new FlutterFlow it's a great choice. Supabase is emerging but I find it more suitable for me if I am prepared to accept general create, read, update and delete features in my app. You are also limited with only email auth with Supabase. In Firebase you have all the social types. It really does depend on your use case of course.
@@the_digitalpro It would be great if Supabase could catch up and be the better option as firebase won’t become relational like Supabase. It would be great to see a video where you show the differences in regards to FF. I mean, the 10 reasons why one would stick with firebase and the 10 reasons why one would choose Supabase when it comes to building a FF app. That might be an interesting series 😉 I have been so busy lately that I didn’t have time for FF. I hope to catch up soon. So my first dilemma will be which database to start building in. As Supabase seems to offer the best ‘backend’ I would go for that as long as it doesn’t block me. You think the social login thing will still be a while before they implement that for Supabase?
@jimvh7557 I really do believe the FlutterFlow team will catch up with Supabase watch this space. Your idea about a comparison video though is a great idea. A few content creators have produced videos covering their preferences for Supabase than Firebase but a more fuller video is certainly needed because it is not clear cut. I'll see what I can do. Thanks.
Steve, you move very quickly, and when there's a problem, one can spend hours trying to solve it. For example, by adding the first text box and using your template, FF creates a box that extends to the bottom of the column. When you insert the second container, it's inserted at the bottom of the column. Why is that? I can see that the second container doesn't auto-size. One line of text is squashed and disappears.
Your videos are awesome. Please keep going! Kindly upload them in higher resolution than HD if possible. Small fonts are often difficult to read. Might be the compression or something, but higher resolution should help.
digital pro....i dont even know what to say but thanks alot..i have not even started watching the course but i know you have spent countless amount of hours before releasing it and with ad free,,this is a nice move thanks alot
You are most welcome. My Patreon Page at www.thedigitalpro.co.uk/patreon is purely for the FlutterFlow community to want a little a more but my UA-cam channel will always remain the primary resource for key content. I.e Ad-free is on Patreon if people prefer to not be interrupted.
Wow! you are a great teacher. Please create a course like how to build a complex inventory system or ERP system or social media like Facebook. We are willing to pay for that kind of course as long as it's affordable for a person living in a third world country like me. Thank you. so much!!!
Great tut, Steve. You may have addressed this issue before, so pardon me for asking it again. At the time stamp of 2:12:34 Part 7, I cant see the goals row as an option to enable me complete the action even though I have the defined param (goal) passed. None of the presented options in the dialogue is applcable. What am I doing wrong? Thanks for your help and anyone who can assist.
Whoa mama!! 5 hours!!! This is great, thank you!!!! If there is any way to break down the details of the video further in the description, that might help for later reference! I’ve already spent so much time in supabase that I don’t feel I’d need to watch the whole 5 hours, but would love to be able to check out parts I may not be so familiar with.
Hi thank you. Unfortunately due to character limits within UA-cam I was unable to list the complete chapter points. I had to revert to Part 2, Part 3 etc. BUT of course anybody further down can click on the dedicated Episode to then read the chapter points.
Thanks for the course. It really fun doing this project and learning new things as i come from bubble environment. I actually did the entire project with firebase because i really want to understand firebase and do carry out my future project with it (personal preference). I just didn't know how to implement the functions and trigger events to update the goals taks and completed tasks. i will highly appreciate if you release some others tutorials using firebase. I'm ready to pay if needed. My Goal is to understand the CRUD operations using firebase and some complex scenarios using firebase. Thanks once more. I've subscribed to your channel because you expplain very well.
Hey thanks for your comment. Really good to hear of your different approach and of course this application could easily of been implemented using Firebase instead of Supabase. To answer your question about updating the tasks count this could be achieved using Cloud Functions in Firebase. FlutterFlow supports this. It would require some familiarity with writing a bit of code but ChatGPT could help you quite alot here if this is new to you.
I have a very bad habit of pausing the video and trying to replicate from memory, doing that i spent at least an hour trying to figure out why i couldn't create a task. All i had to do was continue watching the video and fix it quickly. Anyways MAKE SURE TO ALWAYS PASS THE USER ID DETAILS. This tutorial deserves 10000 likes, thanks so much
great job, thanks! I've enhanced the base project so that the container showing the % in the goal moves inline with the progress, ie 50% is in the middle, 100% far right, 0% far left. I used your code expression and replaced it with the linear formula 2x-1. Very cool! Question: When I delete a task, I would like to individual task to slide off the screen. I tried an animation on the listview but that applies to all items. Thoughts on how to animate the deletion of a child task?
im having a problem. after i add the list view, i follow your instructions to a KEY, the test task doesn't show up. The console doesn't show any bugs nor does flutterflow and I gotta tell ya im pretty stumped right about now. Great vid regardless.
Thanks for your helpful videos, Steve!! When you have a minute could you please explain why you chose to parse out the user_id from the JWT token (for the RLS policy), as opposed to using the following method? (auth.uid() = user_id) Thank you!! 😊
In FlutterFlow version 5, the State Management features have been reorganized to enhance user experience. Previously, state management options were accessible via a dedicated button in the user interface. In the latest version, these options are now integrated directly into the Properties Panel of individual widgets and pages.
eu vou assistir este curso com tanta dedicação ❤️ sempre quis aprender flutterflow e espero um dia ensinar e criar uma comunidade no meu país 🙌🏾! e se tiveres mais um curso seu completo eu faria sem pestanejar 🙋♂️! obrigado
Thank you for the video. Unfortunately, I'm stuck at 18 minutes because FlutterFlow's UI has already changed. When I make the FormContainer and put in the text while setting the padding to 32, it covers the Text-Widget. If I delete the Height value from the Container Properties or set it to Infinite, an error occurs somewhere along the way. Sadly I just coudlnt follow along and I tried 2 hours of figuring it out, I need help now : D.
Hello thank you very much for your comment. I would like to help you out but need to get my head around the problem. It appears whatever problem you have you are having difficulty very early. Sorry to ask such basic questions but can you confirm if you have started this page again from scratch? So if I try doing this I should see the same issue right? Can you confirm you are using the browser version of FlutterFlow and not the iPad version or the Desktop one? Thank you.
@@the_digitalpro The problem is with the first FormContainer and column you add for the Welcome Back and "Fill out the information..." Text objects... They don't stack properly within the FormContainer or Column. Then, when you add the Text Fields for username/password, they don't stack properly either. The FormContainer isn't expanding vertically. I imagine this has something to do with the new options for Expansion under Padding (Default, Flexible and Expanded) for the individual items. I experienced this in both the Mac and Web versions. I'll post if I figure it out. i.imgur.com/iY25BAF.png
@@the_digitalpro Changing the Expansion to "Default" for the FormContainer seems to have worked, although it is aligned to the bottom of the screen. - i.imgur.com/e3aphcQ.png EDIT: Changing the "My Goals" Text to "Default" for Expansion changed the alignment to match your video. i.imgur.com/b4gfJCs.png It seems most of the issues are being caused by the Expansion settings for an object not always being "default," so it may be worth adding an annotation or note to ensure that the Expansion for an object is set to "Default" if the alignment is off.
@@the_digitalpro Hi, I'm having the exact same problem as he is. The problem, as @bradgroux is suggesting, is that the "FormContainer" is not expanding when the padding of 32 is applied to the column. However, I cannot get it to work by setting the expansion to default like he is saying. So, as @stephenyao3918 suggests, changing the "FormContainer" height allows for the padding on the column contained within. I changed it to 120, and will continue forwards in the tutorial. EDIT : The "FormContainer" must be at a height of 160 to accommodate the padding on the second row of texts style EDIT 2 : I am stupid and should have followed @stephenyao3918's advice, just make sure everything is set to "default" expansion.
Steve, Great series. The archived settings (part 11) have changed in flutterflow. You now have options has field or data struct. Can you provide some guidance on how this should change? Thanks.
@@the_digitalpro for e.g. what you are showcasing at 57:18 (passwords must match) seems to happen 'out of the box' when I tested my app. The notification comes up from the bottom though.
Hi thank you. This is an interesting request. What kind of website are you thinking? In an ideal world FlutterFlow is best suited for webapps than brochureware websites.
@@the_digitalpro I'm working in a website to take sales order (customer, item, sales order/sales order detail, etc). A tutorial for something like that should be helpful for a lot of people around the world.
Hi Jim yes it is the full video series as one in a consistent video. It's mainly for new visitors to the channel who missed the previous content. Certainly more successful.
Good Day! Thanks for the videos. I'm stuck at the loading of the Goal Tasks page. It's supposed to display the list of tasks when a goal is tapped. I tap the Goal and it goes to the Goal Tasks page but all I am getting is a spinning circle. I've rewatched the part of the creation of the Goal Tasks page starting at 2:33:35 and have ensured everything was followed as per the instructions. Does anyone know what I might have done wrong?
@@the_digitalpro Yes, I can create a task (while there is a spinning circle) and I can verify it's being updated in database in the Tasks table (so then I know the goalID is being passed). Right now, it is still not displaying the list of tasks. And yes, I can create goals.
Absolutely 100%. FlutterFlow is awesome in creating web apps. And of course has excellent responsive capabilities which allow you to have 1 app across multiple devices.
Amazing stuff! Cannot thank you enough for this gem of a series however I have a question, Now am looking at an option in the setting where it says I can upload figma theme. Can you please make a tutorial on how we can import a theme from figma and then continue on flutterflow?
This is awesome. Question for you Steve, how difficult would it be to have the goals progress bar automatically get its value from the percentage of tasks completed? So if you had 2 out of 4 tasks completed, the progress bar would automatically be set at 50%. Is that possible? Having to manually drag the bar after checking each task seems a bit counterintuitive.
Hello. This is super easy to base it on total number of tasks against the number of tasks completed. You simply need to use a Code Expression and pass in both values. You then can do something like (tasks_completed / total_tasks) *100 This will return the total.
Hi, thanks for all the great content you have been providing. I have a request, Can you please make a short tutorial on building a chatbot using palm 2 API in Flutterflow by using the custom action method to call API instead of inbuild API calling method. Thanks in advance
Question for Supabase tables. I have three tables. Properties. Owners Tenant. I’m trying to find a way to link the 2nd and 3rd table to the 1st table that when I enter a property in first table the owner and tenant tables are also updated.
So you are saying each property can have 1 owner and 1 tenant is that correct? If so when you create a property you just need to add a owner_id and tenant_id to the properties table. If this is understood is it then your question about how to do this in FlutterFlow?
@@the_digitalpro Thanks for the answer. One property can have 1 tenant, but one owner can have multiple properties. Will the relationship be defined the same to create ID for both owner and tenant in properties table? And yes I will be linking these table back to flutterflow. The reason for my question is that when I am adding a property I have columns for Owner & Tenant's names, I want these names to be added to Owner and Tenant's table as well. Having separate tables for owners and tenants is because if I want to add further details to their profiles later on.
Hey, amazing stuff. I just finished this project with a few of my own personal touches. Was soo much fun building this. I've been able to fix all other issues that came across my "personal alterations" However, i've been trying to figure out how to create a conditional visibility builder to NOT show the FAB button when archived goals is turned on.
just figured it out haha. I couldnt create a conditional visibility builder because of wrapping issues Instead, I triggered normal conditional visibility by variable: app state -> filters -> available options (has field) -> field 'archived' I'mgoing to apply the same conditional logic to the "tap the + button to begin" text
Do you have a a video that explains how to set up different dashboards/visibility depending on a users role? Tried looking through your videos but couldn’t find any
Excellent tutorial. Thanks very much! Can you please add some useful required functionality such as 'forgot Password', 'Reset Password', 'Confirm Email' using deep linking?
Thank You So much your series helped me alot i watched the UA-cam Searcher, ChatGPT and now am working on the Goal Tracking App. i like supabase because it's relational database and there is no vendor-lock But flutter-flow doesn't support yet supabase social Authentication. is it possible to have a workaround? can you please make a video on how to do it if possbile? this will help alot thanks
Hello thank you for your suggestion. Yes this is more tricky from a no-code perspective. I've not quite perfected a good example of this yet but I am working on it in the background. I was trying to implement a Supabase Edge Function which is invoked via an API but I have not quite got this working right at the moment. WIP basically.
it would be super great if you make a same kinda video from scratch for firebase in flutterflow by connecting it using it in real time and all the related stuff . i wish u would have some time for that . looking forward for it :)
Currently stuck at 1:47:32 where I'm trying to add the `progress.round()` function, but when I click "Check Errors", the request keeps timing out. I try to confirm without checking, but then I get "Current variable is not valid", which is not very informative. Is there a way to check the status of FlutterFlow servers?
If you are enjoying this course and wish to support me why not join The Digital Pro's NoCode Academy? Please visit www.thedigitalpro.co.uk/. All content is ad-free, a private community awaits and further articles which you might find useful. Most importantly of course it supports the building of further engaging content across both UA-cam and the Academy. Thank you everyone and enjoy the content.
Why is my new goal and new tasks not showing up on respective pages as soon as they are created? It seems there is no page refresh happening. This is even after i see the database records created in supabase. For the goals (homepage) the new goals show up after restart but not so for the new tasks on the taskpage
I can't open the base project on web it's slow and not responding i had to download the flutterflow desktop app Please how do i open the base project in the flutterflow desktop app.
1:09:22 for some reason when I test my app, it shows up in dark mode by default. Toggling the light/dark mode button in the test mode changes the browser background to dark and light mode but the app stays on dark mode. What could I be doing wrong?
Ah this is expected. During the recording of the series something changed in FlutterFlow. This application does not support the changing of themes to a dark mode. What you need to do is go in to the Theme Settings and switch off the dark mode palette leaving only the light mode one toggled on. This will resolve the problem.
Hi Steve! I'm so frustrated. :( I followed the first hour and a half carefully but when I run it to sign up, it keeps telling me "Has to be a valid email address." Would you happen to know what the problem could be? I'm using the correct email address format. I would really appreciate your help. I'm so down.
Trying to understand why we can't use the same component (since everyone recommends reusability) to Create and Update, instead of making two of the same forms with different actions? I'm still new to flutterflow.
Excellent tutorial... but I "urrghed" at the point of counts... Couldnt that just have been a "sub-query " count like count (select * table name). I loved I learnt Supabase triggers but really.. a trigger just for counts.. where's the sql in supabase ?
Thank you. Of course a count would also be a great option. So the tutorial was more focused at performing as close to nocode as possible and this approach was a simple and effective option for a low powered utility application. Infact actually no additional query was needed to track the counts. Similarly we could have gone down the route of an Edge function or if it was firebase it could have been a cloud function to keep a tab on the task counts.
@@the_digitalpro thats Awesome & thoughtful. Thanks for putting food on my table. We'd need more like this coz i know alot of us attracted to Supabase because its the relational database we are used to rather than firebase nosql. Next interests are - User profile table (to save user-custom data like user name,title, role, address) that connects to user-auth, - Possiblity of custom Auto-incremented IDs or columns (staff-001-xxx, staff-002-xyz, staff-003-ijk, - table Query aggregates: sum, count (of table) Off to research these & THANKS if you choose add to some in your next project 👍😁
I'm Buildng an event app with flutterflow & firbase. I want events to be deleted automatically once the event is over. How can I do that? I'm storing event end time in my firebase database.
Hello. You would need a cloud function to perform this. FlutterFlow now supports Firebase Cloud Functions within the platform itself. Do a little research on cloud functions and you should be good.
I'm stuck on a authorization for some reason 😅. When I press "signup" it doesn't do anything adn a new user is not being created in the supabase. I tried chacking the network data in the developer tools and I found that when I click the "signup" button there appear 2 red "signup" row with crosses infront of them. I rewatched the supabase setup part but still no progress😔.
Hello. How long ago did you create your supabase database? As a double check can you create another temporary database and try hooking that up to FlutterFlow to test the authentication. Just to eliminate the database you have been working on.
@@the_digitalpro Thanks a lot for the response! What I found working for me was replacing was replacing the "((auth.jwt() ->> 'sub'::text) = user_id)" line with "(auth.uid() = user_id)" and it works fine. Just wanted to clarify: Are there any problems with using my method?
@@rigasymov Thank you for coming back. Both techniques actually do the same thing. I will take a look myself but I was totally unaware of any issues with using the one shown in the video. Super strange!
hello, is not working for me as well CREATE POLICY "user_policy" ON "public"."user_auth" AS PERMISSIVE FOR ALL TO public USING (((auth.jwt() ->> 'sub'::text) = user_id)) WITH CHECK (((auth.jwt() ->> 'sub'::text) = user_id))
45min in.. so far so good 👍 Quick question, but can I generate my Supabase users and passwords through the api, so generate them based on user info in a different system. I know I can just feed my tables with the api, but can I also feed it its users?
Seems I just need to post a signup then. Will have to give that a try. The amazing thing about your channel is your feedback and interaction. It’s really amazing 😎
Hey Jim great. Its more that FlutterFlow is just further forward with integration with Firebase. I.e the new v4 feature allows you to utilise Cloud Functions within Firebase from FlutterFlow. In Supabase you have Edge Functions which I have a video on within the Supabase section. Edge Functions have to be handled externally outside of FlutterFlow. But don't let that put you off. I really enjoy using Supabase and it feels more at home to me as a relational database.
@@the_digitalpro The relational part, visualiser and row level security are indeed game changers for me. Those combined with a very user friendly API makes it the platform of choice for a business platform. I’ll have to dig into the functions. But UA-cam is such a big help when it comes to learning these tools. You make a big difference!!! Tx!! What I can’t understand is that after all this time FF still doesn’t offer you a business invoice so we can get the VAT refunded. It’s about time they do. Most of us users are a business so it makes a lot of sense right.
Can you connect FF to a Supabase Query which combines data of 2 tables so you can show the combined data in a listview without having to write extra code? As Supabase is a relational database that would be something obvious that one would like to do no? So I would like to list data from 2 tables in 1 list. Is that already possible. I don't see my queries in the FF schemas.
After some decent research I figured it out. Seems I need to do an api call for that where I combine the data of two tables. I don't think I can create a schema for a query, right?! Then bind that resultset to a listview (a bit different/less easy than for a regular table but with the help of your previous tutorials I did manage) and voila! It works :) That really shows the advantage of using Supabase over Firebase :) Now all I have to figure out is how to do this with RLS enabled. I think I need to pass the user_id then to make it work. Your help and feedback on this channel really got me going!! Tx.
Thank you for pointing that out. Hope it was not too much trouble working out the changes. I need to do a replacement video on this specific topic to bring it up to date.
Hello again. I am planning a course for early 2024 which covers Firebase but nothing released just yet. Thank you for subscribing and hope there is further content which you will find useful on my channel.
White creating the table when I click save after adding all colums I get the error like this: "Failed to create, in valid URL". Please help me solving this.
On "Create Account" is shows on all "Create account" page fields "Chose from drop down options". Does not create account. Followed your video. Tried 2 times from scratch.
56:56 on pressing the button under each field appear: "chose the value from the drop down". Did not set any drop-downs. Followed the video exactly as it is.
@Novogod I'm trying to follow your description and not entirely sure of the exact problem. So my suggestion would be initially is to make sure you are NOT using any form validation. You want to keep it really simple in trying to work out the problem. The key thing you need to do is focus on purely just getting thr accout create submitting first so simplify what you are doing in an attempt to narrow down the problem.
I am really confused to why you are getting this error. Order is not a field in the walkthrough. Have you walked through step by step or clicked on a link to a sample?
@@the_digitalproThank you, sir, for your help, but I fixed the error. In the walkthrough, by mistake, you didn't provide the type of submit button in the action flow editor. Once I added the type and set the value to 0, the error was fixed.
I couldn't get the triggers working, also I couldn't mark the tasks as complete. All because in my table instead of "no_tasks_completed" I mistyped "no_taks_connected." (Lol I did that part in a noisy Starbucks). Long story short, because of the typo the SQL wouldn't work. Be careful in the setup.
@@the_digitalpro Thank you for responding. Sorry, my bad. The UI has been changed a bit, so i didn't see all the pages. Now I can. Love your tutorials btw
Uncaught Error: PostgrestException(message: relation "goals" does not exist, code: 42P01, details: , hint: null). imm getting this error at 4:01:52. Could you explain what i'm doing wrong? BEGIN IF (TG_OP = 'INSERT') THEN -- Increment the no_tasks field in the goals table UPDATE goals SET no_tasks = no_tasks + 1 WHERE id = NEW.goal_id; RETURN NEW; END IF; RETURN NULL; -- Return NULL for unsupported operations END;
@@the_digitalpro Found it finally, the bug was that the table name was uppercase. Supabase does not support uppercase table names in order to use in triggers or functions.
🔥 Looking for more content, further content, and a helpful community? Why not consider joining The Digital Pro's #Nocode Academy at www.thedigitalpro.co.uk
You should be the ambassador of the century... why all this patience? Passion? And competence? Like its my first time meeting a teacher... well thank for everything sir
My favorite teacher on FlutterFlow!
You are so kind thank you so much.
4:05:44 For those that are unable to update a task and are getting the trigger error in console, don't forget to add the ELSEIF (TG_OP = 'UPDATE') statement as well in the update_goal_task_count function.
Ah you are a superstar thank you for your comment. I was not aware of an issue here and this helps others. It's a shame I cannot update the videos on UA-cam to support any challenges or changes.
@@the_digitalpro you're the real superstar for creating this exceptional content and sharing with us! Thank you! Learning a ton from you. BTW, I posted this comment shortly before I realized you added the second trigger update_goal_task_completed_count with the UPDATE event. So I went back into my update_goal_task_count function and deleted the ELSEIF (TG_OP = 'UPDATE') statement to see if the error persisted and it did. I then went back in Supabase and disabled the first trigger (update_goal_task_count) and recreated it without the UPDATE event checked. That seemed to work. Otherwise you'd have to add the UPDATE ELSEIF statement to both triggers and make sure that the no_tasks is not incremented for an update.
Without your call out of using console to debug earlier in this lesson, I'm certain I would have been stuck for some time on this issue!
You are a life saver @DanVanDamme 🤟I think we should combine two functions and triggers or uncheck the UPDATE for the first trigger. Because when we update a task, it looks for a return for update in first function.
@DanVanDamme @the_digitalpro Hey there, I'm finding now after adding the triggers to the update_goal_task_count I can't seem to tick the completed box within the task at all. Stuck on this point at the moment and I was just wondering if you could have any idea as to why this would be occurring?
Please disregard my comment, I've found the solution. I went to the playlist for the individual episodes to episode 12, in the comments had the solution. In Supabase update_goal_tasks_completed_count function,
SET no_tasks_completed = no_tasks_completed + 1
WHERE id = NEW.goal_id;
ELSIF (NEW.complete = false) THEN
UPDATE goals
SET no_tasks_completed = no_tasks_completed - 1
no_tasks_completed originally did not have a "d" on the end.
Also in the no_goal_tasks_count function I needed to add "RETURN NEW;" on line 13.
if you are scrolling for comments there is one thing i will tell you "follow the course entirely you would not regret it" trust me
took your advice and yes i did not regret any of it. took me longer than the video length i had to keep pausing it and rewinding it to make sure i understood a concept before going forward
I am completely new to fluffer flow... what do I do ?
@@dinorossi6611 start
@@dinorossi6611 learn basics and implement that
I always appreciate the level of effort that went into creating such an organized tutorial. This is so good. Well explained. Well structured. Professionally designed. I've started sharing your videos with my friends. Well done and huge huge thanks.
This is amazing thank you for such generous feedback. I am really pleased you like my content and appreciate you bringing your friends to channel. Thank you so much.
I am now at minute 1:05 , and when I heard the phrase 'we will put all the hard work on the server side,' I felt an extraordinary happiness. This is because this is the first course that will explain these things using Supabase. This exactly what I want 😍😍😍 thank you sir 👮
I am a flutter developer and I've never used FlutterFlow before is that course will be convenient for me? 🥲
No problem at all. Thank you very much for your kind words. Also in one of my more recent videos I show you how to setup Edge functions as delete users. This is a pretty useful video too.
@@the_digitalpro Hi. There is nothing in the base project; just a homepage. I am talking about the link in the description. Please help.
So thankful for your videos! Very helpful! Great man!
Thank you very much. Glad ypu found it useful.
Great job! Thank you so much for such am efficent course!
Thank you very much. 👍
I just finished following the tutorial! Thank you so much for making it! It really helped me get some of the basics of flutterflow and supabase. I am now going to follow you 2024 series :)!
You are so welcome! Enjoy the 2024 series. Some stuff has already been covered but this is more of a slow paced series. It progressively gets more advanced.
@@the_digitalpro Awesome!
I was wondering:
Will you cover also how to manage offline data? (so for example using supabase, caching the data so the app can still be used offline and then syncs when it has a connection again... some things like that)
Did you see one of my recent buildship videos which did something similar with Firebase?
@@the_digitalpro Ah no, not yet! I will check it, thank you. For this offline functionality, is firebase required or does is it possible (but more difficult to implement) with supabase? :)
@@the_digitalpro I did some quick research and it seems that if I want to use supabase, I'll need to use 'powersync' to easily set up offline syncing
My God I just started learning flutter flow with your previous tutorials on creating UA-cam searcher. I was at the third video and was kinda worried at the lack of using firebase since I wanted to learn user authentication and you just dropped this! You're a life saver! Love your teaching methods from just the initial videos. Since I'm new, could you explain why you preferred supabase over regular firebase.
Hello thank you very much and glad you are enjoying my content. Appreciate it. To be fair I could have used Firebase for this application and Firebase integration is more mature than Supabase. I purely selected Supabase for this course on the basis that popularity has been increasing for Supabase and additionally Supabase works more like a relational database. However Supabase does have some shortcomings when it comes to integration with FlutterFlow. It's evolving but is not the powerhouse it could be or will be in the future. I do plan to do extended courses on using Firebase within FlutterFlow in the future including some lowcode training with using cloud functions. Watch this space!
What are the shortcomings? I got frustrated by the firebase api. The fact that supabase is relational and has good api and a great http extension makes me wanna go for supabase and never look back.. but now the supabase shortcoming start to worry me again. Why can’t there be just one clear winner her?!
@jimvh7557 Well it is great to have a choice but Firebase is clearly more integrated in FlutterFlow at this time so if you are new FlutterFlow it's a great choice. Supabase is emerging but I find it more suitable for me if I am prepared to accept general create, read, update and delete features in my app. You are also limited with only email auth with Supabase. In Firebase you have all the social types. It really does depend on your use case of course.
@@the_digitalpro It would be great if Supabase could catch up and be the better option as firebase won’t become relational like Supabase. It would be great to see a video where you show the differences in regards to FF. I mean, the 10 reasons why one would stick with firebase and the 10 reasons why one would choose Supabase when it comes to building a FF app. That might be an interesting series 😉 I have been so busy lately that I didn’t have time for FF. I hope to catch up soon. So my first dilemma will be which database to start building in. As Supabase seems to offer the best ‘backend’ I would go for that as long as it doesn’t block me. You think the social login thing will still be a while before they implement that for Supabase?
@jimvh7557 I really do believe the FlutterFlow team will catch up with Supabase watch this space. Your idea about a comparison video though is a great idea. A few content creators have produced videos covering their preferences for Supabase than Firebase but a more fuller video is certainly needed because it is not clear cut. I'll see what I can do. Thanks.
Great job on this tutorial. Thanks for all the effort you put into this.
You are most welcome
Steve, you move very quickly, and when there's a problem, one can spend hours trying to solve it. For example, by adding the first text box and using your template, FF creates a box that extends to the bottom of the column. When you insert the second container, it's inserted at the bottom of the column. Why is that? I can see that the second container doesn't auto-size. One line of text is squashed and disappears.
Wow! This is an amazing, structured, and comprehensive course 👍👍👍👍👍
Your videos are awesome. Please keep going! Kindly upload them in higher resolution than HD if possible. Small fonts are often difficult to read. Might be the compression or something, but higher resolution should help.
Thank you very much. 4k is my goal but held back on the technical side. Once the channel is established it will be my next investment I promise.
@@the_digitalpro Hi. There is nothing in the base project; just a homepage. I am talking about the link in the description. Please help.
Amazing tutorial. So clean!
Really great tutorial! Very well articulated and explained.
Thank you very much for your kind feedback. It is very much appreciated!
@@the_digitalpro Hi. There is nothing in the base project; just a homepage. I am talking about the link in the description. Please help.
Just completed this video. Thanks!
wonderful. thank you for your effırt for this. one of the bests among I've seen.
Wow, thank you! Really appreciate your kind word's 🙏
Thank u soooooo much for sharing.
You are so welcome
Thank you for this, your videos and teaching skills are fantastic 💯😃👍
You are so kind thank you very much.
digital pro....i dont even know what to say but thanks alot..i have not even started watching the course but i know you have spent countless amount of hours before releasing it and with ad free,,this is a nice move thanks alot
You are most welcome. My Patreon Page at www.thedigitalpro.co.uk/patreon is purely for the FlutterFlow community to want a little a more but my UA-cam channel will always remain the primary resource for key content. I.e Ad-free is on Patreon if people prefer to not be interrupted.
@@the_digitalpro great will be in the process
@@the_digitalpro digital pro if I may ask if I join your patreon can you please mentor me ? Even for a week please ?
I am so grateful for this OMG. Thank-you.
Wow! you are a great teacher. Please create a course like how to build a complex inventory system or ERP system or social media like Facebook. We are willing to pay for that kind of course as long as it's affordable for a person living in a third world country like me. Thank you. so much!!!
Great tut, Steve. You may have addressed this issue before, so pardon me for asking it again. At the time stamp of 2:12:34 Part 7, I cant see the goals row as an option to enable me complete the action even though I have the defined param (goal) passed. None of the presented options in the dialogue is applcable. What am I doing wrong? Thanks for your help and anyone who can assist.
this issue has been resolved.. it is a user error on my part
Hope you can do a tutorial using Flutterflow with Supabase to create a POS application (point of sale). Thanks!
Nice nice nice! I want to join the membership, is there any tutorial on creating a courier app?
Whoa mama!! 5 hours!!! This is great, thank you!!!! If there is any way to break down the details of the video further in the description, that might help for later reference! I’ve already spent so much time in supabase that I don’t feel I’d need to watch the whole 5 hours, but would love to be able to check out parts I may not be so familiar with.
Hi thank you. Unfortunately due to character limits within UA-cam I was unable to list the complete chapter points. I had to revert to Part 2, Part 3 etc. BUT of course anybody further down can click on the dedicated Episode to then read the chapter points.
Thanks for the course. It really fun doing this project and learning new things as i come from bubble environment. I actually did the entire project with firebase because i really want to understand firebase and do carry out my future project with it (personal preference). I just didn't know how to implement the functions and trigger events to update the goals taks and completed tasks. i will highly appreciate if you release some others tutorials using firebase. I'm ready to pay if needed. My Goal is to understand the CRUD operations using firebase and some complex scenarios using firebase. Thanks once more. I've subscribed to your channel because you expplain very well.
Hey thanks for your comment. Really good to hear of your different approach and of course this application could easily of been implemented using Firebase instead of Supabase. To answer your question about updating the tasks count this could be achieved using Cloud Functions in Firebase. FlutterFlow supports this. It would require some familiarity with writing a bit of code but ChatGPT could help you quite alot here if this is new to you.
@@the_digitalpro ok i'll check the documentations on cloud functions. I have no problem writing code.
I have a very bad habit of pausing the video and trying to replicate from memory, doing that i spent at least an hour trying to figure out why i couldn't create a task. All i had to do was continue watching the video and fix it quickly. Anyways MAKE SURE TO ALWAYS PASS THE USER ID DETAILS. This tutorial deserves 10000 likes, thanks so much
Awesome thank you for your kind words. The approach of pausing and using memory is a masterstroke to learn and retain. Great work 👏
great job, thanks! I've enhanced the base project so that the container showing the % in the goal moves inline with the progress, ie 50% is in the middle, 100% far right, 0% far left. I used your code expression and replaced it with the linear formula 2x-1. Very cool! Question: When I delete a task, I would like to individual task to slide off the screen. I tried an animation on the listview but that applies to all items. Thoughts on how to animate the deletion of a child task?
There is nothing in the base project; just a homepage. I am talking about the link in the description.
im having a problem. after i add the list view, i follow your instructions to a KEY, the test task doesn't show up. The console doesn't show any bugs nor does flutterflow and I gotta tell ya im pretty stumped right about now. Great vid regardless.
Hi. Can you point me to where you are in the video? Just the timestamp.
2:00:38 I was booting up the after following these processes and wasn't able to see any of the test tasks from the listview@@the_digitalpro
@@the_digitalprosame here 2:01:48 non of my lists show up but they are in supabase. Thanks for the video!
Thanks for your helpful videos, Steve!!
When you have a minute could you please explain why you chose to parse out the user_id from the JWT token (for the RLS policy), as opposed to using the following method?
(auth.uid() = user_id)
Thank you!! 😊
do you show how to use buildship in this course? also quick question, I know FlutterFlow creates ios and Android apps but can it also create web apps?
In FlutterFlow version 5, the State Management features have been reorganized to enhance user experience. Previously, state management options were accessible via a dedicated button in the user interface. In the latest version, these options are now integrated directly into the Properties Panel of individual widgets and pages.
I can't get into 'for full customization'. How can I use 'for full customization'? 36:26
eu vou assistir este curso com tanta dedicação ❤️ sempre quis aprender flutterflow e espero um dia ensinar e criar uma comunidade no meu país 🙌🏾! e se tiveres mais um curso seu completo eu faria sem pestanejar 🙋♂️! obrigado
muito obrigado pelo seu gentil feedback. 👍
Thank you for the video. Unfortunately, I'm stuck at 18 minutes because FlutterFlow's UI has already changed. When I make the FormContainer and put in the text while setting the padding to 32, it covers the Text-Widget. If I delete the Height value from the Container Properties or set it to Infinite, an error occurs somewhere along the way. Sadly I just coudlnt follow along and I tried 2 hours of figuring it out, I need help now : D.
Hello thank you very much for your comment. I would like to help you out but need to get my head around the problem. It appears whatever problem you have you are having difficulty very early. Sorry to ask such basic questions but can you confirm if you have started this page again from scratch? So if I try doing this I should see the same issue right? Can you confirm you are using the browser version of FlutterFlow and not the iPad version or the Desktop one? Thank you.
@@the_digitalpro The problem is with the first FormContainer and column you add for the Welcome Back and "Fill out the information..." Text objects... They don't stack properly within the FormContainer or Column. Then, when you add the Text Fields for username/password, they don't stack properly either. The FormContainer isn't expanding vertically. I imagine this has something to do with the new options for Expansion under Padding (Default, Flexible and Expanded) for the individual items.
I experienced this in both the Mac and Web versions. I'll post if I figure it out. i.imgur.com/iY25BAF.png
@@the_digitalpro Changing the Expansion to "Default" for the FormContainer seems to have worked, although it is aligned to the bottom of the screen. - i.imgur.com/e3aphcQ.png
EDIT: Changing the "My Goals" Text to "Default" for Expansion changed the alignment to match your video. i.imgur.com/b4gfJCs.png
It seems most of the issues are being caused by the Expansion settings for an object not always being "default," so it may be worth adding an annotation or note to ensure that the Expansion for an object is set to "Default" if the alignment is off.
yah so i just changed it to fixed height instead of unlimited for the FormContainer
@@the_digitalpro Hi, I'm having the exact same problem as he is. The problem, as @bradgroux is suggesting, is that the "FormContainer" is not expanding when the padding of 32 is applied to the column.
However, I cannot get it to work by setting the expansion to default like he is saying.
So, as @stephenyao3918 suggests, changing the "FormContainer" height allows for the padding on the column contained within. I changed it to 120, and will continue forwards in the tutorial.
EDIT : The "FormContainer" must be at a height of 160 to accommodate the padding on the second row of texts style
EDIT 2 : I am stupid and should have followed @stephenyao3918's advice, just make sure everything is set to "default" expansion.
Steve, Great series. The archived settings (part 11) have changed in flutterflow. You now have options has field or data struct. Can you provide some guidance on how this should change? Thanks.
Hi Jess. Can you provide me the time stamp in the video to the location you are having the problem with? This would be really helpful. Many thanks.
steve, please make a quiz app and we really love to watch it from you....thank you.
1:52:32 when I load up the screen, just shows me a blank screen and cannot see anything
Looks like the auth prompts that you manually entered are automatically available now?
Hello. Thanks for the message. Can you confirm approx what the time stamp of the video you discovered this? Thank you.
@@the_digitalpro for e.g. what you are showcasing at 57:18 (passwords must match) seems to happen 'out of the box' when I tested my app. The notification comes up from the bottom though.
Can you please make a chat app and teach with firebase connection
Excellent video. Can you do a tutorial with flutterflow + supabase for website ? thank you.
Hi thank you. This is an interesting request. What kind of website are you thinking? In an ideal world FlutterFlow is best suited for webapps than brochureware websites.
@@the_digitalpro I'm working in a website to take sales order (customer, item, sales order/sales order detail, etc). A tutorial for something like that should be helpful for a lot of people around the world.
Is this one the combination of all the other videos in this playlist? I need to buy some time to check it out. It looks amazing.
Hi Jim yes it is the full video series as one in a consistent video. It's mainly for new visitors to the channel who missed the previous content. Certainly more successful.
Hi saludos desde colombia
Good Day! Thanks for the videos. I'm stuck at the loading of the Goal Tasks page. It's supposed to display the list of tasks when a goal is tapped. I tap the Goal and it goes to the Goal Tasks page but all I am getting is a spinning circle. I've rewatched the part of the creation of the Goal Tasks page starting at 2:33:35 and have ensured everything was followed as per the instructions. Does anyone know what I might have done wrong?
Hi this is strange. Can I validate with you that you have so far been unable to create any tasks at all? But you can correctly create goals okay?
@@the_digitalpro Yes, I can create a task (while there is a spinning circle) and I can verify it's being updated in database in the Tasks table (so then I know the goalID is being passed). Right now, it is still not displaying the list of tasks. And yes, I can create goals.
Can I use flutterflow to build web apps?
Absolutely 100%. FlutterFlow is awesome in creating web apps. And of course has excellent responsive capabilities which allow you to have 1 app across multiple devices.
Indeed, More Cross-Platform Web App Tutorials are the Future ✨️
Please make a Video with supabase auth. Not Just create Account also verifiy Email address process and forget password process. Please
Amazing stuff! Cannot thank you enough for this gem of a series however I have a question, Now am looking at an option in the setting where it says I can upload figma theme. Can you please make a tutorial on how we can import a theme from figma and then continue on flutterflow?
Can you help me create a relationship between 2 API endpoints? like you do in 43:25
This is awesome. Question for you Steve, how difficult would it be to have the goals progress bar automatically get its value from the percentage of tasks completed? So if you had 2 out of 4 tasks completed, the progress bar would automatically be set at 50%. Is that possible?
Having to manually drag the bar after checking each task seems a bit counterintuitive.
Hello. This is super easy to base it on total number of tasks against the number of tasks completed. You simply need to use a Code Expression and pass in both values. You then can do something like (tasks_completed / total_tasks) *100
This will return the total.
4:36:33 adding in the above suggestion was a nice surprise! Thanks for this Steve!
Do you cover repeated/scheduling tasks in this video?
No unfortunately this is not covered in this series.
Hi, thanks for all the great content you have been providing. I have a request, Can you please make a short tutorial on building a chatbot using palm 2 API in Flutterflow by using the custom action method to call API instead of inbuild API calling method. Thanks in advance
Sure I'll take a look at this. Palm 2 is certainly gaining popularity. Thanks.
hello, thank you for the tutorial
does it include how to setup push notification using Supabase ?
No the tutorial does not cover push notifications. Sorry
Question for Supabase tables.
I have three tables.
Properties.
Owners
Tenant.
I’m trying to find a way to link the 2nd and 3rd table to the 1st table that when I enter a property in first table the owner and tenant tables are also updated.
So you are saying each property can have 1 owner and 1 tenant is that correct? If so when you create a property you just need to add a owner_id and tenant_id to the properties table. If this is understood is it then your question about how to do this in FlutterFlow?
@@the_digitalpro Thanks for the answer. One property can have 1 tenant, but one owner can have multiple properties. Will the relationship be defined the same to create ID for both owner and tenant in properties table? And yes I will be linking these table back to flutterflow. The reason for my question is that when I am adding a property I have columns for Owner & Tenant's names, I want these names to be added to Owner and Tenant's table as well. Having separate tables for owners and tenants is because if I want to add further details to their profiles later on.
Hey, amazing stuff. I just finished this project with a few of my own personal touches. Was soo much fun building this.
I've been able to fix all other issues that came across my "personal alterations"
However, i've been trying to figure out how to create a conditional visibility builder to NOT show the FAB button when archived goals is turned on.
just figured it out haha.
I couldnt create a conditional visibility builder because of wrapping issues
Instead, I triggered normal conditional visibility by variable: app state -> filters -> available options (has field) -> field 'archived'
I'mgoing to apply the same conditional logic to the "tap the + button to begin" text
Is there a way to add Material 3 to Flutterflow?
No, at the moment I do not think this is possible. Customisation would be needed once code has been downloaded but this is irreversible.
Do you have a a video that explains how to set up different dashboards/visibility depending on a users role? Tried looking through your videos but couldn’t find any
This is a really popular request and I have something being planned for it. Thanks for mentioning it.
@@the_digitalpro that’s great looking forward to tuning in for that. Just subscribed 👍
@@wheres_bears1378 awesome thanks. 👌
Excellent tutorial. Thanks very much! Can you please add some useful required functionality such as 'forgot Password', 'Reset Password', 'Confirm Email' using deep linking?
Thank You So much your series helped me alot i watched the UA-cam Searcher, ChatGPT and now am working on the Goal Tracking App. i like supabase because it's relational database and there is no vendor-lock But flutter-flow doesn't support yet supabase social Authentication. is it possible to have a workaround? can you please make a video on how to do it if possbile? this will help alot thanks
@thedigitalpro I would love a video about how to allow users to reset their passwords. I can't find a decent tutorial anywhere.
Hello thank you for your suggestion. Yes this is more tricky from a no-code perspective. I've not quite perfected a good example of this yet but I am working on it in the background. I was trying to implement a Supabase Edge Function which is invoked via an API but I have not quite got this working right at the moment. WIP basically.
@@the_digitalpro Damn, if you have't figured it out....God save us all! 😅
it would be super great if you make a same kinda video from scratch for firebase in flutterflow by connecting it using it in real time and all the related stuff . i wish u would have some time for that . looking forward for it :)
Currently stuck at 1:47:32 where I'm trying to add the `progress.round()` function, but when I click "Check Errors", the request keeps timing out. I try to confirm without checking, but then I get "Current variable is not valid", which is not very informative. Is there a way to check the status of FlutterFlow servers?
Looks like it's working again after half an hour 😵
If you are enjoying this course and wish to support me why not join The Digital Pro's NoCode Academy? Please visit www.thedigitalpro.co.uk/. All content is ad-free, a private community awaits and further articles which you might find useful. Most importantly of course it supports the building of further engaging content across both UA-cam and the Academy. Thank you everyone and enjoy the content.
Why is my new goal and new tasks not showing up on respective pages as soon as they are created? It seems there is no page refresh happening. This is even after i see the database records created in supabase. For the goals (homepage) the new goals show up after restart but not so for the new tasks on the taskpage
Any ideas on why when you add the Text_Style_Heading Widget Styling it makes the text span the rest of the container vertically?
That's interesting. Can you recall the approximate location in the video this was an issue?
Hello folks, my application is running fine on the 'Preview' Mode but the homepage is being shown blank on testing. Can anyone help me with this?
I can't open the base project on web it's slow and not responding i had to download the flutterflow desktop app Please how do i open the base project in the flutterflow desktop app.
Hello. I've just checked app.flutterflow.io/project/my-goals-base-project-n4wt7d and it appears to be working fine for me. Please try again.
How to add any Dialogue while Logout, Deleting the goals/tasks ?
1:09:22 for some reason when I test my app, it shows up in dark mode by default. Toggling the light/dark mode button in the test mode changes the browser background to dark and light mode but the app stays on dark mode. What could I be doing wrong?
Ah this is expected. During the recording of the series something changed in FlutterFlow. This application does not support the changing of themes to a dark mode. What you need to do is go in to the Theme Settings and switch off the dark mode palette leaving only the light mode one toggled on. This will resolve the problem.
are you teaching Firebase aswell? or is just better to use Supabase?
Quick question please: Is there a way in FLutterFLow to run SQL statements. If not, is there a way to filter using the LIKE operator?
Cheers
Yes, cross to Api
Supabase database insert action for GoalSubmitButton is missing required field "type". please provide solution ,
Could you teach us how to implement supabase with maps on flutterflow?
Hi Steve! I'm so frustrated. :( I followed the first hour and a half carefully but when I run it to sign up, it keeps telling me "Has to be a valid email address." Would you happen to know what the problem could be? I'm using the correct email address format. I would really appreciate your help. I'm so down.
Trying to understand why we can't use the same component (since everyone recommends reusability) to Create and Update, instead of making two of the same forms with different actions? I'm still new to flutterflow.
Excellent tutorial... but I "urrghed" at the point of counts... Couldnt that just have been a "sub-query " count like count (select * table name). I loved I learnt Supabase triggers but really.. a trigger just for counts.. where's the sql in supabase ?
Thank you. Of course a count would also be a great option. So the tutorial was more focused at performing as close to nocode as possible and this approach was a simple and effective option for a low powered utility application. Infact actually no additional query was needed to track the counts. Similarly we could have gone down the route of an Edge function or if it was firebase it could have been a cloud function to keep a tab on the task counts.
@@the_digitalpro thats Awesome & thoughtful. Thanks for putting food on my table. We'd need more like this coz i know alot of us attracted to Supabase because its the relational database we are used to rather than firebase nosql.
Next interests are
- User profile table (to save user-custom data like user name,title, role, address) that connects to user-auth,
- Possiblity of custom Auto-incremented IDs or columns (staff-001-xxx, staff-002-xyz, staff-003-ijk,
- table Query aggregates: sum, count (of table)
Off to research these & THANKS if you choose add to some in your next project 👍😁
The text styles arent working for me. I guess its padding looks different. Did they change this feature?
I found the difference. It's about the expansion mode. Just change to the first (left) mode.
I'm Buildng an event app with flutterflow & firbase. I want events to be deleted automatically once the event is over. How can I do that? I'm storing event end time in my firebase database.
Hello. You would need a cloud function to perform this. FlutterFlow now supports Firebase Cloud Functions within the platform itself. Do a little research on cloud functions and you should be good.
I'm stuck on a authorization for some reason 😅. When I press "signup" it doesn't do anything adn a new user is not being created in the supabase. I tried chacking the network data in the developer tools and I found that when I click the "signup" button there appear 2 red "signup" row with crosses infront of them.
I rewatched the supabase setup part but still no progress😔.
Hello. How long ago did you create your supabase database? As a double check can you create another temporary database and try hooking that up to FlutterFlow to test the authentication. Just to eliminate the database you have been working on.
@@the_digitalpro Thanks a lot for the response! What I found working for me was replacing was replacing the "((auth.jwt() ->> 'sub'::text) = user_id)" line with "(auth.uid() = user_id)" and it works fine.
Just wanted to clarify: Are there any problems with using my method?
@@rigasymov Thank you for coming back. Both techniques actually do the same thing. I will take a look myself but I was totally unaware of any issues with using the one shown in the video. Super strange!
hello,
is not working for me as well
CREATE POLICY "user_policy" ON "public"."user_auth"
AS PERMISSIVE FOR ALL
TO public
USING (((auth.jwt() ->> 'sub'::text) = user_id))
WITH CHECK (((auth.jwt() ->> 'sub'::text) = user_id))
14:00
45min in.. so far so good 👍 Quick question, but can I generate my Supabase users and passwords through the api, so generate them based on user info in a different system. I know I can just feed my tables with the api, but can I also feed it its users?
Seems I just need to post a signup then. Will have to give that a try. The amazing thing about your channel is your feedback and interaction. It’s really amazing 😎
It works, so now Supabase is officially fantastic for me. Apart from the social logins I’m now very curious about the drawbacks you mentioned 😊
Hey Jim great. Its more that FlutterFlow is just further forward with integration with Firebase. I.e the new v4 feature allows you to utilise Cloud Functions within Firebase from FlutterFlow. In Supabase you have Edge Functions which I have a video on within the Supabase section. Edge Functions have to be handled externally outside of FlutterFlow. But don't let that put you off. I really enjoy using Supabase and it feels more at home to me as a relational database.
@@the_digitalpro The relational part, visualiser and row level security are indeed game changers for me. Those combined with a very user friendly API makes it the platform of choice for a business platform. I’ll have to dig into the functions. But UA-cam is such a big help when it comes to learning these tools. You make a big difference!!! Tx!! What I can’t understand is that after all this time FF still doesn’t offer you a business invoice so we can get the VAT refunded. It’s about time they do. Most of us users are a business so it makes a lot of sense right.
Can you connect FF to a Supabase Query which combines data of 2 tables so you can show the combined data in a listview without having to write extra code? As Supabase is a relational database that would be something obvious that one would like to do no? So I would like to list data from 2 tables in 1 list. Is that already possible. I don't see my queries in the FF schemas.
After some decent research I figured it out. Seems I need to do an api call for that where I combine the data of two tables. I don't think I can create a schema for a query, right?! Then bind that resultset to a listview (a bit different/less easy than for a regular table but with the help of your previous tutorials I did manage) and voila! It works :) That really shows the advantage of using Supabase over Firebase :) Now all I have to figure out is how to do this with RLS enabled. I think I need to pass the user_id then to make it work. Your help and feedback on this channel really got me going!! Tx.
Supabase authentication around 40 minute mark needs updating - Supabase UI completely changed
Thank you for pointing that out. Hope it was not too much trouble working out the changes. I need to do a replacement video on this specific topic to bring it up to date.
Hello getting an error: getting Supabase schema API response could someone help?
Long video is great but i have hard to rewind in the exact moment i want
Hi. Thanks for the comment. Please check out my back catalogue because I have the same course broken down in to episodes.
Is a FlutterFlow + Firebase complete crash course coming soon?
Hello again. I am planning a course for early 2024 which covers Firebase but nothing released just yet. Thank you for subscribing and hope there is further content which you will find useful on my channel.
@@the_digitalpro Thanks a lot. I'm learning a lot from your content. I'm looking out for the next couse.
White creating the table when I click save after adding all colums I get the error like this: "Failed to create, in valid URL". Please help me solving this.
Hi which point in the video are you have the problem? Please let me know the timestamp.
On "Create Account" is shows on all "Create account" page fields "Chose from drop down options". Does not create account. Followed your video. Tried 2 times from scratch.
Hello. Which specific point in the video is not working for you. Do you remember the timestamp? I'll try to help.
56:56 on pressing the button under each field appear: "chose the value from the drop down". Did not set any drop-downs. Followed the video exactly as it is.
@Novogod I'm trying to follow your description and not entirely sure of the exact problem. So my suggestion would be initially is to make sure you are NOT using any form validation. You want to keep it really simple in trying to work out the problem. The key thing you need to do is focus on purely just getting thr accout create submitting first so simplify what you are doing in an attempt to narrow down the problem.
@@the_digitalpro OK
error occurred in action flow editor Supabase database insert action for GoalSubmitButton is missing required field "type". please provide solution
I am really confused to why you are getting this error. Order is not a field in the walkthrough. Have you walked through step by step or clicked on a link to a sample?
@@the_digitalproThank you, sir, for your help, but I fixed the error. In the walkthrough, by mistake, you didn't provide the type of submit button in the action flow editor. Once I added the type and set the value to 0, the error was fixed.
the no_tasks_complete_count adds up by two when user performs a fast double-tap on the complete icon, anyone have same issue on this?
I couldn't get the triggers working, also I couldn't mark the tasks as complete. All because in my table instead of "no_tasks_completed" I mistyped "no_taks_connected." (Lol I did that part in a noisy Starbucks). Long story short, because of the typo the SQL wouldn't work. Be careful in the setup.
Oh glad you got it sorted. Even in a Starbucks! Thanks for the advise to others 🙂
@@the_digitalpro Thank you as well. These courses are top notch. I’m excited to learn from you in the VIP section.
I have posted a comment but its not visible 😢
u need name on u part ... i can't watch everything but thx for u work I don't see it
Damn just when i thought there is no Superbase and Flutter flow video. Thanks again didn't watch it full yet, but i know it will be good
Hey no worries. Hope you enjoy watching it through and learning new skills.
flutter flow 4.0 course outline
Hi. I will be producing a brand new multipart FlutterFlow 4.0 course soon. Look out for it.
This course needs a few updates as Flutterflow has changed. Example around 15 minute mark - text widget alignment needs to be set to Top
The Base project is not correct
Hello. What is the problem? You are the first to report an issue and it has not changed. Thank you.
@@the_digitalpro Thank you for responding.
Sorry, my bad. The UI has been changed a bit, so i didn't see all the pages. Now I can. Love your tutorials btw
@@the_digitalpro Didn't expect to get a reply so fast. #respect
Phew I had a panic for a second. I did check the base project and all looked great. Thanks and no worries!
3:18:04 it did happen I promise you that 😂
Uncaught Error: PostgrestException(message: relation "goals" does not exist, code: 42P01, details: , hint: null).
imm getting this error at 4:01:52.
Could you explain what i'm doing wrong?
BEGIN
IF (TG_OP = 'INSERT') THEN
-- Increment the no_tasks field in the goals table
UPDATE goals
SET no_tasks = no_tasks + 1
WHERE id = NEW.goal_id;
RETURN NEW;
END IF;
RETURN NULL; -- Return NULL for unsupported operations
END;
Hello. Silly question first. Can you confirm that your table name is actually goals
@@the_digitalpro Found it finally, the bug was that the table name was uppercase. Supabase does not support uppercase table names in order to use in triggers or functions.