-
What is the difference between "push" and "append" filters?
Hi, I've read the documentation on the "push" and "append" filters but still don't get the difference. Can someone please explain it here and, if possible, give an example? Thanks!
-
Connect Xano and Outseta
I've followed the tutorial connecting Xano and Outseta, but can't get xano to add a record when a user logs in. I've been exact in configuring the marketplace extension as per the instructions. Do I need to alter the post login URL in outseta? Any ideas why this isn't working?
-
Where is the encrypted data stored?
I have a question, I've been using the encrypt and decrypt options, and out of curiosity, I want to understand how the encrypted data is stored? When it's decrypted, where do these values come back from?
-
webhook response format
Heyy all. i am trying to configure the whatsapp webhook, in the response i must return a value that is sent to me in the input, this value i save it in a variable and return it in the response but i have this response from whatsapp. my response has this "/" how can i delete this?
-
Double-entry bookkeeping
Hi all, We are planning on building a double-entry bookkeeping with Xano. Anyone here with prior experience in building such datamodal and logic (with Xano)? Thanks, Ben
-
How to Syncronize CMS from Webflow to a DataBase on Webflow?
Hi! I have a CMS Colection in Webflow and I integrated with Xano. I did the request to the API of Weblflow, but I'm not sure what i should do to record the information of the cms on Webflow on a DataBase of Xano. For the moment I'am receaving an array with all the objects that i want. And each object with entries…
-
Filter objects in an array
Hi, I am getting an array of products (json objects) as response from an external api call: Example: products = [ { id: 1, name: 'Product 1', price: 9.99, description: 'Description of product 1' }, { id: 2, name: 'Product 2', price: 19.99, description: 'Description of product 2' } ] I'd like to create a new array…
-
compare 2 lists and make new list
Hey guys, I have 2 tables: Table1: extras, Table 2: hunts In hunts, I have an object list of extras added to the hunt. I'm trying to create 2 lists: 1: extras not added to the hunt 2: extras added to the hunt Getting #2 is easy (getting extras of a hunt) I'm having trouble with extras not added to a hunt. I tried querying…
-
Confusing Display of Dates in Database View
Hi there, In my day to day operations for my app, it is critical that my data is saved in UTC, which it is currently doing. However while doing a query based on dates recently, I was missing some data, and while investigating the dates in my Xano database I got very confused thinking my dates where incorrectly being stored…
-
Error "Missing var entry" not being solved with "get" filter
Hi, I am having this error (see image). It is true that the variable is missing (that is intended) but I thought that the "get" filter avoided this error to happen when the variable was not found. Have I set the "get" filter wrong or should I, instead of using that filter, set a conditional that appends the variable only…
-
How to download files?
Hi, I am storing some pdfs on my user table. I want to have an endpoint that will download the file immediately (not just generate a url). This might be a dumb question, not sure if something like this is doable. I tried something like this: It does create a download link, the pdf file is named how I want it, but when I…
-
Table setup / import a new table
Is there a quick way for setting up the headers/columns for a table? I'm migrating from Bubble and want to replicate my database but the structure is pretty big and it's taking a long time.
-
How do I delete a list variable in my database?
At the start of my function I want to delete the existing variable list in my user database, so that it is empty and I can repopulate it with new variables. I know there is delete record, but I want to delete all the items in the list instead of just one item. What's the easiest way to do this?
-
Issues with Conditional or Caching?
Hi, what am I doing wrong here: having a user table with Has_balance boolean Checking if user Has_boolean=true doesn't work, it always goes to else. Pls see the screenshots with comments. Thank you
-
Weak Password Even when Not Required
Hi there - Any suggestions on how to properly set-up password and auth token with xano & bubble.io? When I try with and without the password required in xano, I am getting an error and even when I meet the requirements.
-
Does my Stripe create tokens cURL command import look normal?
Guys, I've imported this into Xano: curl https://api.stripe.com/v1/tokens \ -u sk_test_51MKlHvJaJ66qam0ro2Aoud3nRpdL91gbsUg0Wp9NM3D0Fniqy2yx66oy5YkaNjkX3HotTBPDcQglAiffKypWj2SV00MOzxycdY: \ -d "card[number]"=4242424242424242 \ -d "card[exp_month]"=5 \ -d "card[exp_year]"=2024 \ -d "card[cvc]"=314 and I see this "Basic"…
-
Perform Neperien Logarithm calculation in Xano
Dear Community, Does any one has a clue on how to perform Excel LN() function in Xano ? I cannot manage to find this operator in the math section even if EXP() is available. Thanks for your help
-
Add Object Record
Hi, I want to add a new record using API. I have an object field called "Layanan" and inside it has an enum list with 3 values which are "BI-RTGS", "BI-Fast", and "Lalu lintas Giro". I tried to do it, but it returns the following error message. How should I do it?
-
How do you approach an up vote/ down vote tool?
I have an order column in my table and each record has a number. On the front end I sort the records by the order number. Now I want to allow users to move a record up or down the order. How do I keep track of the order numbers, update the record before and after the record I am moving? This is the interface I am looking…
-
Replace path in an object
Hi, I am getting this info of a product (see below) from Meta catalog and named it "variant_json". Now I need to do an external call sending "variant_json" as parameter but the path "name" should be changed to "title". Will I have to create a new object variable from scratch (setting each path and value one by one) or is…
-
Updating another table field after doing an insert?
I have a table of scripts, that has a filed called questions (object). This questions field stores a ref to the questionID, from my questions table. when I create a new question on my front end, I want to update the related script by adding the questionID to that object field in scripts. I cant do it as I do not know the…
-
Use Case : Relationship and calculated fields
Dear Community, Q1) I wish to change the result of a field in database A (Category_Value) based on the value in Data base B (User_Category) any time a value is change for the User_Category in Table A. Q2) I need to proceed to some calculation sur as "=SI(SUP.SEUIL(A2;0,451);0;EXP((A2-33%)/(33%-45%)*LN(1,15-1)))" (excel…
-
Can I turn off my pc while running and debugging a workflow?
Hi, I am running through the debugger a workflow that will take around 6 hours. Will it be canceled if I turn the computer off? Thanks!
-
Completely confused on how to set up my database.
I'm completely confused! I am creating a price comparison site which is combined with student discounts. The retailers either fit into the category of products or services. The problem is that retailers sometimes have different discounts for different products and so there isn't a flat discount rate that they use. This…
-
Just planning my database but need some help
I am creating a price comparison site that will have some products on it. I will be negotiating the deals from the companies themselves and so I know I'm going to need a database for the following: User, Brands, Discount, Products and Ledger. My question is that some products will be laptops and some may be other…
-
Auth not passing "name" through
Hey all, I have a signup integration going via webflow wized. I have email, password and name fields. Email and password is passing through fine via xano "auth" to my "user" db but name is not showing up in my "user" db… any suggestions why that is? Thanks!
-
searching contain "ends with"
Hi what should I do to get in search request any results that contain words that ends with "ing"? I found how to get in request start with: "pro:*"
-
Does anyone know how to fix this error when using set_ifnotempty?
I am trying to edit this data in my project without the fields that are already populated turning blank. I added the set_ifnotempty filter to one of the inputs as shown in the tutorial video in the documentation. However, whenever I run it, I get this error. Anyone know how to fix this? Any help is greatly appreciated!
-
Store roles in auth JWE extras ?
Hello, I am storing an array of roles because an User can have multiple roles vs single role However in a Precondition I don't have array operators such as in, contains Any idea ? Thanks :)
-
CSV upload to an enum list
I am having trouble uploading my csv to my enum list column. I was wondering how the data has to formatted in the csv to properly transfer to xano