Repeat Signage V4 help

Formatting - Replacement tab

Help home


This tab allows you to replace data with other text.  We will start with a few examples to see how this could be used.  Let's say you had a products database and you want to display the number of items left in stock for a particular item.  The field in the database could be called 'Stock level'.  You want to display a message such as 'Out of stock' or 'None left' if the stock level is 0.  You may also want to display 'Hurry, last few left' if the stock level is below five.  What you could do is to use the tab to tell Repeat Signage to do this.  You would have to select 'Number' from the 'Replacement type' list and then use the Add button to add the following lines to the grid:

Stock value Operator Replacement value
     
5 LESS THAN Hurry, last few left
1 EQUALS Last one left
0 EQUALS Out of stock

So what will happen is if the stock level is 10, it would just display '10'.  Stock of  5 would display '5' (the operator above is less than 5), and 4 or 3 or 2 would display 'Hurry, last few left'.  A stock level of 1 would display 'Last one left' and 0 is 'Out of stock'.

Numbers are also used in databases as status codes.  For example, one UK estate agent (realtor) website uses Property codes in it's data feed.  Each number is a different type of product such as:
Property code Property type
   
0 Not specified
1 Terraced house
2 End of terrace house
3 Semi-detacted house
4 Detached house
Etc.  

Since this information is not available within the data feed, we could use replacements to replace a value of 1 with 'Terraced house', etc.

Text information can also be replaced.  For example, in a museum an exhibit could allow visitors to enter comments into a database which are then displayed on a screen.  Text has the option of 'FIND AND REPLACE' (as wells EQUALS) so you could use this to remove any swear words by replacing bad words with nothing or replace some words with *****.


Replacement rules

With the exception of FIND AND REPLACE then the first replacement line in the gird that matches is used, so the order of the replacement lines is important.  For example, if you used the following:

Number value Operator Replacement value
     
100 LESS THAN Less than 100
1000 LESS THAN Less than 1000

and the number is 23 you would expect the replacement value to be 'Less than 100'.  However, if the items in the grid are the other way around:

Number value Operator Replacement value
     
1000 LESS THAN Less than 1000
100 LESS THAN Less than 100

then 23 would display 'Less than 1000' instead, so this would be the first rule that matched.


Using replacement for conditional formatting with numbers

You an also use the place holder <VALUE> in your replacement statements.  For example, you may want to colour numbers between certain values.  For example, you could apply different colours to numbers:

Number value Operator Replacement value
     
1000 LESS THAN <span style="color:red"><VALUE></span>
100 LESS THAN <span style="color:green"><VALUE></span>

which means that less than 100 you would get the colour green applied and between 100 to 999 you would get red applied.

IMPORTANT - You have to change the 'Display as' field to 'BASIC HTML' so that the colours are applied.


Using this system

Use the 'Replacement type' list to select the type of data such as TEXT, NUMBER, CURRENCY, etc.  Then use the add button to add an entry.  Use the help system on the displayed form for more information and your options.


Additional options such as prefixs and suffixes

There are applied after any replacements have been made.