Re: Change default value of Text - Multiple Choice field on newly added record based on logged in user

Thanks Mark.  I have that working per your suggestion and it works perfectly. 

Now the problem.  We have between 80 and 100 users at any given time depending on work load. Problem 1) management would like not to have to purchase and manage all those paid users in QB (it has been brought to my attention that a kiosk mode scenario is not an allowed use of QB per the TOS so we'll just develop this piece using another tool) and 2) we don't want a line at the app while each user first logs in and then does their task and potentially forgets to log out.  Some quick background.  I'm using QB to replace an aging time tracking system.  The idea is to put a tablet in each shop for the employees to use as a time clock.  An entry on the time clock screen is the "Shop" they are working in (the Text - Multiple Choice field I reference above).  We want this field to default to the location the time clock tablet is in but allow an employee to change that as needed for a time punch entry.  This field once entered filters all remaining fields on the form to reduce errors as employees log time punches on work orders (for instance, which employees work in this shop, which work orders are assigned to this shop)

So my challenge is how to default the correct value in that field based on the tablets location.  My thought is to use a cookie dropped on the computer to indicate the shop for the default in the Text - Multiple Choice.  I've read using JavaScript in a formula field has been deprecated.  So, I've played around with codepages and have actually created one for each shop location that I can run as an admin to drop the cookie on the tablet for it's designated shop location.  But I'm struggling to understand how I use code pages to read that cookie in and use it to drive the default logic for the Text - Multiple Choice field on the Time Clock form.

Thanks for all the help you provide to these QB forums.  I've learned a ton just perusing your answers to all or our questions.  While I've been a software developer for 40 years I'm brand new to QB and your efforts have been invaluable!  



------------------------------
Stephen Study
Software Development Manager
Robishaw Engineering Inc
Houston TX
------------------------------