Skip to main content

Boxes - Miscellaneous

1. Comment

Comment is a box that is not used to edit data. It gives you the chance to make notes.

It can be very useful if you use and combine a lot of boxes and later want to know why or if other persons are using the account as well.

1d44576fa7b57a2be3ec9f7b1cb6aba7.jpeg

2. Set Property Value

This box uses the site or export tags to define a value. It is useful to change values in copied sites without having to change any boxes.

96bb8596134570c9ca64dbf07001e4e6.jpeg

3. Set To Site ID

This box is used to set the value to the Productsup site ID.

5b69a05251cb289ff35e83de560d181d.jpeg

4. Sort Values

The box Sort Values sorts the items in a cell alphabetically based on a delimiter.

a77ee67b932c3bd03295966965801e12.jpeg

5. Character count

It displays the number of characters in the cell.

dc8dfa2b292495edcf21719af04578a5.png

6. Word count

Simply displays the number of words in the cell.

7abfbd0576e5a4590e889ea084f49df7.png

Delimiter: Chose the delimiter that separates the values

Order: You can choose how the values will be sorted: ascending or descending

7. Trim Category Tree

This box cuts last categories by the delimiter ">" if length exeeds. Just fill in the maximum number of characters.

415b40d58e4ebacd1857ad4cc18fb08f.png

8. Extract Value from JSON

This box extracts values from JSON bodies.

Figure 1. ExtractJson
ExtractJson


Extract from field: Enter the name of the value you want to extract.

Example:

  • JSON Input: { "name":"John", "age":30, "cars": { "car1":"Ford", "car2":"BMW", "car3":"Fiat" } }

  • Extract from field: name

  • Result: John

9. Sort Values in Cell

This box let's you sort the values in a cell by providing the order in which they should be sorted.

Figure 2. sortValuesInCell
sortValuesInCell


Attention: When adding values to this box, the ascending or descending order from the dropdown does not work anymore. If there are values that are not adressed with the values added, they will be ordered by first appearance.

Example:XL,XXXL,L,M,SOutcome:S,XXXL,M,L,XL