Automatically change data when importing

[LasseJ]

Hi all

I import data from an Excel-file into a field, "Status".

The data is all in codes, and I would like these codes to be "translated" into a litteral tekst immediately. ex. imported code "1232" is shown as "Member has re-registred" when imported.

It seems like a fairly easy script, but I cant make it work. Any help from you guys?

Regards

Lasse

[mr_vodka]

How will the translation be determined? Are there numerous amounts of these codes? If so, you might want to have a translation table. The field can be changed automatically when doing the import.

Link

[LasseJ]

Hi mr_vodka

I'm actually only talking about three different codes.

Looking forward to get any input..

Regards

Lasse

[mr_vodka]

If the codes will not change then you can consider hard coding it.

You dont have to use a script to do this. You can have the field be auto entered with calculated value

Case ( Status = 1232; "Member has re-registred";

Status = 2222; "Member has resigned";

Status = 3333; "Member Initial signup"

)

[LasseJ]

Thanks for helping. It works fine!

Regards

Lasse