In the field I want to have in the report is different name of companies but only two letters and I don't want the first two in the name.
Its in the column: Kliche. I want the different two letters from which company that job is from.
To get this report I made a script. Don't think this can be done in the same script. Think it must be something else with the field or something.
Still not clear. Is the Namn column for Company Name or for the product name?
If it is are you trying to get :
Royco Classic -> RC
Royco Classic -> RO
Try to post Swedish (or Norwegian?) description next to English. There might be someone able to post on your language.
don't you see the column far right. Its Kliche.
In kliche column is the company name.
Trying to get:
Flexokliche = FK
Flexopartner = FP
Repeat = RE
and so on.
You can't have a list showing values that you might want, only values that exist. (Unless you build yourself a list going from AA to ZZ, that is).
Is it possible to make a field that show only this FK, FP and so on, that is extracting or calculating or scripting from another field? Then I can show the short field instead of the hole company name field in my report.
of course it is - just create a new text field in the company table, call it Abbreviation and fill it as you want for each company.
In every post I have the company name in it. But not the abbreviation. Then I have this script that make my report. How can I get the abbreviation in the report? I know I can put in it in the layout but the connection between the two field I don't know. The script is finding the different post and then sort them. The abbreviation field is not in the post at all.
Recommended approach: Instead of coping over the Company Name, copy Company ID (primary key), create relationship between Order Item and Company. You will be able to display any field from a related company.
Quick fix: Instead of Company Name copy Abbreviation for the Company Name.
You can upload a sample file here to explain that is your problem, we should be able to modify this file and post it back to demonstrate the solution
how do you make a sample file? My solution is full whit data. Don't want to show the hole thing I have here.
you can CLONE a file and all data will be removed.
Beverly is right, we do not need 2GB download.
Another option is to start a new file to recreate the problem, create some simple structure - a few tables and relationships, main layout and report layout and put in a simple script. Does not have to be pretty (in fact mine tend to be quite ugly, unless siplus modifies them).