ARInside does provide that information for each field...but the reason you don't see it 'readily' available is the fact that the Field Label can be different per view...so while the DB name is consistent if a form has 10 views it can be named 10 different things depending on which view you look at...so it is in the DB...but it's a bit hidden...:)
_____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Bob Rowe Sent: Friday, June 29, 2007 7:24 AM To: arslist@ARSLIST.ORG Subject: Field names in a list ** As we all know each field in a form has at least three names, one the user sees (user-facing), the name we see in the admin tool and the name stored in the database. I have a manager who wants a csv file listing all the fields on a form showing the user-facing name alongside the admin-tool name. The reason is that users see the admin-tool name (or the database name) while putting together reports. We have for instance, relabeled field 'Tag Number' so that users see 'PIMS Number', but it remains 'Tag Number' in the admin tool and Tag_Number in the database. The admin-tool and database names are easy to come by, but how can I extract the user-facing names? Will arinside do it? I can't install anything needing admin rights without a song-and-dance routine with computer security--that takes weeks. If arinside or some other tool will do the trick, I can possibly speed up that process. I've been through the database this morning looking in a MS SQL installation on my laptop, and I do not see a table under ARSystem that holds the info I need. For instance, Field has the name and a lot of other info, but column fieldName is the admin-tool name. Any help would be appreciated. Is the answer obvious? Am I missing something, as usual? Thanks. -- Bob Rowe, Remedy Action Request System Development and Administration [EMAIL PROTECTED] "The golden rule is to test everything in the light of reason and experience, no matter from where it comes." Mohandas K. Gandhi __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
