I have a dataset which is unusable, when trying to modify fields, or duplicate or delete data, I have a couple of errors. This is quite critical because I have the error when directly working in the dataset or when users are in the application. The support proposed to me different solutions which are not working (try another connection, try another browser, try another PC, etc…) Here is a list of errors I met: Does anyone encounter these errors? In the web developer console on firefox, I see the below message when I got the error: mutating the [[Prototype]] of an object will cause your code to run very slowly; instead create the object with the correct initial [[Prototype]] Does anyone know what does it mean? Many thanks for your help Regards, Pierre-yves

Hello, I have got a performance issue on a page which loads data from dataset. A first query using email is searching data from Table 1 Then information from table 1 is use to query another Table 2 with a setFilter. Unfortunately, the code is not correct as it is too long to show final information… Does anyone have an idea how I can improve the below code? Thanks Regards, Pierre-yves Meyer $w.onReady(function () { user.getEmail().then((email) => { let userEmail = email; $w("#email").text = userEmail; // Selection company wixData.query("clientDataset") //select the client .eq("userStatus", "active") .contains("title", userEmail) .find() .then((results) => { let items = results.items; let company = items[0].userCompany; //select company from client console.log(items); // Selection flights per company $w("#flightDataset").setFilter(wixData.filter() //select final data .contains("userCompany", company) .hasSome("flightStatus", "submitted", "confirmed") .ne("flightVisible", "N") ) .then(() => { console.log("Flights Dataset is now filtered"); }) .catch((err) => { console.log(err); }); }) .catch((err) => { let errorMsg = err; console.log(errorMsg); }); }); });

Hello, On my first page just after loggin, for some reason, the code is not applied… If I reload the page manually (just click enter in the URL, the code is working!) See below just to hide or show a button depending to a wixdata query. Thanks regards Pierre-yves $w.onReady(function () { let user; user = wixUsers.currentUser; $w("#adminButton").hide(); user.getEmail().then((email) => { let userEmail = email; $w("#email").text = userEmail; let count; wixData.query("clientDataset") .eq("title", userEmail) .eq("userStatus", "active") .hasSome("userType", "pilot", "system") .find() .then((results) => { //console.log(results); count = results.totalCount; //console.log(count); if (count >= 1) { $w("#adminButton").show(); // NOT WORKING ON FIRST LOAD – WORKING WHEN RELOADING URL } else { $w("#adminButton").hide(); } }) .catch((err) => { let errorMsg = err; console.log(errorMsg); }); }); });

Hello, My dataset are completely similar between live and sandbox I have an issue with below code which is working well in test: For my test I hardcoded the variable userEmail The below filter is working well in test and not in prod… Any idea what’s going on ? Thanks for your help Pym let userEmail; userEmail = "XXXX"; export function packageDataset_ready() { wixData.query("clientDataset") .eq("userStatus", "active") .contains("title", userEmail) .find() .then((results) => { let items = results.items; let company = items[0].userCompany; $w("#packageDataset").setFilter(wixData.filter() // does not filter anything in prod.... .contains("userCompany", company) ) .then(() => { console.log("package Dataset is now filtered"); }) .catch((err) => { console.log(err); }); }); }

Hello, I am sending email via sendGrid which is working well. But I am only able to send basic email with simple text. Have you got examples to send enrich HTML email in the body ? sendEmailWithRecipient(subject, body, recipient); Thanks for your help Regards, Pym

Hi, I have a dropdown, the selection is connected to a dataset where there are 1438 lines. For some reason, when using the dropdown, I can only see the first 997 lines, the rest is missing ??? Is it a bug ? Is there a fix or workaround ? Thanks for your help. Regards, Pierre-yves

Hi, I have a dataset A with a field “date” and a field “status” I want to be able to update the status to the value “pending” when the field “date” equals to Today. This action is not before any insertion, update, delete, etc… Thus, I guess I can’t use Hook ? Any advise about this request ? Thanks for your help Regards, pym

Hello, I just want to be able to store the result of a query in a variable and unfortunately it did not work. I know the query is finding a value because when I put a console.log inside the query it is working. But unfortunately when I move the console.log outside, it is not working… let airportFrom = $w("#selectionAirportFrom").value; let itemAirport; wixData.query("airportDataset") .eq("airportName", airportFrom) .find() .then((results) => { let items = results.items; itemAirport = items[0].oaci; }) .catch((err) => { let errorMsg = err; console.log(errorMsg); }); console.log(itemAirport); /// -> ItemAirport is not visible in the console Thanks Pym

Hello, Does anyone already use the google Oauth 2.0 ? I want to insert an event via api in google calendar but I need first to make a authentication request before inserting my event. Unfortunately, I did not succeed to submit an authentication. Any advise ? Thx pierre-yves My fetch is: const url = "https://accounts.google.com/o/oauth2/v2/auth"; const request = { "redirect_uri": "https://www.think4jet.com/test-html", "response_type": "=code&", "client_id": "MY_CLIENT_ID", "scope": "https://www.googleapis.com/auth/calendar" }; return fetch(url, request); .then(response => console.info(response.json()));

Hello, Does anyone already connect to the google API third partie service ? I tried without success to connect to the google API using the sendgrid example but this is too complicated to me… Do you know where I can find a example with explain with details how I can authenticate and use the google API Many thanks for your help Pierre-yves

I have a form to book a flight with standard fields: Flight date, from, to , flight hour, flight min, etc… My request is from all the information's I get from clients, I want to create an event in a google calendar when the client click on submit the flight ? Any ideas how I can deal this quite complex requirement ? Many thanks Pierre-yves

Hello, Here is my request: I am building a page to book flight with a standard setup; Inputs are based on the fields (departure, destination, day of departure, time, etc…) When the client create a one-way journey and submit his request, I have one line created in a dataset. (Via a link connects to submit) For a round-trip, I would like to be able to create 2 lines in my dataset: One the departure and the other the return? Any ideas how I can create 2 entry in a database with one submission? Via a hook? Thanks for your help. Regards, Pierre-yves