Skip to content
Handle simple forms as a pro
Distribute values over rows in a target table
Name
fullName
listTeas
listBoxes
step01
step02
step03
btn_transpose
difficult step to see
Order 1
Louise Vancouille
Green
Oolong
Black
[
Box 150 gram
Box 200 gram
][Box 150 gram
][Box 100 gram
]123
211
[12][1][1]
transpose
[[
Green
][Green
]][[Oolong
]][[Black
]]Order 2
Lorean Desmedt
Oolong
Black
Green
[
Box 150 gram
Box 200 gram
][Box 100 gram
][Box 200 gram
]123
211
[12][1][1]
transpose
[[
Oolong
][Oolong
]][[Black
]][[Green
]]Order 3
Alma Mater
Oolong
Pu-erh
Black
Green
[
Box 150 gram
][Box 100 gram
][Box 100 gram
][Box 150 gram
Box 200 gram
]1234
1112
[1][1][1][12]
transpose
[[
Oolong
]][[Pu-erh
]][[Black
]][[Green
][Green
]]There are no rows in this table
clear target table
Target Table
Name
teas
client
boxes
row 1
Oolong
Alma Mater
Box 150 gram
row 2
Pu-erh
Alma Mater
Box 100 gram
row 3
Black
Alma Mater
Box 100 gram
row 4
Green
Alma Mater
Box 150 gram
row 5
Green
Alma Mater
Box 200 gram
There are no rows in this table
DB Tea Types
Name
Black
Oolong
Green
Pu-erh
There are no rows in this table
DB Boxes
Name
teas
boxTypes
Box 100 gram
Black
Pu-erh
100 gram
Box 150 gram
Oolong
Green
Pu-erh
150 gram
Box 200 gram
Green
Oolong
200 gram
Box 500 gram
Pu-erh
500 gram
Box 600 gram
Green
600 gram
There are no rows in this table
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.