Label Design Writer

SapphireOne Label Design Writer Overview

SapphireOne Label Design Writer is a versatile label design function that provides users with various ways to create and print custom labels as required. Users can access the SapphireOne Label Design Writer through all Inventory Report print dialog screens, or by highlighting an Inventory item within SapphireOne Inventory Inquiry screen and selecting the Print Icon from the SapphireOne Toolbar.

When the Print Icon is selected, SapphireOne will present the below print dialog screen.

Selecting ‘Labels’ from the Print Destination menu will open the Sapphire Label Design Writer, allowing the user to design and print custom labels as required. Users have the option to design and print labels on a sheet or roll.

Users have the ability to format their own custom label design using the Label Design Editor. To do so, users can first create a blank table form under their preferred table and include specified fields or variables from the tables as shown above. Users must be sure that the included fields and variable objects are within the paper margins, or else the print label method may not print the form as expected. Examples can be seen below.

Good example: Objects are within paper margins.

Bad example: Objects are outside paper margins.

How to Add Images to Labels

When printing labels, the user may desire to print a background image such as a company logo. The user may also use the SapphireOne Label Design Editor to print custom plastic cards, business cards or other kinds of cards. In this case the user may desire to print a background Image for this specific event.

Please note that copying and pasting an image into the label editor may:

  • Display a bigger picture. Pasting a picture will resize it based on the screen resolution, so the size of the picture is likely to be altered.
  • Properly display the label on-screen but the printed label may have a fuzzy picture.

The correct way to print a label with an image properly is to import this picture file into the Picture library and then create a form in which you drag the picture from the library. Finally, you just need to add the required fields.

SapphireOne’s implementation of both Dictation (MacOS) and Speech to Text (Windows) is a game changer for anybody doing data entry within SapphireOne. Any data entry field that the user can type into using a keyboard, they can use this feature.

They can also use this functionality on all inquiry screens within SapphireOne. For example, the user is in a Contact within a Client and they have just made a phone call to that particular client using the Softphone technology, this will automatically date and time stamp the contact and the phone number you called to. As soon as the call is completed or finished, the user has the ability to use the Speech to Text (Windows) function or Dictation (MacOS) function and dictate into the memo field of the CRM contact, adding as much description as they require.

This functionality applies across every single Data Entry screen. For example, if the user is entering a Vendor Invoice (VI) and they want to add a memo within the Vendor Invoice (VI), the user can simply dictate the memo. Another example is if the user wants to add additional lines to the General Ledger account, within each General Ledger account when the user is completing data entry using a General Ledger, there’s always a unique memo field for each General Ledger account line, the user can utilise this feature to quickly add the information they need to add. Additionally, if you’ve got an interview with an employee and after the interview process is completed the user is able to make notes about the employee.

Speech to Text or Dictation is an extremely powerful tool and it’s something that we at SapphireOne as well as our clients utilise daily. It is a massive timesaver. 

How to Save Label Fonts

When using the SapphireOne Label Design Writer to create and save a label, the fonts on the label are referenced by number rather than by name. As a result, labels loaded on another machine could have a different appearance due to inconsistencies of installed fonts between the two machines.

To solve this, the user can create a label and associate it with a form that uses a style sheet. Below is a screen shot showing how to associate the form:

If the user sets the font on the form object used with a style sheet it will carry over from one machine to another.

How to Add Strings into Concatenated Fields

SapphireOne Label Design Writer gives users the ability to add strings into concatenated fields. To do so, start by dragging and dropping fields into your label from the List of Fields:

Double click on the concatenated fields and add in a string (for example, a comma):

[Table_1]last_name+“,”+[Table_1]

Please note the label editor will add a space inbetween each concateneated field (each place you see a + sign):

The user can then add in other items on the label, such as images or other fields, as well as format the text. Using the ‘Preview’ button, the user can view the result.

A second method for creating a label is to use a table form (create layout of your label using fields and concatenations, images, etc). Select the form in the label wizard, and preview the results (here you’ll notice no added spaces around the “,” unless explicitly input):

In the example table form, a space is explicitly added on the concatenation of the last_name, comma, and first_name, and only one space is seen on the final label with preview.

Hiding All Forms in the 64-bit Label Editor

By default, the 64-bit Label Editor will show the table forms that are associated for each table, for example:

As a developer, one may not want to display all the table forms to the user. A way to control this is to use the “labels.json” file to select what to display manually. If the developer wants to immediately them all, the following utility method will hide all forms for all tables without modifying each table manually:

// ———————————————————————-
// Name: HIDE_ALL_FORMS_IN_LABEL_EDITOR
// Description: Method will hide all forms that will display in the Label
// Editor 64-bit.
// ———————————————————————-
C_LONGINT($i;$numOfTables)
C_OBJECT($obj)
C_TEXT($jsonText)
C_Time($vhDoc)
ARRAY OBJECT($masterObj;0)

$numOfTables:=Get last table number

For ($i;1;$numOfTables)
 OB SET($obj;”tableId”;$i;”forms”;”[]”;”methods”;”[]”)
 APPEND TO ARRAY($masterObj;$obj)
 CLEAR VARIABLE($obj)
End for 

$jsonText:=JSON Stringify array($masterObj)
$jsonText:=Replace string($jsonText;””[]””;”[]”)
$loc:=Get 4D folder(Current resources folder)+”labels.json”

If (Test path name($loc)=Is a document)
 text to document($loc;$jsonText)
Else 
 $vhDoc:=Create document($loc)
 If (OK=1)
  SEND PACKET($vhDoc;$jsonText)
  CLOSE DOCUMENT($vhDoc)
 End if 
End if 

Here is when all the tables forms are hidden:

Note: Deleting the “labels.json” file can revert back to displaying the default of all the table forms.


You can review our Blog and YouTube channel for additional information and resources on SapphireOne ERP, CRM and Business Accounting software.

Was this helpful?

Previous Article

Quick Reports

Next Article

Password (File Menu)