AnsweredAssumed Answered

Script to perform find in one field then automatically insert date in another field

Question asked by VictorVoegtli on Oct 19, 2010
Latest reply on Oct 21, 2010 by philmodjunk

Title

Script to perform find in one field then automatically insert date in another field

Post

I have an inventory database where when I check things in I want to perform a search on the item's barcode (using a barcode reader). If the item is found I'd like it to automatically place today's date in the Returned Date field. After the date is added I want the form to reset in order to take the next item. If the item is not found I want an error message that reads something like "Item not found".

Their are really only two fields: Barcode and Returned Date

I am a novice at scripting but have written a couple very simple ones. So I am confused about how the easiest way to accomplish this. Any advice would be appreciated.

Outcomes