• Industries
  • Products
  • Buy
  • Services & Support
  • Communities
  • Discussion Groups

    Autodesk FM

    Reply
    Active Member
    Posts: 10
    Registered: ‎06-12-2008

    Alias Title for Occupant

    708 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.
    Please use plain text.
    Active Member
    Posts: 10
    Registered: ‎07-03-2007

    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
    Please use plain text.
    Active Member
    Posts: 10
    Registered: ‎06-12-2008

    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.
    Please use plain text.
    Active Member
    Posts: 10
    Registered: ‎07-03-2007

    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
    Please use plain text.
    Active Member
    Posts: 10
    Registered: ‎06-12-2008

    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.
    Please use plain text.
    Active Member
    Posts: 10
    Registered: ‎06-12-2008

    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.
    Please use plain text.