I’m building a kid-friendly app in Glide with a Google Sheets backend.
Task (just this piece): Wire the Log In button on my Login screen so that:
If Login→CodeInput is empty → show notification “Pop your code in first.”
Else if Login→MatchCode is empty → show “Oops! That code doesn’t work.”
Else if Login→CodeStatus = “Used” → show “That code’s already been used.”
Else (valid + unused) → set the matched AccessCodes→Status to Used, set Login→IsUnlocked to true, then navigate to the Stats tab.
Also set Stats tab Visibility = show only when Login→IsUnlocked is true.
What’s already set up:
Google Sheet tabs: Players, Clubs, Weeks, Stats, AccessCodes.
Glide table: Login with user-specific CodeInput (Text) and IsUnlocked (Boolean).
Relation + lookup available: Login.CodeInput → AccessCodes.AccessCode (MatchCode) and CodeStatus (lookup of Status).
Test code in AccessCodes: TESTER1 with Status = Unused.
Deliverable / acceptance:
Pressing Log In with TESTER1 flips that row to Used, unlocks the app (IsUnlocked=true), and navigates to Stats.
Empty/invalid/used codes show the correct notifications.
A quick Loom (30–60s) showing the test would be ideal.
Access: I’ll add you as an editor on a duplicate Glide app connected to a copy of the sheet with dummy data. No ownership or billing access needed.
Costs & timing: Give me your best cost. If it goes well, there’s follow-up work ongoing. (stats list layout, images, feedback form). Plus next iteration of the app. Time for delivery is important.
Video Editor Category: Adobe Premiere Pro, After Effects, Audio Editing, CapCut, DaVinci Resolve, Motion Graphics, Video Editing, Video Post Editing, Video Production, Video Services Budget: ₹1500 - ₹12500 INR
News Website SEO Upgrade Category: Content Marketing, Content Strategy, Digital Marketing, Internet Marketing, Keyword Research, Link Building, Search Engine Marketing (SEM), SEMrush, SEO, Website Optimization Budget: ₹600 - ₹1500 INR
12-Mar-2026 17:01 GMT
Senior Software Engineer for AI Legal Tech Startup -- 2 Category: AI Development, AI Model Development, AI Model Integration, Large Language Models (LLMs), Legal, Legal Research, Logo Design, Patents, Python, Software Development Budget: min $50 USD
12-Mar-2026 17:00 GMT
Senior Software Engineer for AI Legal Tech Startup Category: AI Development, AI Model Development, AI Model Integration, Large Language Models (LLMs), Legal, Legal Research, Logo Design, Patents, Python, Software Development Budget: $50 - $51 USD
12-Mar-2026 17:00 GMT
News Website SEO Optimization Category: Content Marketing, Content Strategy, Digital Marketing, Internet Marketing, Link Building, Search Engine Marketing (SEM), SEO, SEO Auditing, Website Optimization, WordPress Budget: ₹1500 - ₹12500 INR
12-Mar-2026 16:59 GMT
Humorous Hygiene Accountability Video Category: Adobe Premiere Pro, After Effects, Final Cut Pro, Sound Effects, Video Editing, Video Post Editing, Video Production, Video Services Budget: $10 - $30 USD
12-Mar-2026 16:57 GMT
Modern Logo for Self-Love Brand -- 2 Category: Adobe Illustrator, Photoshop, Branding, Graphic Design, Illustration, Logo Design, Vector Design Budget: $25 - $50 USD
Tax Expert Reviewer - CPA Ad Hoc Category: Accounting, Bank Reconciliation, Intuit QuickBooks, Payroll, Tax Accounting, Tax Compliance, Tax Law, Tax Preparation, Tax Technology, US Taxation Budget: $5 - $25 USD
12-Mar-2026 16:55 GMT
Strategi Peluncuran Produk Digital Category: Business Development, Data Entry, Digital Marketing, ECommerce, HTML, Market Research, Product Descriptions, Product Management Budget: $15 - $25 USD
12-Mar-2026 16:52 GMT
Edición de videos sociales -- 2 Category: Adobe Premiere Pro, After Effects, Animation, DaVinci Resolve, Final Cut Pro, Video Editing, Video Production, Video Services Budget: $10 - $30 USD
12-Mar-2026 16:50 GMT
Dynamic AI Video Creation for Brand Growth Category: After Effects, AI Animation, AI Content Creation, Animation, Motion Graphics, Social Media Marketing, Video Editing Budget: ₹600 - ₹1500 INR
