Scheduled script to update field on cmn_location table daily. Need help with script

[galavodasal]

I can do this with a client script but I don't think that would work since we need the data updated on the forms daily for an export.

I figure I have to first query the cmn_location table and then add the setValue command but I'm not sure of syntax and how to query through all records.

	query (cmn_location) var DM = g_form.getReference('u_district_manager');
	g_form.setValue('u_dm_email', DM.email); current.update

Also, where can I schedule scripts? I swear there was a module in Fuji for scheduled scripts that would appear after elevating security privileges, but I do not see it in Helsinki.

Thanks!

[galavodasal]

I just had a thought   -- that business rule that I copied is for RITM's that are being inserted, not existing records.

So I bet that if I created a new District record, entered a District Manager and hit Save, the District Manager Email would appear... and sure enough:

EDIT: Nice catch, but it works with the "current.variables" in there -- not sure why.

[galavodasal · Accepted solution]

Got it, here's the scheduled script: