Have you wanted to save data from a calculated field? Then you are in the right place.
Saving a solution or answer to WIX database collection is easier than expected. Using WIX Data Hooks, it is absolutely achievable to save a calculated field before it is inserted into the database.
WHAT I DID
The steps to achieving this procedure is quite basic. Assuming you already know the formula to use then the rest is merely assigning your answer to the answer field in your database. Before adding the code, I connected my form element(Date Picker) to data. WHY? The date picker value (Year selected) is what I used for the calculation. So it was important I took the value from there and substracted from the current year using new Date() object. I then added my data hook from by clicking on the three dot icon option for my database and clicked on Add/Remove Hooks.
Next I added the beforeInsert function and started modifying my code. My edited code looked something like that.
In order to calculate the date picker field, I decided to intercept the values before it was inserted and used it to calculate for the age. This date was then saved in a field in my database. Eventually, I will use this field in my website displaying it or using it for another operation it comes to that.
FINAL DISCUSSION
Well, that rounds up technically every step. My final code is below and you can copy and paste for personal use. I hope you enjoyed this tutorial, don't forget to LIKE/SUBSCRIBE
Code
Leave a comment (2)
Thanks for leaving a comment🎉
ahmed
May 19, 2024
wix form data
Hi i need your help also in wix form submission
the problem is that some fields are generated when $w.onReady(function () { like day & date and when i choose the student name i get the phone number from database .
and the form save only the field u fill it by ur self like input or dropdown
Reply
Walter Odibi
January 20, 2000
bromar
Sep 29, 2023
Love the tutorial!!!
You are truly great at creating these instructional videos!! Thank you! I am having trouble figuring out . . 'the triggered email' . . it is not being sent to the user submitting the form, the form and the email to the admin works great. . Could you point me to where this might have already been addressed? or any other help? On a second note. .the submit button success/failure message will go back to the default message once it's connected to the data set(I couldn't figure that out either. )
Reply
Walter Odibi
January 20, 2000
kaan
Jun 4, 2023
wishlist and rating system
hello sir I try today 2 hours but not working if you want I pay money can you do this 2 ( wishlist and rating star) system please I send to you invaid
Reply
Walter Odibi
January 20, 2000
Hi there, you can contact me here using the in-app chatbox
Waqas
Apr 16, 2023
Triggered Email Backend
Hi mate please can you send email by backend
Reply
Walter Odibi
January 20, 2000
Hi Waqas, there isn't a backend code for this tutorial. The emails will be sent from the client-side.
Ghan
Dec 29, 2022
Great Tutorial
Hi !
First of all, I want to thank you for your great tutorials, they helped us a lot with the coding.
But I still need your help, if you don't mind. I have based on Save Calculated Field using Wix Data Hooks Codes, to code my form . but the problem is I don't know why the code only reads the computation for "week2" computation and not the "weeks"
here is the code
I also did a separate column in the dataset where the chosen datas for both fields will be placed.
$w.onReady (() => {
$w("#Person").onChange(() => {
$w("#weeks").onChange(() => {
$w("#week2").onChange(() => {
let person = Number($w("#Person").value);
let weeks = Number($w("#weeks").value);
let week2 = Number($w("#week2").value);
$w("#totalLabel").show();
$w("#totalLabel").text = `"${String(weeks * Number(person))}페소"`; //DESIGN YOUR MESSAGE
$w("#totalLabel").text = `"${String(week2 * Number(person))}페소"`; //DESIGN YOUR MESSAGE
});
});
});
});
Reply
Walter Odibi
January 20, 2000
Hi there, thanks for your comment. I see why this is a problem. The onChange() function seems wrong in combination.
To combine onChangeFunctions use this method
$w("#Person, #weeks, #weeks2").onChange(() => {
//code here
});
Walter
Aug 8, 2022
More Details? Watch video
Hi, you can click here to watch the video https://www.youtube.com/watch?v=9bx7-nBeZ5c
Reply
Walter Odibi
January 20, 2000
Walter
Jul 11, 2022
For you
📺 WATCH THE VIDEO https://www.youtube.com/watch?v=AgPJEU8wpp0
Reply
Walter Odibi
January 20, 2000
Walter Odibi
Apr 18, 2022
Awesome Feature
This tutorial shows you how to display views on your Wix repeater.
📺WATCH VIDEO HERE https://www.youtube.com/watch?v=Iz7SdaCSdXg
Reply
Walter Odibi
January 20, 2000
Walter Odibi
Apr 18, 2022
Amazing tutorial
This amazing tutorial will show you how to a comment section to your WIX dynamic page.
📺WATCH VIDEO HERE https://www.youtube.com/watch?v=f8-vJQFNZ_c
Reply
Walter Odibi
January 20, 2000
Walter Odibi
Apr 10, 2022
Great Feature🎉
This amazing tutorial will show you how to add a visitor view counter to your WIX dynamic page.
🚩MORE TUTORIALS https://www.wixgenius.com/wix-tutorials
Reply
Walter Odibi
January 20, 2000
RELATED TUTORIALS 🚀
Quote Calculator