Ok so we have a company table with only one record for us.  We put our address and phone in it as well as our fiscal start date. 

 

I want to use script to allow certain privilege set of manager to change this value from wherever they are and I did this

 

company::fiscal_date has auto-enter "replace existing value" and all that is in the calculation is a single global field called

 

g_fiscal_date

 

Now it is my understanding that changing a global will change the real record it is in but only that record and that if the manager runs script to set this g_fiscal_date to a new date that the single record it is in will change the real fiscal_date.  It works in testing but I need to know if it would always work no matter where the button is placed including web direct, server or clicked by different users even maybe from iPhone. or if ran by scheduled script or even perform on server.

 

thank you for considering my request.

How often does your company change its fiscal year?

 

If this is just a hypothetical example of changing a value in a single record table form any other context,

 

It may be better to script a layout and set field the value change,

or

spawn an offscreen window go to layout to make the change on that layout

or

instantiate a relationship between current table and your "company preference" table so that the user could make the modficition.

or

use an SQL plugin to do an UPDATE into that preference table.

Thank you Ocean West.  This is mostly hypothetical.  I will try your ideas.

I usually do it this way:   IF (this privilege set) change company info, else custom dialogue: "Sorry, you don't have permission to do that."