This video will start with about 5-7 minutes of UI cleanup from the previous video. The remainder of the video will be setting up Login from AppGyver through Xano. I have left in some of the debugging of my own mistakes. I am hoping that helps everyone understand how to work through issues that come up as you no-code with Xano and AppGyver 
Question for you @Steve_Stava: After learning about Xano here on the forums from you, I submitted a request to get into the Xano beta. Do you have any idea what their criteria are for evaluating potential users?
Our project is very complex, so Iām not 100% sure that it would work. But Iām eager to try!
Also, Iām not seeing anything about pricing. Do you have any info on this?
Thanks for sharing your expertise with us!
Hi Erin, Good to hear from you and thanks!
I donāt have any pricing information.
When I requested early access it was mainly so they could give an overview of how to think about Xano and generally how to use it.
I would be interested in your project if you are able to share! I am happy to give my 2 cents worth if that helps.
@Steve_Stava, I just got off my onboarding call with Xano. Weāll see how it goes!
Iāve built an app that automatically plans hangouts by comparing friendsā calendars and interests: https://www.gomigo.app
Iām in the middle of implementing a new feature set, but I will totally hit you up to user test once itās ready for a fresh pair of eyeballs! Thanks for the offer
Excellent! Good luck. I am definitely willing to help however I can
Xano gave me a demo the other day, it was great and the perfect complement to Steveās tutorials.
RE pricing, they said the trial version would be free, and the next tier plan would cost around 30 usd / month. This is purely indicative.
Iād go with Xano for my marketplace project if I was not feeling overwhelmed by the āsign-upā and āloginā setup as showcased by Steve. Memberstack would make things easier but it is 30 usd a month, just for the needed login/signup features.
Is anyone familiar with Firebase or the combo Google Sheets / NoCodeAPI tool? I am really looking for the simplest setup.
Thanks all.
@Fred_Kuzyk Let me know if I can help with Xano. I am happy to work through anything that doesnāt make sense, yet.
Thanks @Steve_Stava! I see you created a few accounts Heads up that itās all completely non-functional at the momentāhad to make some changes to our server that wonāt be reflected in the app until the next update.
I got my Xano onboarding meeting yesterday! Not sure that weāll use it because we already have so much built out, but geez I wish I had had it four months agoā¦
For anyone else checking out the thread, @Fred_Kuzyk was spot-on with the $30/mo. The highest cost tier was $100/mo (both annualāslightly higher if youāre paying monthly).
@Fred_Kuzyk, I know @William_Glass is using Firebase and has ambitions around sign-in feature sets.
Steve,
Very kind of you.
I am following the Core Lessons by AppGyver as we speak. Iām just now starting to harness the concept of page variables and page parameters.
But I have a few best practice questions abt database structure if I may:
My Fiverr-like platform will welcome users with a need (user profile details such as name, age, gender and ability to write down and submit their needs to the platform with keywords) and service providers (profile with more information such as description of service provided, tags/keywords, reviews).
By the way, i saw your excellent article Stop Doing Time & Materials Consulting and I so totally agree.
Thanks Steve for all your contributions.
Erin,
Why do you wish you had Xano earlier? Since Iām shopping around and feel attracted by their service, I am interested to know what you found compelling in their offering compared to what you have now?
I find their pricing on the expensive side of backend offerings. Firebase seems to be the reference yet it is more affordable yet it is highly robust and trusted. Hoping @William_Glass can jump into this conversation.
Thanks.
I would just have one user table. There are a few reasons why, but to keep it short, you could have a user with āneedsā and a user who serves as a āsupplierā. You wouldnāt want your users to have to understand why they had to create 2 separate accounts.
Yes, I would have a separate table for the tags/keywords for the users. I am assuming a user will have zero to many tags that they can create. Would I be correct in assuming that each submission by a user could have different tags/keywords? If so, you would want to have a submission associated with each tag/keyword and that submission associated to a user.
Yes, I agree you would want a separate submissions table and you would want an association between the submission table and the messaging happening.
Table thoughts: User(id, name,ā¦); Submission(id, name, description, user_id,ā¦); Tag(id, name, submission_id,ā¦); Conversation(id, conversation_id, user_id,ā¦); Message(id, text, conversation_id,ā¦); Message_Participant(id, message_id, user_id, sender[boolean],ā¦)
I am a fan of building out a few tables with the first few columns I know I will need and then building a couple of screens that use those apis (nothing pretty or even functional!) Just enough to give me an idea of what I might be missing.
I will guarantee that you will have some discovery moments and need to tear-down or refactor what you started with. The nice thing is that is a lot less emotionally damaging with no-code. With code, you typically have more of a time investment and it can take a bit to convince yourself to refactor/change large portions of what you just built.
I have some table structure thoughts for managing messaging when you get to that point. Just let me know and I will share. I built an example app (a few times) until I got the table structure right
Thanks for reading the article! I appreciate you letting me know you like it. It is the only way to go with consultingā¦it is th only way to manage a project with a client. Oddly enough, no-code makes that approach a little bit more straight forward
@Fred_Kuzyk Iām using Firebase since it has a lot of the features I need in one place plus there were multiple tutorials in the forums on how to setup Firebase Authentication. The key is figuring out what are the most important elements you need then pick a backend that has those.
Unfortunately, you canāt tap into all of the robust features that Firebase offers at the moment as there is no way to embed the SDK into AppGyver. That SDK is crucial in connecting to all of Firebases services. I believe @Pekka_Aaltonen and the AG services team have built using Firebase SDK in the past but those logic nodes are not publically available and have to be reworked.
Once 3rd party plug-ins are enabled on the runtime upgrade that will open up Firebase SDK to be plugged in directly and add many other services at that point the AG platform will be easily 10X more valuable (maybe more) in my mind. It will truly separate AG from the other No Code platforms out there.
Fred - I wouldnāt kill yourself on making the absolute perfect decision on your back end. Your app will change and needs will change as you get feedback and time in the market. So use your best judgement and just start building.
@William_Glass, great input!
@Fred_Kuzyk, my app addresses a complex use case, and Iāve put more than $20K of my own money into having a developer build and rebuild the back-end as I better understand what my product needs to be. (I have to second @William_Glass hereāI did hundreds of customer interviews (many with mockups/prototypes) before jumping into the build, and it wasnāt until customers had a functional thing in their hands that they thought to share some fundamental facts about how they wanted to use it. Maybe I was doing something wrong, but I think most people just arenāt capable of working with hypotheticals.) If I had had Xano, it would have been just $100/mo, so somewhere between $500 and $900. I havenāt actually delved in to see if it lives up to its promises, but it looks like itās capable of doing almost everything weāve built out ourselves.
Summary: I would be $19,000 richer if I had had Xano when I started my project.
Thanks for this also. Xano is insane and I love it with AppGyver. Iām hoping your next tutorial parts show how to handle the expiry of the auth token, then Iām sorted!
Second @Erin_Wagner if Xano had tutorials earlier when I was starting out probably wouldāve used them especially if @Steve_Stava keeps posting them. Whatever backend is the easiest and the most effective way to solve your usersā problems.
Now the sunk cost fallacy has taken over on my existing projects and the switching cost is too high. Perhaps in future projects.
Good timing with your commentā¦I was able to get a few more videos out today 
Thank you @Steve_Stava,
Your videos are brilliant. Very easy to follow and you explain it very well. 
I have just swapped backend to Xano so all very new.
I have one question, not related to this tutorial but to your search field tutorial. I have now got my search field up and running, but I cant get pictures to come through. It worked with my old database. Text is coming through just fine from 2 tables but missing the image. I have current.Picture.path in the formula but not sure if I need .url or something else. Any idea?
Thanks Dan! I am glad that the videos are helping
As far as your image display problem, it could be a few things depending on the details:
Test the Xano API from the Xano āRun and Debugā option and confirm the data being returned has a valid picture/image path.
I would confirm the API is returning all of the data you expect. Especially a full and valid image path. I typically confirm my APIs by running the AppGyver data resource Test for the API. The results should show a full path and you should be able to copy and paste the picture path into a browser and see it in the browser window. If not, the problem is with the image path being invalid.
If you are image was uploaded to Xano and you are retrieving the image path via a Xano API then make sure that you have added the Xano base URL to the relative image path.
There is a URL(current.Picture.path) formula in AppGyver that you can use when assigning the image path to a image component.
Feel free to share some of the details of the API, image location and such and I will help you further if the above recommendations donāt get you there.
Thank you @Steve_Stava for your reply and for your help.
This is the image path I am getting, not sure if this is correct.
/blob/a0ZRLg.i02GVjUSqBA/Cappadocian+Maple_leaf.jpg
Do I need to set up a image input field in Xano, like you do with a search query as I havenāt donāt that?
I have the URL current.Picture.path formula set but not sure if I need something more added to this formula.
Dan,
You only have the relative image path. That is not the complete path. If you were to put that in your browser web address you would not see the image
If you go to my video peart 12-B at 10 minutes and 45 seconds that section will walk you through how to set up an environment variable in Xano with the base URL to get concatenated to the front of that relative image path.
After you have listened to that part of the video Iām hoping it becomes more apparent what needs to be done. If not, definitely let me know as a reply to this comment and I will get you through it