Forum Discussion
AustinK
Qrew Commander
That is interesting. So you need a copy of the tables field names with their ID's to get imported to another table? I see some more happening there but it's a little tough to visualize what it is doing for me right now. I'm hoping to get some helpful info from you so I can mull it over and hopefully others are able to jump in too.
Which part is currently failing? Is any error happening or does it just not work? Even a console error.
Which part is currently failing? Is any error happening or does it just not work? Even a console error.
DEVICECYCLE
5 years agoQrew Member
the console only says "null" but in debugging it highlighted "console.dir(json);".
By the way, this is the illustration of what this js. does for us in a smaller scale, just disregard the field name
Table 1 (this is the source table)
It groups it by variation and summarize it into xml, (notice the variation a-1-green-square has total quantity of 2)
Then it imports it to Table no2 - here should be the result of the destination table.
Please let us know if there's any other way to accomplish this.
We really appreciates your help,
Roel
------------------------------
Roel David
------------------------------
By the way, this is the illustration of what this js. does for us in a smaller scale, just disregard the field name
Table 1 (this is the source table)
Letter | Number | Color | shapes | Qty |
a | 1 | black | circle | 1 |
b | 2 | white yellow | square | 1 |
c | 1 | green | circle | 1 |
d | 2 | green | square | 1 |
a | 1 | orange | square | 1 |
b | 2 | black | square | 1 |
c | 1 | white yellow | square | 1 |
d | 2 | green | square | 1 |
a | 1 | green | square | 1 |
b | 2 | orange | square | 1 |
c | 1 | black | circle | 1 |
d | 2 | white yellow | circle | 1 |
a | 1 | green | square | 1 |
b | 2 | green | triangle | 1 |
c | 1 | orange | circle | 1 |
d | 2 | green | circle | 1 |
It groups it by variation and summarize it into xml, (notice the variation a-1-green-square has total quantity of 2)
Letter | Number | Color | shapes | Total Qty |
a | 1 | black | circle | 1 |
a | 1 | green | square | 2 |
a | 1 | orange | square | 1 |
b | 2 | black | square | 1 |
b | 2 | green | triangle | 1 |
b | 2 | orange | square | 1 |
b | 2 | white yellow | square | 1 |
c | 1 | black | circle | 1 |
c | 1 | green | circle | 1 |
c | 1 | orange | circle | 1 |
c | 1 | white yellow | square | 1 |
d | 2 | green | circle | 1 |
d | 2 | green | square | 2 |
d | 2 | white yellow | circle | 1 |
Then it imports it to Table no2 - here should be the result of the destination table.
Letter | Number | Color | shapes | Total Qty |
a | 1 | black | circle | 1 |
a | 1 | green | square | 2 |
a | 1 | orange | square | 1 |
b | 2 | black | square | 1 |
b | 2 | green | triangle | 1 |
b | 2 | orange | square | 1 |
b | 2 | white yellow | square | 1 |
c | 1 | black | circle | 1 |
c | 1 | green | circle | 1 |
c | 1 | orange | circle | 1 |
c | 1 | white yellow | square | 1 |
d | 2 | green | circle | 1 |
d | 2 | green | square | 2 |
d | 2 | white yellow | circle | 1 |
Please let us know if there's any other way to accomplish this.
We really appreciates your help,
Roel
------------------------------
Roel David
------------------------------
- MarkShnier__You5 years agoQrew LegendIf this is mission critical, I would suggest contacting one of the larger the QSP shops who have JavaScript coders on staff. Trinity, Veil Sun, MCF, The Data Collaborative, CloudBase come to mind, among others.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------- AustinK5 years agoQrew CommanderI would also suggest this. There are definitely some people here who are good with JavaScript but Roel might have to wait several days for an answer. They might even be able to come up with something that involves less code.