Forum Discussion
MarkShnier__You
Qrew Legend
6 years agoAre you saying that on that entry form, the user can enter up to 8 entries ie 8 pars of project names and hours worked?
and you need to be able to export that into up to 8 rows?
Mark
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
and you need to be able to export that into up to 8 rows?
Mark
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- RajHelaiya6 years agoQrew CaptainYes, exactly. I am not sure how that would be possible.
------------------------------
Raj Helaiya
------------------------------- MarkShnier__You6 years ago
Qrew Legend
I would make Project Export (scratch) table to hold the normalized results. By a scratch table i man a temporary table which is just used to collect the export data.
Then I would make 8 saved table to table imports to export the data from Project Entry. Each would be filtered respectively when Project # X has data.
Then I would make a URL formula button would would do 10 successive steps.
Delete all records in the scratch table.
Run each of the 8 saved table to table imports.
Land the user on the scratch table.
If you need help with building that button, I can help you once you do the other setup. Once you do the setup though, you can run each import once, manually, and see the result.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- RajHelaiya6 years agoQrew CaptainThat would be amazing. How do I create a temporary scratch table to hold the export result? Can you explain ?
------------------------------
Raj Helaiya
------------------------------