FM

Reply
Active Member
Posts: 10
Registered: ‎06-12-2008
Message 1 of 6 (745 Views)

Alias Title for Occupant

745 Views, 5 Replies
06-12-2008 12:51 PM
It was suggested to me to alias the Title for the Occupant to ID and to use a UDF for title, but when I go to the field available to alias (System Settings/Field Alias), Title is not one of them.

How do I go about this?

Thanks.
Active Member
Posts: 10
Registered: ‎07-03-2007
Message 2 of 6 (745 Views)

Re: Alias Title for Occupant

06-27-2008 02:35 PM in reply to: samcoburn
The Alias list is limited to the most common field names to change, that field name can be change but would need to be changed in the backend supporting table for the a Alias.

That same table handles over 900 of the field names in FMDesktop and making changes to the wrong field in that table would affect all the workstations. Making changes to the backend DB you always run the risk of corrupting the data.

A back up copy should be made before any changes are made.

If you are comfortable working in the backend of database the table which list all the Alias is easy to locate, and the Field_Name is called Title for All Form_Name and All Table_Name , as some Alias Fileld are only for certain forms or tables. Make the change the Alias field for the correct record, restart FMDesktop and you should see the change.

If you are not comfortable with working in the backend of the database you may want to contact your reseller or a consult who works with FMDesktop.

smk

Autodesk Consulting
AEC Division
Stephen M Komisarek
Technical Consultant
Active Member
Posts: 10
Registered: ‎06-12-2008
Message 3 of 6 (745 Views)

Re: Alias Title for Occupant

06-27-2008 02:57 PM in reply to: samcoburn
I am familiar with working with backends, so I changed the Title to ID (VAR Index 299) and restarted FMD. However when I open it backup and display the Occupant form, the label Title still has the caption as Title.

I tried Changing the caption from title to ID and it still shows as Title.

Where's this coming from?

Thanks.
Active Member
Posts: 10
Registered: ‎07-03-2007
Message 4 of 6 (745 Views)

Re: Alias Title for Occupant

07-07-2008 10:09 AM in reply to: samcoburn
As I stated in my earlier reply some form_name are for specific forms / tables. Var 299 is for Staff / Vendors so the change you made would show there. If you look at Var Index 324, that will be for the Occupant Title and should be the change you are looking for.

smk
Stephen Komisarek
Autodesk Consulting
Active Member
Posts: 10
Registered: ‎06-12-2008
Message 5 of 6 (745 Views)

Re: Alias Title for Occupant

07-07-2008 10:20 AM in reply to: samcoburn
Excellent! Thanks.

Is there some way I could have figured this out? Which var index I needed?

Thanks.
Active Member
Posts: 10
Registered: ‎06-12-2008
Message 6 of 6 (745 Views)

Re: Alias Title for Occupant

07-07-2008 10:30 AM in reply to: samcoburn
Never mind. I see the tblOccupant for var 324. So when it says All Forms and All Table_Name it means UNLESS there's an overiding entry.

Thanks for your help. I appreciate it.

You are not logged in.

Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register

Announcements
Welcome to the new Autodesk Community!
If this is your first visit, click here to get started and make the most of the Community. Let us know what you think of the new experience in the Community Feedback Forum.

Need installation help?

Start with some of our most frequented solutions to get help installing your software.

Ask the Community