Forum Discussion
_anomDiebolt_
8 years agoQrew Elite
This is very simple to do with script. You basically form a URL for your query and specify you want CSV output instead of NORMAL output. The URL will look like this:
https://SUMDOMAIN.quickbase.com/db/DBID?a=q&qt=tab&dvqid=1&opts=csv.nos.
In script you substitute semicolons for commas and you will then have a blob of CSV that will potentially contain up to 20*23 comma separated fields. But the fields are not going to line up all that well as among your 23 list user fields I would imagine there will be some that are not at the maximum of 20 users. So there are going to be empty cells in between full cells in your CSV and it will differ line by line.
This is simple enough to reformat but I have no idea what format you want or what you are going to do to these users in Excel.
Also, you are going to get a text representation of users in what may look like an unusual format such as these:
da.ndiebolt@gmail.com <60149618.bamg>
Dan Diebolt <57557593.cntq>
https://SUMDOMAIN.quickbase.com/db/DBID?a=q&qt=tab&dvqid=1&opts=csv.nos.
In script you substitute semicolons for commas and you will then have a blob of CSV that will potentially contain up to 20*23 comma separated fields. But the fields are not going to line up all that well as among your 23 list user fields I would imagine there will be some that are not at the maximum of 20 users. So there are going to be empty cells in between full cells in your CSV and it will differ line by line.
This is simple enough to reformat but I have no idea what format you want or what you are going to do to these users in Excel.
Also, you are going to get a text representation of users in what may look like an unusual format such as these:
da.ndiebolt@gmail.com <60149618.bamg>
Dan Diebolt <57557593.cntq>
- ArchiveUser8 years agoQrew CaptainThat will work. I can set up Excel to strip out the blank cells and format how I need.
Our client will not have access to QB and wants reports in Excel for now. Maybe that will change in the future, above my pay grade.
Cheers!