I started not long ago a swift bootcamp guide and I finally realized im not built to be a coder.
I found recently bubble.io and I had a more or less relaxing experience using it. However I encountered a problem.
I want to make a custom form in javascript most likely which a client can use to add a product and get the price. The prices are set in a 4000 SKU excel file, each with a unique ID.
Basically they input height, width, select the type of size (raw dimensions/final dimensions) select a color, select the opening type, select the quality, select the number of units and can choose to either find out the price or add another product. ** How its supposed to work in terms of variables:
var screenHeight = heightLabel.value (dunno if its how javascript code works)
var screenWidth = widthLabel.value
var sizeType = 0
var colorValue = 0
var openingType = 0
and how it gets the 9-digit code
if openingType = 1 then it should get "31" then
widthLabel/100 rounded up to 2 digits (750mm/100= 7.5 => 7) and it should get "07"
then
heightLabel/100 rounded up to 2 digits (1450mm/100= 14.5 => 14) and it should get "14"
then
if colorLabel = "white" then it should add "1"
then
if qualityLabel = "economy" then it should add "2"
then
if numberOfOpenings = "simple" then it should add "1"
so we end up with
var screenCode = 310714121
Now I dont know if there is a way to get a sort of vlookup(screenCode) inside the table I will provide as .csv
Tutorials, forums, video instruction
