-
Using codes to match users with team?
Sorry for multiple questions in one day - really trying to figure xano out and there is a lot to learn. I'm trying to automatically match athletes with their team. Ex: a coach creates a team (name, location, & team code), then when an athlete signs up they type the team code to match with their team. So far I've only been…
-
why is this error happening?
SQLSTATE[08006] [7] could not connect to server: Connection refused Is the server running on host "database" (10.0.9.244) and accepting TCP/IP connections on port 5432?
-
Forgot Password & Push Notifications
Hi there, 👋 I'm looking for a tool/API which I can connect with Xano backend and share data with my frontend which is Draftbit. I want to implement the functionality of "Forgot Password" and the ability to "send & schedule" push notifications. For forgot password I found out that we can use SendGrid as well but then I'll…
-
Password validation Xano/Adalo
Hi there, What is the best way of applying password validation to inputs to ensure only passwords that meet the minimum criteria on sign-up (e.g. 8 characters long, 1 numeric, 1 character) before they are sent to Xano? Note: I am using Adalo as my front-end and Xano as my back. Here is the problem shown on loom. Any help…
-
'Flattening' output when using addons
Hi! Using the addon function to change the output in a function I've put together, as per below - [image.png]In the output, the fields from the addons are nested (don't know if that's the right term)[image.png] Hoping to find an easy way of unnesting them, as the way I'm using them in the front-end (converting it to…
-
HI IS ANYONE THERE NOW HOW TO USE FTP? THANKS IN ADVANCE :)
-
Database storage pricing
What is the meaning of 'No Record Limit 10GB of Database Storage' in the pricing structure? To my understanding 'no record limit' and '10GB of database storage' at the same time seems contradictory. Thanks
-
Obfuscating the id
Hello Is there a way to set the id column to GUID or something similar to MongoDB's ObjectID, e.g. ObjectId("507f1f77bcf86cd799439011") Thanks
-
Most efficient way to get max value
Hi there, I have a post API to create an invoice I want to have XANO to determine the next invoice number to use. In the function stack I fetch all invoices and from there I use the filter 'max' and 'add 1' to get the next invoice number. But I believe this is not efficient anymore when I have thousands of invoices (or as…
-
POST / update end-point works in XANO but not in Postman
I have an end-point for updating a 'profile' record. It finds the record by profile_id (i.e. 'id' on the Profiles column). This end-point works in Xano - screenshots below. However, in Postman this end-point generates a new record, rather than updating the current record. I send 'profiles_id' in the body because in Xano I…
-
Error changing server locations
Has anyone encountered an error saying "This instance has encountered an error" after completing the server location switch? Currently experiencing that issue and am wondering how to fix this.
-
It is possible to import automatically
Hello! Is it possible to automate the import from airtable or do I have to use the API? Thanks
-
How to display specific number of items for Joining table (latest products of list of brands)
Hello! I want to display list of brands that have latest products in shop. I have endpoint where table Brand joins with Products and as a result I have [ brand1 {product [1, 2 3 ...]} brand2 {product [1, 2 3 ...]} ] with sorting brands by "last added product" and products inside should be also sorted by last added product…
-
Aggregated/grouped list: cannot add data to response
Hi Xano team! I have a question is there any way to add addon. I have list of orders and I want endpoint which returns this list grouped by status. It works well [Screenshot 2022-07-11 at 15.19.12.png]BUT I need to display additional data for each order.. And I dont see any option to control this by Customize section -…
-
"Run and Debug" with urlencoded content
Hi Xano community— I'm configuring a POST endpoint to catch a webhook whose content type is application/x-www-form-urlencoded. I'm having a tough time trying to debug some logic in the endpoint, as it looks like the run and debug feature only handles JSON. I've tried to convert my urlencoded content to JSON for debugging…
-
Check Password in auth/login issue
In using the default auth/login the an error on 'Step #3 Check Password' and it's returning a value of false. What is strange is that this was working only two hours ago. I've also noticed that any of my request over the last 90 minutes to this endpoint are not shown in the Request History. Aside from verifying I have…
-
GraphQL APIs
Does Xano support calling GraphQL functions? I'm trying to build a backend to connect to data from shopify (graphql APIs) and I want to make sure that Xano is a good fit
-
Add form record with text, date and image from Bubble to Xano.
Hello ! beginner on Xano, I encounter some difficulties and the resources are quite thin regarding the link with Bubble. There I have a very simple form in front of Bubble, no worries to configure my post with regard to the texts, dates etc... on the other hand no way to recover the images. I get there by doing an Upload,…
-
Proper Way to Setup Authentication to Reference Tables
I've enabled authentication for some tables in my application and verified it's working. In my design I have users who belong to companies, and through the extras I am passing the company_id to allow users who belong to the same company to view records together. One question I have, I have some tables that are simply…
-
Calculate percent of total by type
I have Contacts, who each have multiple Accounts, and those Accounts are categorized by type. I created an API call 'contact_with_accounts' that gets a single Contact record, includes that individual's Account details (via Addon), and returns aggregated amounts by type (again, via Addon) as well as an aggregated total for…
-
The best way to organise table with categories and nested subcategories (tree structure)
Helo Xano! I try to make a table with product categories which should be a tree f.e. categor • subcat list • subcat etc... and I will like lowest level of subsubsub...category to my products and in GET endpoint I want it to be array with nested arrays in objects so 1 endpoint will return all tree for filtering reason...…
-
Remove Getting Started Tips
Hello Xano Community, Quick question. How do I permanently remove the basics and getting started tips I receive either when logging into Xano, opening the database section, opening the API section, etc?
-
How to make table reference for external id in a object list
Hi guys. So this video exactly explains what I want: https://www.youtube.com/watch?v=hulHk9v3Phk&t=292s However. In my specific case. I want to make the table reference on an object list. (see screenshot) How can edit a list object, and match it with a other table reference ID? I think i'm pretty far, but i'm stuck at how…
-
Xano Signup in Bubble question
Thanks to Michael's answer to my last post I know that I can now delete the following Bubble workflow steps: 2) Sign up the user, and 3) Log the user in. But in my Step 4: Make Changes to the Current User, should I make the changes in my Xano Signup API call (POST), or in a separate POST to User table call? Also wondering…
-
Foreach loop don't work with object since last Xano update ?
Since last Xano update, i have new error in my function. I use foreach loop with an simple object like this : { key:value, key:value, key:value, ... } All worked fine last days. [screenshot-.xano.io-2022.07.09-09_03_29.jpg]
-
After Xano Login in Bubble workflow, need for other Login action?
Can I delete my previous Bubble "Log the user in" workflow action?[Screen Shot 2022-07-11 at 4.32.38 PM.png]thanks
-
Do branches include env variables?
I've released my first alpha version and would like to keep my dev site separate. As such I've got 2 different URLs for redirecting magic link. Would a branch allow me to set new env vars? I know I could just clone the workspace. Or it looks like I can just rebuild the magic link redirect entry in the function to pull from…
-
Remove Object From Array Not Working
OK this seems simple, but I am running into an odd issue. I have a really basic function that should just remove whatever object it is passed from the array. Here is the function where I lookup the record and the object I want to remove. [image.png][image.png][image.png] Now when I go and run this to try and remove…
-
Webflow Twitter OAuth 2.0
Hey there! I was following the YouTube tutorial on how to add google oauth to Webflow. Is there any way to only use Twitter? If so, could someone let me know or point me in the right direction? I've searched and searched. I love XANO btw. Learning so much from YT
-
How to trigger loading the next page of data.
How do we nocode developers create controls to display data when there are multiple pages of data to display. Right arrow >, left arrow <, 'next' on the web page. I can see using the CSS cursor:pointer to trigger an event or some other jquery or javascript solution. But how do those triggers interact with Xano API? I'm…