Skip to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Automatically change data when importing

LasseJ
in Importing & Exporting

Featured Replies

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

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

  • Author

Hi mr_vodka

I'm actually only talking about three different codes.

Looking forward to get any input..

Regards

Lasse

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"

)

  • Author

Thanks for helping. It works fine!

Regards

Lasse

Create an account or sign in to comment
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Account

Navigation

Search

Search

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.