Help-how to set email reminder?

[thomjw]

Hi, I don't know much about FM7. I need to add an item loaned out box in the home inventory template, that will email either or both me and the person I type in that has the item. Or even some type of alert that would pop up telling me that the item has been out for either 7 or 14 days. I am using the standard home inventory template for items. How do I add boxes for the person that borrows the item, and maybe a box that just says it's out? Also, how do I add a feature that will give me an alert or email at a set amount of days to tell me that an item is still out? Maybe a list that would tell me all the items out and who has them? Please remember I am new. Thanks

[Sanjai]

Keep a date field eg: DateBeingEmpty. Write a scipt such that whenever the item count becomes 0, it assigns current date to the DateBeingEmpty field. Create a calculation field (datetotext(currentdate)-datetotext(DateBeingEmpty)) to show the number of days since the quantity of a particular item is 0 and keep it on the first screen which is visible when you open your application. When a new item is added to inventory, make sure to keep the DateBeingEmpty field blank.