-
Moderating Post Data
I have a posts table for people to create posts. The table has a post title, description, and so forth. What are methods I can use to moderate this table, and ensure that there aren't any negative posts being uploaded?
-
How to use Magic Link for resetting password
I tried setting up and testing my endpoints for resetting a user's password through with Magic Link. I am running into this error though: The 'user' table the function was set at wasn't wasn't the correct table so I switched it to my 'Users' table, keeping everything the same except where the data is being queried: I have…
-
Help with pagination
I tried implementing pagination, but I keep getting this error. This is how I am setting it up for pagination: I believe the problem is with setting up the external part as such: But I am not sure where to put my object to make this work — if this is even the correct way to utilize pagination. Where am I going wrong?
-
Using search with Draftbit
I managed to set up the search feature in Xano, but I am stuck with implementing it into Draftbit. Here is what I have on Xano: search_query is inputted to give the search, but I am unsure what to do after this. In Draftbit, I cannot add the ability to input search_query. At least I do not see the ability for me to. This…
-
Generate Unique Identification Numbers
I need to create a field in my database that generates unique identification numbers for each row. The desired format is f-####-####-####, where the "f" remains constant. These numbers should be generated for both existing records in the database and any future records that will be added. Can anyone help? I can easily do…
-
How to show EST correctly?
I currently have it set up that a post can have the time it was created shown as such: But I am getting this output: The post was created at 6:58 EST, not 5:58 How can I fix this?
-
Testing in Production & Development
When an app I created is uploaded, how will I be able to continuously update and test my backend in development without affecting the app within production?
-
Searching for Xano experts from Ukraine!
I recently started a project on Xano and I'm looking for a mentor or consultant to help me get to grips with the tool faster and solve some hot issues. If you have experience with more than one project in Xano and you are from Ukraine, write to me on Telegram or if you have such acquaintances - share the contact. Thanks!…
-
Creating Rows If Not Created Already
I want to use POST to create a row using a users_id and a clubs_id. I want it to be that a user can't have multiple rows with the same club. How do I go about creating a function stack for such:
-
PATCH Conditional Filters
I want to utilize PATCH to update a user's information, but found that I cannot update information on my frontend without filling out all the criteria listed here: I want it such that a single field can be updated without the need to updated the other fields. For example, only updated a firstname and not lastname,…
-
Adding or Editing a Users Information
I am having my app formatted in which a user can pick up to 5 different pieces of information as shown: If a user does not select all the values then Xano only stores the ones that were populated. My problem is that if a user wants to add more values then they cannot. For example, if a user chose 3 interests but wanted to…
-
Utilizing PATCH on an image
How would I go about editing an image through PATCH? For example a user's profile picture.
-
Conditionals For Editing Data
Whether I use PUT, PATCH, or POST to edit data, I run into this issue. I followed the following video and used both methods shown: Yet I am presented with this error: This is what I personally did: Method 1.) Method 2.) Where am I going wrong?
-
Using Arrays Correctly
I want to know if I am utilizing arrays correctly with this query. I want get a user and an array of information connected to them through another table. I noticed that when I try to attach a list of items to the 'users' table then I am given a blank array. I decided to query the table I wanted information from then set it…
-
PUT Conditionals
When using PUT, is there a way to specify that if a value is not changed then the original value will be kept. At the moment, when a value is not changed, it is set to null.
-
Formatting timestamps
Where can I going wrong when trying to format 'created_at' into a more readable time? The 'created_at' is not being altered: Instead this appears at the bottom of my query: Where am I going wrong?
-
How to approach Stripe Connect custom payment flow implementation?
Hello! I need some help putting together an approach to accomplish end goal: to use Stripe Connect as a platform to allow my users to setup their own payment forms using Stripe Elements (). I've successfully setup Stripe Connect using API endpoints I created in Xano. When a user registers on my front-end (WeWeb), it…
-
Finding Specific ID's from a joined table
I created a join to GET club information for my specific use case like such: is there a way to specify that I only want post information from '_clubs' if the 'id' for '_clubs' is a specific one? For example I only want club id #1, thus giving me all the post data for that.
-
Posting Non-Existing Data
How can I set up this such that I only create a new row if it doesn't already exist:
-
I need help with making an API request in Xano
I'm trying to get the data from a file that is currently saved in my Xano database by making an API request. First, I make a query of the database with the files, next I get the file's url. I use the file's url in the API request using the GET method and settings the content-type's charset as "windows-1252" since the file…
-
Formatting Data Outputs
How would I format my output data such that it looks like this: [{label:'One', value:1}, {label:'Two', value:2}] the string would column's value in a table and the integer would be a row id.
-
Turning created_at Into Real Times
My goal is to create a posting mechanism where the post will show how long ago it was posted. For example, "2 hours ago" or "3 weeks" ago. How would I go about this?
-
Filtering Data by Time Created
I am trying to send data to my frontend based on the time that it was created. The use case for this is a user's post would be displayed based on how recent it was posted. Think of how any forum or social media account displays posts based on how recent it was created. I know there is a way to do this, but I am unsure how…
-
Joining Data Correctly?
I am trying to join data in Xano in order to get data from multiple tables. Currently this is what I am doing: When I test the endpoint, I am unable to get anything in my '_userclubrole' table. It looks like this: How can I fix this?
-
How to Properly Utilize PATCH
I was trying to configure PATCH to update information on a User database. I am currently using this with Draftbit. My issue is that I am unsure how to specify that a user can only update their information both in the backend and in the front end. How can i make this work?
-
Authentication and authtoken
Hello, I would like to add a login to my application so that I can display personalized information depending on who is logging in. Context: I'm trying to create an application with Bravo for the front end and my back end is made from Xano, and I'm using their free versions. I know that with their paid versions it's…
-
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)
-
How to modify api input params to dynamically add columns and values ??
I am using metadata API, I need help with how to add columns in table dynamically along with the data. I figured out the column adding, but stuck on how to add the value in the table for that newly added column. Ex. { "data": "test", "int" : 123 } this is first object which has int as a new variable and need to add that in…
-
Need advice on JSON field
Hello everyone! I am new to Xano and using code as well but I need to learn so here I am. I have a database that has a list of weeks in them and then a JSON field that will sort a list of "splits", Inside each split is a list of "exercises" and inside each exercise is a list of "sets" (along with other information too).…
-
How can I change the timestamp format in an addon by using filters in a 'Get Records' Function?
How can I change the timestamp format in an addon by using filters in a 'Get Records' Function? Below is a recording of my current setup that works in my 'Query All Records' function. However, in my 'Get Records' function, I'm encountering the following error: 'Please use a numerically indexed array.