Devide ID/Pin

[jmostert]

Hi,

Is it possible to access the device ID/Pin via a textbox (or other control)? I'd like to be able to see which device uploaded each record.

Thank you and regards,

Johan

[YiLiu]

Hi Johan,

Yes, you can. Steps:

(1) Drop a text box into the form.
(2) at the onload actions of form, put the following script into.

mypin = client.pin

--client.alert(mypin)

myform = clientevent.form

mytextbox = myform.fields["textboxfieldID"]

--client.alert(mytextbox)

mytextbox.value = mypin

[jmostert]

Hi Yi,

Thank you for the prompt feedback. It works perfectly.

Just another questions: I have a transaction date that I want to set on the Form Load. What is the Lua function to set the date to today's date and time? I know in SQL it's getdate() and in VB its today(), but I've never used it in Lua.

Thank you and regards,

Johan

[YiLiu]

Hi Johan,

You might try some similar as the following:

local myFields = clientevent.form.fields
local curtime = os.time()

-- client.alert(curtime)

-- if you want to set value to a date field, you do not need to convert the curtim to string
mycurtimestring = os.date("%X" , curtime)  -- if you like different format, please refer www.lua.org/pil/22.1.html for detail
myFields["textboxField"].value = mycurtimestring

Kind Regards,

Yi

[jmostert]

Hi Yi,

Thank you again. It works perfectly; it's exactly what I was looking for.

Regards,

Johan