-
Create Table References Based on External IDs
Hello everyone, I followed the video below to create references Based on External IDs on the table containing 600 records : Here is the function I created to perform this action: It seems to work but...only 70 records are processed... Looking at the video again, it seems that it is necessary to configure the pagination in…
-
Best practice for database archives in searches
Hi everyone! The issue Currently, we're storing logs in the database, so thousands of new entries are added every hour. We also need to be able to perform fast searches in these log entries. Most of the time, we don't need to perform searches in entries older than 10 days. I am wondering what would be the best practice in…
-
Is it possible to rename images in my file library?
If they are not linked to anything but they are just sitting in my library, can I rename them? Or, do I have to re-upload all of them?
-
‘Item removed’
I have the for each loop matching values but then it’s saying the value is removed. Or they don’t match even when values are in both tables. What I am trying to is link two tables from Airtable where one table is linked in two columns to match them together. One table has 400 values and have 6k combinations. My current…
-
Reference No Longer Exists
When I try to follow this video, I get ' Reference does not exist' https://youtu.be/hulHk9v3Phk I am trying to import and connect two airtable tables. What can I do to fix this? Help!
-
adding a column to table w/o destroying existing data
If i add a column to a table will it reset data in other fields. How can I make sure this does not happen or rather how do I achieve this goal. Is it also possible to have that new column have a default value in each of the existing rows. How do i do that. Thx
-
Set a value in a list of objects if condition is met
I have a list of objects made like this: [{restaurant_id: 2, entrance: 4}, {restaurant_id:3, entrance:5},{restaurant_id:4, entrance:6}..] My goal is to edit (possibily using a conditional set filter, the list if restaurant_id equals a given number. I know this could be done also through a FOR cicle or in other ways but I'm…
-
array filter to perform regex
Trying to filter array of objects to return a subset where a string property matches the regex. i am using a filter function on array and in the lambda I have the following but i am having problems getting Objects like RegExp or string methds like match to work var mystr = $this._tags.tag_name.matches; const re = /^[^\$]/…
-
Bulk Update In DB
Hello! I know the question can be dumb but I have scanned all Youtube videos and researched. I have a Custom Function that filters the data and saving them into another DB table. I also want to mark this DB as "processed". I have added a "processed" boolean in DB but I couldn't find a way to bulk update "ALL Records" in…
-
Error running a For loop
I am getting this error "message: xano\extension\xs\Arrays::xano\extension\xs\{closure}(): Argument #1 ($list) must be of type array, int given" I am passing a list of integers to the for loop that are record ids and then looping thru each to create related records for each id. I see the [ ] brackets on the input so can't…
-
Matching values from multiple arrays
Hi there, I have the following set-up: ---- Database table: users userID name companyID ------ Database table: messages messageID target_users (which is an array() that simply contains userID's) ------ Array companies: which is just a list of companyID's Now what I want to do is the following: A query that says: SELECT…
-
How do you allow an app user to copy a record in their account?
Hey everyone! I'm using Draftbit + Xano for my mobile app (iOS & Android) and am wondering if it's possible to allow a user to copy a record in their account. Here's a use case: A restaurant is using my app to share offers and events to attract customers. Offers/events live in the 'Incentive' table in Xano. Offers are…
-
Sorting, case insensitive
How can I make sort a result from a query used in an API by case insensitive? Here is some sample data in a sortBy field: Apple ape Abe apricot Bernie banana Button bill ------------------- After sorting using Xano the results are: Abe Apple Bernie Button ape apricot banana bill -------------------------- However I'd like…
-
Edit an Array of object in a given index
I'm looping over an Array of objects, and I need to edit it at a specific Index. If I try to use Update variable, and select the Array.Index, Xano will actually not edit the element overthere but will look for an object subpath called Index within the list. How can I solve this?
-
Scheduling PDF Creation?
I have a page/site setup in WeWeb which has a button that uses HTML2PDF (https://www.npmjs.com/package/html2pdf.js/v/0.9.0) to create PDFs. However, my requirement is to have PDFs created at a scheduled time and either save the PDF and/or Email the PDF. How would you recommend I go about doing this? I'm not afraid to use a…
-
How to upload bulk image in xano
I am store image in xano using image data type in table and endpoint I am using file resources so my question how can i upload multiple image in xano I try via for loop but its not work please help me
-
Add-ons or Joins vertically on a table?
Hi, I have 2 tables that have almost all of the same columns. One is of official data, the other is of 'proposed' data. These tables for the most part are displayed separately in my app on my front end. Some of the rows in my 'proposed data' will be 'promoted' to be displayed in the 'official data'. I am trying to figure…
-
Code generation from string disallowed in this context
Hey guys, I'm trying to dynamically build a JSON object from a Javascript-end definition. My input is plain-text, like: "obj[people][name] = 'Anthony'; obj[people][age] = 19;" And I want to build a JSON object that I can work with in Xano. I am able to do it in Node.js locally, so I tried to use Lambdas and run that…
-
How to update an environment variable in function?
Hey! How do I update an environment variable in the function stack? I'm using a GET request with the Spotify API, and my access token expires every 60 minutes. I designed my stack to request a new access token. If a 401 code is received, an If condition request a new token, and the request is rerun with the new one. It is…
-
Serialize module in Lambda
I'm trying to verify a webhook provided by Paddle. According to their example, I need to serialize the object before verifying with crypto. Is there a way to do this on Xano with Lambda? Their example uses "php-serialize" module which is not available on Xano as far as I know. Any thoughts? Paddle guide:…
-
How to aggregate by dates?
Hello! Let's say I have a list of timestamps and I would like a count of number of timestamps by each date. How would I do this? So for example, given a list of 20 timestamps, the ideal output would be: 9th Nov: 10 10th Nov: 3 11: Nov: 7
-
Tranform_timestamp = Blank
Hello. I'm trying to manipulate timestamp but it always ends with blank cell. I'm trying to add days to a timestamp The input "duration" cointains data like "+X days". What am I doing wrong please ? Even if i manually "+3 days" without using the input, i hav a weird result. For example if i try to add 3 days from today, it…
-
External Query but for Grouping / Aggregating
The external query capability for using a JSON structured input as a filter criteria is great, and provides significant flexibility with how front end app's can interact with Xano data. But what about when the front end also needs to instruct Xano on what fields to group and aggregate by for a query? It appears that…
-
encrypt certain fields in a record during record creation and decryot under authorized access
What do I need to encrypt certain fields in a record during record creation and decryot under authorized access Thx
-
Transforming arrays into an array
Hi there! I have [ [{a}], [{b}], [{c}] ] I need [ {a}, {b}, {c} ] Any ideas? Thanks!
-
Product Variants / Combinations
Hi all, I would like to create a combination of products for the different options that may be available. So for example, a T-shirt may have: sizes [S, M, L] colours [red, green, blue] That gives 9 (3x3) combinations. How would one go about working the function stack? Any/all help is greatly appreciated! :)
-
Using Get or Has filter with nested JSON
I am returning JSON from a webhook and it seems that when a value is null, they just don't include it rather than passing a null. This always produces errors when using dot notation and I am unable to capture all the data I need due to this. I would like to implement this solution,…
-
Updating "addons" value
Hello, so I want to update the value in my response, because the timestamp gets displayed incorrectly in my bubble app. This is how the response looks - and I am trying to run a "for each" loop to update all of the "created_at" values, Tried it in several different ways, but none seem to work, I just keep getting the same…
-
EDIT record - referring to the object itself
I need to edit the object field of USER object "booking list"[]. I'd like to take the present bookinglist[] of that USER and apply a filter on it. How do I refer to it? Xano reads it only as text, what would be the right notation?
-
Any way to output timestamp to user's timezone?
Is there an easy way, on the back end, for Xano to figure out what timezone a request is being made from, then filter the timestamp output to be in the timezone of the user? For example: user creates content and the timestamp is logged in Xano as "now." I'm using a "format_timestamp" filter to make it human readable. I'm…