FM

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

Alias Title for Occupant

780 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
skomisarek
Posts: 10
Registered: ‎07-03-2007
Message 2 of 6 (780 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
samcoburn
Posts: 10
Registered: ‎06-12-2008
Message 3 of 6 (780 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
skomisarek
Posts: 10
Registered: ‎07-03-2007
Message 4 of 6 (780 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
samcoburn
Posts: 10
Registered: ‎06-12-2008
Message 5 of 6 (780 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
samcoburn
Posts: 10
Registered: ‎06-12-2008
Message 6 of 6 (780 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.
Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.
Need installation help?

Start with some of our most frequented solutions or visit the Installation and Licensing Forum to get help installing your software.