-
Ask Anything! No question is too basic.
We want you to succeed using Xano or any other No Code tool to launch your big idea to the world. Visit the "🤷 Help! I'm a Noob" to learn the basics and grow with the community.
-
Not able to use /n (new line) character. Please HELP!
I am trying to create a dynamic public key which will be used to verify signature.I have written lambda function for that. My code: const EncodedKey = "-----BEGIN PUBLIC KEY-----" + "\r\n" +$var.publicKey + "\r\n" +"-----END PUBLIC KEY-----"; The error: error:0909006C:PEM routines:get_name:no start line Please kindly help…
-
Objects vs Table Reference, which one should I use and which direction?
Hiya! Noob here. I watched some of your YT videos, which were helpful, I had my structure all setup and I understood it, It had Table References, life was great. 😎 Then Objects were thrown in and it all got confusing again 😩. In the application I have in my head I had a products table and a products_type table. I had a…
-
How to filter data
Hi all, How can I filter the data that is called from a Xano table to my frontend? Here are three examples/scenarios: Only show upcoming events (not past events) in a feed; Fetch certain data by category (e.g. only vegetaian food, only gluten free etc) to be displayed in a feed; If a user only wants their post to be…
-
How to set a filter to null if key doesn't exist while adding a database record?
Hi, I'm getting JSON data from an external source. However, the array of profile records that I'm getting isn't consistent. For example, some objects have the email key/value, some don't; some objects have the phone key/value, some don't. When I try mapping this to my Add Records step, I keep getting an error whenever the…
-
Reference by question
Hi all! This should be a simple one, but I'm new to Xano. How can I link an App user to what they do in the App? For example, I have a 'Sign up' table with name, email and password fields. Users are then navigated to a profile screen (linked to a 'User' table) where they add a profile pic, gender, age etc. I have a…
-
Query string for upcoming events
Hi, How can I write a query string structure for my endpoint path to get only upcoming events (i.e. not past events)? My database table in Xano has an 'event_date' column. My frontend is Draftbit (in case that makes a difference). Thanks, Gavin
-
Need help implementing a user tagging system
I am trying to implement a user tag system similar to Spotify any ideas on how to go about this on flutterflow? The backend will also need the tag data in order to process a recommendation algorithm. (firebase as the backend)
-
502 Bad Gateway & slow API response
I noticed couple days ago that I started getting 502 errors on GET request, especially on every page refresh. I also noticed api resquest started to be slow, from light api endpoint to more complexe ones. I did not have any of these issues, let say a month ago. Went on the Troubleshooting Performance documentation page and…
-
Problem with Parsing?
Here is what the JSON looks like: This first screenshot parses correctly This second screenshot gives me this error: Exception: Unable to locate var: all_data.totals.statistics.pitching Why is this behaving as such? It makes no logical sense to me.
-
How do I invalidate response cache?
I like that I can cache responses, but sometimes I need to delete/add/edit a record which invalidates the cache, but the cache does not refresh until TTL runs out. How do I invalidate a response cache?
-
Weird behavior on timestamp
Let me explain. I'm on GMT +1 like for all my current customers. I need somewhere to get daily records, so I go by comparing epoch days Where date is sent from the frontend as a return Math.floor(timestamp / 1000 / 60 / 60 / 24). However, for records in this 1 hour timezone offset, 00:35:48 GMT+1 for example, the frontend…
-
How To Add Records After Querying
Hi, I'm working on an app that needs to show a list of objects (5 meditations) for each week. I query the 5 based on their timestamp which works perfectly. This 5 will change every week and I want to update a table that holds the current list. (Im doing this because simply querying them returns nothing on the weekends) I…
-
How to impement a drag and drop? Any hints or ideas?
Hi, I'm currently trying to implement a drag and drop feature where my intention is to give users the ability to define a new order (other than default) to a set of elements… For more context: 1. Items are coming from another table, and can come in: Multiple items in a bulk or as single items. Items can be added and…
-
correct way to query trough distant relations?
please help. here is example of entity links apartments -m:1- floors -m:1- sections -m:1- buildings -m:m- projects. how do i make query that will return every apartment that belongs to a project? is mine structure even correct? do i need more links? please point me
-
Are the Increase Limits options available on the Agency (Lite) plan?
Hi, I'm considering signing up for the Agency Lite plan. Curious to know if I can avail the Increase Limits options on the Agency Lite plan or are these only available on the Launch & Scale plans Thank you.
-
Flutterflow + Xano + Firebase security
Hi everyone! Recently started a FlutterFlow project, I'm using Xano as the backend, and Firebase for auth and notifications. I'm storing the phone number used during login as an app state variable, which I then use as the identifier to get that user's data from Xano. This method works well, but I'm not sure about the…
-
Function/API/Task name as variable?
Trying to maximize the use of the new Try/Catch function. I am alerting myself in Catch cases and wondering if I can grab the function or API name from the environment automatically. Is there a way to get that somehow? And if it was a Xano url to the function/endpoint.. would be even greater. But that's probably a feature…
-
Auth token for later usage when a user is not logged in.
Hello fellow Xano users! I've been loving Xano's extensive knowledge base and helpful video tutorials, but sometimes I struggle to find precisely what I need for my projects. I'm hoping someone can guide me in the right direction or recommend a tutorial that aligns with my current goal. Here's what I'm working on: I'm…
-
Dynamic variable name in custom function
Hi, I could not figure out how to do this or if it is even possible. What I need: Ability to name a variable based on the input in a custom function, so I can reuse a function with multiple calls and return a new list of items. The function goes through a loop and in the loop I want to be able to name the variable that is…
-
Is it a bad practice to have a large list of json objects in a database table column?
Hi, My app does some inventory updates where some products are retrieved as json objects from an external api. I have a database table called "inventory update" which contains a column called "products_json" which is the list of all the products involved in that specific "inventory update" (so it is a list of json…
-
Can someone explain me how to use this Get record "lock" feature?
Hi, Can someone please explain how are we supposed to use this "lock" feature? If a function in an endpoint was going to edit a record but it was locked, how can I set a retry system that keeps trying until it finds the record unlocked, then it locks it again while it edits the record and unlocks it when finishes editing…
-
DB locking for parallel processing?
I have a queue db and I have a process that needs to pick a limited number of records from it and process them. Sometimes, when the queue is large I run multiple processes in parallel. Doing it by either hitting an internal API endpoint with a timeout for request OR with a lambda OR with just multiple tasks - tried all of…
-
How to find all rows that is not it array
Greetings. I run a query on a table that filters and displays an array of id. After doing this, I feed the matched_users variable into the not in filter : and get the following error: ParseError: "Users.id" not in [{"receiver_id":6}], message=Type mismatch. Thank you for your help!
-
System Permission and Permission Sets
Hi everyone, I am developing a SaaS app using Xano and WeWeb. I want to know what the best practice is for establishing a module-based permission system. From a business perspective, customers will be able to choose different package options (basic, full, premium), and each of these packages will have different modules and…
-
Aggregating by month - to_timestamp not available as filter
Hi, I am trying to return aggregated result by month from a date field (not timestamp). My understanding is that in order to get the formatting I need to convert the date to a timestamp. However in the aggregation the "to_timestamp" is not available. How do I accomplish this? Thanks!
-
How to access/reference JSON payload accepted at endpoint later in the function stack?
Hello, I've created an endpoint to accept a POST from TypeForm, which has a JSON payload. How do I reference the payload received in the request to the endpoint? I can see the payload when I click "Request History" in the menu for the endpoint, and can traverse the JSON there. But, when I try to reference it in the…
-
Array data
Hi, I'd like to get the values (2,6,7,3, etc) out from the data[] section of a variable that looks like this, and can't figure out a way. Please help. Thank you. [{index: 0,data: [[2,6,7,3,1,1,1,1,1,1,... +93 more]]}]
-
Like button
Good day! "I am a noob" and would like to know the process on the Xano side to create a variable for my Like button. So I can connected to Bravo and bind it to my app. If there is any advice or tutorials I would greatly appreciate it
-
Data format..
Hi team, I have a quick question for the group. When I submit (Post) data to one of my tables using Android it shows the correct data format but when I submit the same data using iPhone the format in completely off. Example - when submit 10,6,2,12,78 it shows up in the table as 10%2C6%2C2%2C12%2C78. This is not additional…
-
Add-on
Table A is an index of items, with a unique integer as an ID…let's call it "item code." This is not the Xano ID field but a separate integer in that table. Table B is a schedule of when these items were used. Each record has the item code, date, and location. The user specifies a location on the front end. I am trying to…