Inserting User Specific Signatures (changed from Setting Fields with Single Button)

[scolesm]

Hello,

Is there a way I can assign multiple values to different fields with one button? I'm guessing with a script of some sort...

I've got a product sheet layout that needs to be revised every now and then.

I'd like to have just one button (I currently need three, but feel I shouldn't) that, when clicked increments the Revision Number by one, changes the Revision Date to the current date and prompts the user for a signature. I have separate buttons that perform the first two functions, but not the signature.

For the first button, I use a Set Field where Revision Number = Revision Number + 1

For the second button, I use Insert Current Date into Revision Date

For the third button, I currently just Insert Text "" into Revision Author (I know this is incorrect, but it still tabs it down to the field, so it does something).

Thanks a lot,

M

Edit:

Sorry for asking such a silly question and including the answer in the opening line. I've scripted the buttons properly now.

I'm still open for advice on how a user can insert their specific signature (we have handwritten signatures stored as images).

Thanks again.

Edited June 26, 2006 by Guest
Figured it out and have new question

[Brian C]

To insert signatures means you need to have a table that tracks your users where their signatures can be stored on the user record.

You can then query what user is logged in and perhaps populate a global field which will link to the user table via a relationship in order to see the signature on a layout...

This is just one of many many ways you could use to accomplish what you want. It really depends on how secure you want the signatures to be...

[scolesm]

Yeah, I'm still a little uncertain on the security needed here. Once I understand how it's set up, I'll work it out.

Thanks,

M

[scolesm]

Would it sound feasible to have a new table (User Sig) where each record holds the user name (text) and signature (image), then when the button is clicked, it assigns their username to a field, let's call it User Name, and the signature is inserted into a container based on a calculation relating User Name to their signature?

All records in that User Sig table would naturally be locked to anybody but me. mwahaha

I'm open to any alternate suggestions.

Thanks,

M