-
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…
-
How to map addon to value of array?
I Need to map addon to participant ID My addon works for single item mapping. For array I try this: But as a result, I don't have either an addon nor an ID in the array. What is the correct way to map addon in this case?
-
Assigning role to user on signup
Hi - I have 3 types of user roles: coach, parent, athlete. & I'm trying to get it so that the role is set when each user signs up. The user selects who they are on first screen (coach, parent or athlete) then they are taken to that role's sign-in/sign up screen. Any suggestions?
-
How to add value to enum array for record?
User can have multiple roles = user, editor, reviewer etc so role is array [] I want to update user record and add one more role. I get user with existing roles and try to add new one to that array. I get error. How to fix it?
-
Password & Password Confirmation
Hello I've followed the tutorial to reset password However when comparing password and password_confirmation it says it does not match… Here is the inputs and precondition
-
Bubble Xano Google auth error coming 403 : access denied
I am trying to authenticate users with Google continue, my Google init is working, but Google continue is showing error, 403 denied. If I am trying Google sign in through bubble than it's working well but when I am trying through Xano Google continue api call is showing acess denied. I also tried decoding the code I got to…
-
How to stop CSV Export
Hello. I have a processing CSV export that is too big so it's not working but it's trying in loop and i want to stop that. How can i do ? Thanks
-
✅ [Resolved] 500 Error: Unable to locate input?
I just received the 500 error shown below. It happens when a user tries to post a workout with image, caption, etc. The endpoint was working two hours ago and is now isn't. I haven't changed anything in the frontend Draftbit app or in Xano, so I'm not sure what it could be or where to start debugging.[CleanShot 2022-06-14…
-
Get highest bid into frontend
Hey all, I am trying to get only the highest bid to show on the auction item. I can't seem to wrap my head around how to do this. Any help is apprecaited. My auction site is like any other site. Whoever is the highest bidder shows first.
-
how to send multiple emails
hey everyone ! is there a way to send the same email to a list of people with xano and any integrated plugin ? If so please let me know how to do it ! I've been struggling to find a solution :(
-
Retrieve current date using users time zone from front end
What is the easiest way to retrieve the CURRENT DATE from Xano using a User's timezone?
-
How to create a new line in a text
I am trying to send an email via sendgrid, this email will have a list of users and I want to have a new line between each user, the data will be dynamic depending on the request Does anyone know how to do that ?
-
Basic query filter
Hey there, for most of you, this is pretty obvious question, but as a beginner I've burned too much time on researching this, so here I am. I have 2 tables. Rating request table and Ratings table. On my frontend I want to display only requests type1 that have less than 30 ratings and only rating requests type 2 that have…
-
ElevenLabs External API Call
Hi, I'm calling ElevenLabs from my Xano API Endpoint - but I'm only getting decoded responses - and not mp3 files or links, how can I get this converted into a usable file for my API? Thanks ;-)
-
first_notempty for boolean?
Hello, so I want to create a simple way for updating my entries and ignoring the empty variables, the easiest way I found is by using first_notempty The problem comes when trying to do it for the boolean fields, so for them I tried using first_notnull instead which seemed a very logical option, BUT in this case I have a…
-
Sentence case filter in Xano
Quick question: In my database, some users post sentences starting with lowercase (eg. "just a random title" ) and I want apply a text filter in order to start the sentence with a capital letter (eg. "Just a random title"). Is there any chance to achieve "Sentence case" with text filters? Thanks a lot!
-
Table: reference no longer exists
Hello, In my user information table, the ID column is filled in with "Reference no longer exists". How may I fix that? Thank you
-
Route data to the Addon's Input - string instead of id
Hello 👋 Is there a way to pass a string value as input to an addon? A static string works, but I want to pass a dynamic text value, the add on route dropdown defaults to only integer / id type. I realise an ID would be better / quicker, but what I'm trying will do the job easily. Thanks for any insight 😀
-
Multiply two columns in a table
Hello, How may I multiply (for each row) two columns within the same table in a database, and create a new column with the result? Thank you
-
How To Use Only "Add Photo Record" Portion of "Photo Sharing Social Media Platform" API
Good afternoon! I am trying to create an app and one of its functions is that a user can add a photo from their camera or gallery. I've tried editing the above mentioned API since I don't need the comments, or captions functions, but when I tried to run and debug, an auth token didn't appear. Am I required to use the sign…
-
JWT Token Generation
Ive tried the jwe/jws encoding options xano has but none seem to create a token that works for the external api authentication im trying to connect. The only thing that has worked is a NodeJS libary 'jwt-simple'. function(properties, context) {const jwt = require('jwt-simple'); const moment = require('moment');const…
-
For each loop, to create items in a separate database
Hi! I'm importing information from a JSON object, and I want to be able to take an array of tags, and add them to a separate database. For example, I'm trying to import each individual item from the "types" array into a separate database called tags. I'd like to have them as individual tags that I can later reference and…
-
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 do i recreate this code in xano ?
Hi im trying to recreate this function on xano but im lost, this is the code this is the result i'm expecting [ { date: "01-01-2021, name: { "liam", "liam1" } }, { date: "01-02-2021, name: { "max", "maxwell" } }, ] How do i recreate this with function stack ?
-
Creating a host vs regular user account
Hi everyone, I'm creating an app that allows users to sign up with a personal or business account, which gives them access to different features on the app. I set the user flow with a "Personal/Business Account" page first, which afterward directs them to the sign-up page (which is the same page for both regular users and…
-
Value is not properly formed.
Hello, I am having trouble testing one of my endpoints. The debugger is not displaying anything and I always get an error. I have provided images of the error and function stack. Do you know if there is a solution for this error? { "author": 1, "text": "This is a test", "background_file": null, "image_files": [ null, null,…
-
How do I precondition on an array stored in extras?
Hi, I have my user tables set up with relationships as follows: users - 1…* - user_roles - 1…1 - roles - 1…* - role_functions - 1…1 - user_functions In other words, user has a set of roles. Each role has a set of related user_functions. I believe I have auth.extras set up to include a list of allowed user functions. It…
-
How to change the reference table in function stack.
Hi, Sorry, I am a newbie in this. How do I change/edit the Function stack reference table once it had been created/added?
-
Getting this error; Please use a numerically indexed array
I've created a 'for each' loop to change the format of my timestamp. However, when I run it, I receive the error message 'Please use a numerically indexed array.' Does anyone know what I'm doing wrong? Here you can see what is happening: