-
Bi-directional transcations
I want to implement donation system in my app using in-app currency which can be bought and send as a gift to another user who can exchange it for real money which can be withdraw. Is something like that possible with current stripe integration?
-
Can't parse array from JSON input to table
I've made a Webflow form that successfully submits via a webhook to Xano. The basics are working, I'm getting the JSON input and mapping the data to the correct table. One of the form-fields is a multi-select, and I can't figure out how to ingest this data properly. This is what the JSON looks like:[json.png]But trying…
-
Importing CSV
Sorry if this is basic, but please bear with me. I am trying to automate importing a CSV into the database. If I manually import CSV, it gives me an error saying it is invalid. I discovered that it was because the CSV contains characters such as "(" or "&" and it was giving me errors. Once I manually replace these…
-
A simple way to check if an Array is empty?
I can't for the life of me figure out a simple way to check if an array is empty after getting records which is saved into an array. Do I really have to separately get array length and separately check if it is larger than or equal to zero?! Can't I just do a conditional Where Array ≠ Empty? (null doesn't work) or a…
-
The best way to handle errors?
I'm coming from Integromat, and am enjoying building my 'automations' directly into endpoints and functions. My plan is to move the bulk of these to Xano, as well as moving my data from Knack & Tadabase. I am busy pulling in data from VEND and am running into issues with a background task failing, due to VEND having not…
-
Advice around date
**Clicked post too early! Title not editable and should read 'Advice around complex calculations involving date'** Hi all! Just getting started with building out a B2B SaaS concept I’ve been working on and - provisionally - landed on XANO + WeWeb as the route I’m looking to go down. Product is essentially designed to…
-
Geo Eval - Filtering
Thanks to the great documentation and tutorials I've been able to follow along and: • create an API that queries all records • use geo distance to calculate distance between two points - returned as integer • use geo within to calculate if the points are within a certain distance (radius) - returned as boolean • return the…
-
google OAuth "continue" api error 403
hello, I'm trying to auth with google login in weweb, the init api is working and also the continue but after 2/3 test the continue api stop working and give me this error Error: Request failed with status code 403 at e.exports (https://editor-cdn.weweb.io/public/js/chunk-vendors.f83c0b3b.js:64:1241) at e.exports…
-
Most Efficient way to add a table referenced record?
Hello all, I'm trying to find the most efficient way to setup my database. I have two tables, one called Contacts and the other called Invoices Contacts Fields Contact ID: Name: Invoices Fields Status Amount Contact ID (table reference) I'm getting the data for these two tables from an external API. My first GET call is to…
-
Best Practices Image Upload Xano + Webflow
Looking for suggestions on how best to upload an image through Webflow. I have a requirement for an ID (KYC/AML). The best form tool I've found, is lacking image upload. File types are .jpg, .png, and .pdf. Thanks in advance!
-
Current Date in API Functions
Hi, Is there a way to get the Server Date for comparison in API Functions? I don't see it in the ENV. TIA Kumar
-
passing data from another page
I'm creating an app where I can have events in which I can post a photo. My issue is that I'm getting form is failing and I'm not sure why. The post is simple: 1. image 2. description 3. challenge_id (which should be passed from the event page - I'm not sure how to handle this) [image.png]On front-end side I choose as a…
-
Separate Tables?
Hello, I'm a complete noob to Xano so please be gentle, 😉. i'm developing an app with a list of college courses. The screenshot below shows a database that i've imported from an existing spreadsheet. I want my app to be able to search by the 3rd column, the category column, which is a limited list, to give as a result the…
-
Add to existing value without getting a record?
Hey! Was wondering if I can use "Edit record" function to do some maths on an existing value, without pulling out a record prior to this. E.g. there is a record with a value that counts a number of sent emails. Every time I send another email, I want to increment that value. Doable with just "Edit" or I have to pull the…
-
Gathering an average score
Hello! I plan to have a 5 star rating system in my frontend to rate baseball players. How would I go about gathering individual users scores and averaging them into an overall rating for the player (2/5, 4/5, 5/5, etc.=???)?
-
Tasks overlap?
I am planning to use tasks to process email sending for entries from a "queue" table. This table may become large at times and I am wondering if there are any limitations on processing time. Let's say there are 10 000 entries added every hour and each entry takes a second to process. What is going to happen if a task is…
-
Date type - separate date field as day and month in output [solved]
Hi I want to create a calendar which separately show which month and day of the month it is based on date type from Xano. I see that I can achieve that via timestamp and evals, but I can't see a solution for date type
-
Favorite button functionality in Xano
There is a third party add on Jetboost that works with Webflow and Memberstack that allows a user to mark an item as "favorite" and also display all the items that have been marked as "favorite." It only works with the Webflow CMS. I'd like to do the same with Xano still working with the Webflow front end. Prakash explored…
-
Secure an API endpoint but not JWT
I've read and reread the documentation and reviewed the copious tutorial videos but I'm still at a loss to one question: Hypothetically, just suppose I have users and those users are interacting with my application to build survey forms for example. The user would login and would authenticate and access via JWT to build a…
-
Function Stack
Does anyone here know a function stack videos tutorials? I think this part would be Xano's heart Edit: I found a lot of videos on Xano's youtube channel
-
Paginate arrays within variables?
I can't use the "pagination" feature in the "output" tab because I'm pulling from multiple tables and then eventually merging. The resulting variable (object array) could have 0-n results, but I'd like to limit it to five or six. Is there a filter I can use to limit the results? I was looking at "range" but that seems to…
-
External links (example YT Video) in a table
Hello, I am trying save a list of links in a table. To be able to display the thumb image and/or Title on the front end as a list. Just as how they would display when shared (In WA, Insta etc) Now, when creating such a table, I do not see a specific "url" option. Do I just save it as a string? And in the front end put…
-
Authenticated APIs: How to only show records belonging to a user
Hello, I'm building a project-management system where a user's role could be different by project. For example, on one project, a user could be the Owner but on another project, that user could be a Team Member, etc. As an illustration, suppose there are two projects, Project A and Project B. Each project currently has two…
-
Basic not_empty filter question
I'm using an add on to output an object array. I'm attempting to create a new variable that includes only results for which the addon object array is not empty. I attempted to use dot notation and "not_empty" filtering, but can't seem to accomplish this. Here is a paired down output of what I'm getting. I'd like to exclude…
-
Response message
Hello! I have an endpoint which adds/updates a contact in db (endpoint) + sends an email if some conditions are met (custom function). "Email sending" custom function is a part of the endpoint's flow. It has a precondition that determines if an email must go out or not. I want the endpoint to respond with "Ok" no matter…
-
Dynamic Image Transformation (Ignoring empty records)
I'm trying to resize my 'users' profile_images when it gets pulled to my front end and am currently able to do so through using a loop and following the documentation/tutorial accordingly. https://docs.xano.com/xano-features/images The problem comes when some of my users don't have a profile_image, the loop then breaks…
-
Deleting a table
The help docs indicate that deleting a table should be possible clicking the 3 dots in table view. THis is what i have and cant seem to find how to delete a table.?[2022-05-09_13-26-11.png]
-
Lambda
I have now read the documentation on Lambda. This really is powerful. I just wish there were more examples and tutorials on real scenarios and tips on how to use them in practice. This can help people who come into the NoCode world and are not used to using code. I did some testing and this seems to be a big leap in the…
-
Hi All, I need help with custom functions?
I am building a fleet management app and have created my functions and have them working correctly. What i don't know how to do is to add the functions to my fuel_log table so it can go through and perform the calculations. My functions calculate the km per litre of fuel, the fuel volume per gas tank fill up, the litres…
-
Trying to update an array
What I'm trying to do is update the referrals object in the user_1 record when a new user sign up with his referral link. So I increment the count variable and normally push the new user name to the referrals.list existing array. count is well updated, but for list I tried all the ways I can(push, merge, ...) and it didn't…