Has anyone ever created a bardcode within a formul...
# general
j
Has anyone ever created a bardcode within a formula of a Saved Search? tried various HTML tags, but does not seem to work.
Only way I have been able to do it is created an Advanced PDF template for the saved search and print the saved search.
m
EDIT: Please ignore this, Eric B has a solution below. ORIGINALLY: Unlikely to work in a Saved Search. The barcode part of the Advanced Templates isn't typical HTML. It's part of an extension called BFO PDF Syntax. You'd need to code up your own HTML tags somehow to make it work in a saved search (would be pretty hard)
e
Yes it's possible to display a barcode in a saved search
Here are the steps to use ANY downloadable font in NetSuite saved searches. This is NOT LIMITED to barcode fonts. It can be any font. For this I choose to use Google Fonts because they're free and they have tons of them.
What's needed: 1.
Downloadable font uploaded to NetSuite file cabinet.
2.
Formula (Text) in saved search column.
Steps to use Google Fonts
1.
Navigate to <https://fonts.google.com>
2.
Pick a font and configure size etc by clicking the + sign.
3.
After picking a font you will see at the bottom right of your browser the font family you picked. Click the -
4.
Download the font by clicking the down arrow.
5.
Upload the font to NetSuite File Cabinet in the
_*Fonts folder*_.
6. Once it's uploaded, click
_*Edit*_.
7. Check the
_*Available Without Login*_ checkbox.
8. Copy the
*URL field* (not the URL on the browser!) that's on the left side of the form under Description.
9. Open your saved search and add a
_*Formula (Text)*_ column.
10. Copy and paste this formula changing the font-family and URL and reference the
*File Name of the font you uploaded* (minus the .ttf)
'<style> @font-face { font-family: *LibreBarcode39Text-Regular*; src: url(*<https://debugger.netsuite.com/core/media/media.nl?id=16264840&c=xxxxxx_SB1&h=59a3697da9e9e4587c01&_xt=.ttf>*)}</style><div style="font-family:*LibreBarcode39Text-Regular*;font-size:30pt;">*'||UPPER({upccode})||'*</div>'
👍 2
proof of concept...
e
This is pretty neat @Eric B
👍 2
e
The key is finding a font that will display a scannable barcode!
m
That is pretty neat! I'll edit my response so people ignore my response.
👍 1
m
Another way is using a service that generates barcode images, example https://github.com/metafloor/bwip-js/wiki/Online-Barcode-API