Forum Discussion
This isn't a Pipelines or QB item - that just Excel being Excel. Especially since you're downloading it as a CSV - Excel will never understand the formatting aspect given that CSV's by their nature don't have formatting - it's just the value.
You could try sending the value as a formula, I've seen some success with that. So when you pass it in - pass it in as a string that looks like ="{{part number}}" and see if that works to force Excel when it opens to render it as a number.
Really the only good option is to not actually open Excel by default - but to open a new worksheet and load data from a CSV so that Excel will understand when it reads the data that it needs to interpret it as text as opposed to trying to guess.
------------------------------
Chayce Duncan
------------------------------
Chayce,
Thanks, that didn't work either. I may try Google Sheets and then bring it back into QB.
------------------------------
v/r,
Chuck
------------------------------
- ChayceDuncan11 months agoQrew Captain
What is the end result you're looking for? Are you sending out an Excel file for someone to make edits to then pass back into Quickbase? Just curious what role Google would play in this scenario to see if there might be a third door to consider as well.
------------------------------
Chayce Duncan
------------------------------- CharlesDulaney11 months agoQrew Trainee
Chayce,
When we are done adding PNs to our BOM, we generate the BOM in Excel.cvs with headers the manufacturer wants to see. When we are ready, we click a button to generate the BOM, ECN and all drawings.
Recently, the manufacturer sent the BOM back to us claiming incorrect PN for a select few.
Google Sheets may not create this anomaly. As I mentioned earlier, some PNs are alphanumeric, and some are numeric. Meanwhile, numeric PNs are correct until they are added to an Excel sheet.
------------------------------
v/r,
Chuck
------------------------------- ChayceDuncan11 months agoQrew Captain
Interesting. So in the case that the PN's are wrong in the BOM they sent back - is the the numeric codes that were the sole issue. Google Sheets would probably work then - or I might suggest Box as well. You could just load the CSV file to a shared folder / directory for them to access. If they choose to download it and get it out of either system though the problem is likely going to be the same.
This is a more complex option - but you could consider making a codepage that pulls your BOM and makes an actual XLSX file as opposed to a CSV. This would ensure that you could control and enforce the formatting of the columns in question versus leaving it to the whims of Excel doing Excel things.
------------------------------
Chayce Duncan
------------------------------