-
How to push an object into an object, as a variable
Hello, I am trying to create a result JSON object array variable that has another object with a variable name "company_data". How do i push into Result such that company_data shows as company data? Result [ { company_data:{ "name": "Apple", "address": "520, San francisco" } "resultpath1": "xyz" } Currently when i push…
-
Update an array within an object array
Hello, I have a "comments" object array within an object array of "Posts". I want to selectively push this comments array into a fresh results object array that is similar to posts, but i am unable to traverse the results object array in the for loop. Posts: { user { username: "ABC", ..., } Comments: { Comment id= 124,…
-
Access data within POINT
I'm using the Google Distance Matrix to find out the driving distance between two points in my database records. To do that, I need to format the latitudes and longitudes in a particular way within the query. But I can't seem to easy access the lat or lng within a property with the point data type. The property is called…
-
(Untitled)
Hi there, I have 2 tables A and B. I need to gets all records of table A which does not exists in table B. I could'nt get the way to do this. Please guide me to achieve it. Thanks
-
Add a new attribute to objects in array
I have a date attribute in a table and want to add a new weekday property before returning the array to clients. How can I do that?
-
Setup multi reference field?
TLDR: multi-reference drop down in database? I have a database of entries which I want users to be able to tag. I have a separate database of tags, is there a way to reference these tags in a dropdown in the entries database but allow multiple selections? At the moment I can only set it to reference a single tag per entry.…
-
get an object in an array based on it's property
Hello, I'm parsing a "product" object (json) that contains a property "images" which is an array of objects. { ..., images:[ { type:"primary", width:600, uri:"xxx" }, { ... } ], ... } I'd like to get the uri property of the image that has the type property set to "primary", but i can't figure out how to do that. There are…
-
Tutorial: Get Relative Timezone (e.g. "3 days ago")
Overview This endpoint GETs a time and returns the relative time to NOW (e.g. "5 minutes ago" or "2 weeks ago"). I use it to show when a post was created. delta is the difference between NOW and a timestamp input in seconds. Format U. rel_time is the variable to display the relative time. Note: I'm using the user's…
-
Update field to Xano timezone
Hi, I have an app that is global, so users have different timezones. I made a table "user" with their data and the respective timezone. How can I build a function that will update the timestamp field from the user timezone to xano timezone? Thank you very much in advance.
-
Formatting phone numbers
Hi all! I need to determine whether or not a potential new user exists based on whether or not their phone number is already stored in my db. But, phone numbers are being provided from different sources - some from user input, some from pulling contact info, etc.. I'm only using US phone numbers for now. Does anyone have…
-
Is Conditional Function the right process for getting the meetings i want from a list of meetings?
SORRY in advance for simple simple question — I created the idea below. I've gotten confused with FILTERS under MANIPULATION since its also what I was trying to achieve but now im thinking its supposed to be here?[image.png]
-
Help to reference a unique record inside a TABLE REFERENCE Field type? In my example, the email reco
[XANO Help.png]
-
Save time only in Database
I am using timestamp to save time in table but using timestamp time and date both store but i want only time
-
JSON.parse()
I can do a JSON.parse() to be able to turn a json into an object, as I will need to manipulate the data I get via json.
-
Set field_value to Integer rather than Array with Integer [Solved]
I'm using dot notation to set the value of a field. It sets the value as an array with the single value rather than just the value, unless I add a filter like MAX or MIN that pulls the highest value from the single-value array. (e.g. active_goal.id returns [17] instead of 17. active_goal.id with MAX filter returns 17.)…
-
Filtering Multiple API Get Requests
I'm working with Xano and Bravo Studio, but I think I might be trying to do something Bravo can't do as it is, so I'm hoping this can be achieved in the back end by using different API Get requests. I've got a medical section which is getting a little complex; obviously you have the user then 'patient' then brand of med,…
-
Error Unsupported Operand types:array*array
Actually I am trying to multiple two row and then this error occurred in below table two row price and quantity value of price is 100 and quantity is 2 and I want to multiple this two number how can I do that please help me [IMG_20211104_210003.jpg]
-
Grouping
Hi. im new on xano How can i get this response? or this is possible on xano? thank you. [ { name: sample1, completed: 1, incomplete: 2 }, { name: sample2, completed: 1, incomplete: 1 }, ] table recordsname | status sample1 | incomplete sample1 | incomplete sample1 | complete sample2 | incomplete sample2 | complete
-
How to Count Records by the Week they were Created?
Overall ObjectiveUsers set a target for the number of times they want to workout per week and for how long (e.g. 4 workouts per week for 20 out of 26 weeks). Every time they workout, the post a photo to prove they worked out. To see if they achieved their target, I need to count the number of workouts every week and…
-
Problem on set path
Hi, I am trying to form an object but the Key contains a period at the end, and when forming the object it does not consider the point[image.png]In this case var_key was used as path in SET filter[image.png]but, object has't period at end of key. Are there any character restrictions on a path?
-
Database Table Setup and Pulling Info from Different Tables
So I think I need a new Database table, but a lot of the entries already exist in other tables. So for example, 8 of the 10 entries might exist elsewhere in other tables, so I want to populate this new database table with that information, such as Name, location, profile pic, etc. This table will be used for a specific…
-
divide + ceil = 81.1 ??
Hi guys, I'm quite confused with the ceil filter. It's supposed to round a decimal up to the next integer, but in my case, it doesn't. 🤷♂️ [image.png] "total_pages" is initialized with the the value of the key "count" in the input "folder" (json). In this case, it's 811. When I divide total_pages by 10 (the value of the…
-
Creating time periods from two dates for a list of objects
Hey folks, really exciting getting going with Xano, looks great so far. I'm having a bit of a trouble getting something over the line in workflows which id massively appreciate some advice on. An example of what I want to achieve is: Data Table 1 Item 1 Start 01/05/21 End 06/15/21 Item 2 Start 03/20/21 End 09/24/21 Create…
-
Designing a database
Hello everyone, I'm very new at developing and I am having a hard time trying to figure out the best way to structure my database for my project. I am building an e-commerce platform that incorporates payments on one side and on another side digital advertising for music artists. I already have some tables setup within my…
-
What's the best database structure?
Hi all! I'm planning on storing data from different data sources: fb ads, instagram insight, google ads, etc. How can I best organize my database? Store data for different sources in a separate table and then combine these tables into one common one, or immediately make one common table in which there will be fields for…
-
is this the best way to do this?
I got this to work, so there's no issue. I'm just curious if there's a more efficient way to do this. In my external API request, the URL requires two variables. So I did this: [image.png] I'm coming from integromat where I could easily map variables within the URL. Can I do that in Xano? For example, one of the videos…
-
Does anyone have an efficient way to only update columns with values?
It currently seems that when you call EDIT {DB Table} any inputs that are empty or null are updated as such in the record. I would like to make my inputs optional and only update when a value exists. I am wondering if anyone has also implemented this and how they did it. For now I am thinking I need to pull (READ) the…
-
Composite Keys
How can I create a composite key in the Xano database? Is it possible to create my own PKs?
-
Adding .self URL instead of id value
I want to make my response JSON more REST with a .self value that contains the URL to the self instead of just the id. Also, I want to include child values that use an URL instead of a collection of ids. example: .../team/1234 responds with: { "self": "{api base}/team/1234", "team_name": "Bad News Bears", "members": "{api…
-
"Has Record" with multiple criteria?
Would it make sense to fetch the DB with a "Has Record" based on multiple criteria, as in " where column1='a' AND column2 ='b' "? Right now, that's not possible, the "Has Record" only works with one criteria afaik. I would mostly like to use it to validate entries for API Endpoints. The way I see it, the only way to do…