Telefon DE: +49-8282-800-400 Telefon AT: +43-7322-370-202 Telefon CH: +41-41-5210-100

You are importing an Excel Sheet and you have a column which can be answered with „yes/no“ for example:

For example:

Customer wants a special discount:
       yes / no

It can happen that one of your Staff-Members did not answer with yes or no, instead he responded with 10% or 20% or like this:

Customer wants a special discount:
about 10%

In this case if you want it to import to Act! we would suggest the follwing steps:


1. To make sure all Information is also imported in your Act! you must be sure which information the field has.
In this case we have 2 kinds of information. The first one is, the customer wants a discount. The second one is, The customer wants about 10% discount.

2. With these 2 information we have to create 2 different Act! Fields where we want our information displayed.

3. In our Example we need a Yes/No field checkbox for Act!.
    The checkbox is defined as „Yes/No“ in the field definition.
    The checkbox is called Yes/No tool in the layout designer

4. We also need a multiple choice dropdown menue for the further information
    The dropdown list can be managed by Tools => Define Fields => List Tasks => Manage drop-down lists
    Proceed, create a dropdown list and set up your Dropdown list and proceed with the dropdown values.
    After that you have to map the dropdown list to a new field you create.


5. After this work is done, continue with our import.

5.1 Create a translation in virtual column. for example name it „_is10percent“ then go on and map your source field. in our case „customer wants a special discount:“
then say field contains „10%“ Result = „10%“ proceed with translation until you got all needed values. like 10%, 20%, 50% etc…
you will end up with x schemas all created the same way:

_is10percent Source Field „customer wants a special discount:“ „contains“ „10%“ Result „10%“
_is20percent Source Field „customer wants a special discount:“ „contains“ „20%“ Result „20%“
_is30percent Source Field „customer wants a special discount:“ „contains“ „30%“ Result „30%“
_is40percent Source Field „customer wants a special discount:“ „contains“ „40%“ Result „40%“
and so on. these schemas make sure you only get useable values for your dropdown list.

6. Create another Translation (we will name it is_yesorno) and map the created schemes to it:
_is10percent contains 10% then Result is „Yes“
_is10percent contains 20% then Result is „Yes“
_is10percent contains 30% then Result is „Yes“
this will be needed to get a valid field for your checkbox.

7. Create a „Merge field“ and map your schemes. we will name it „is_merged
Here we will add all merge fields we need and separate them with the field seperator we want, e.g. ;


We will end up with 3 kinds of schemes:

Translation1: „_isXpercent“
Translation2: „is_yesorno“
Merge: „is_merged“


In the easy mappings we only need to map
Translation2: „is_yesorno“
Merge: „is_merged“

to the fields you created in act!