Recent content by marthag

Here are a couple of tips and something to try: 1. To help you diagnose errors, run the code with the debugger turned on - it is very helpful in diagnosing (it would tell you which line your problem is on and you could look at the variable values as you step through the code). 2. Front and...

@Subset( fieldname; -1 ) will return the last value in a list. Or, if the most recent value were at the beginning of the list, you would use @Subset( fieldname; 1 )

This link will take you to the Agent FAQ on Notes.net, which is the best source of information available about agents. It was put together by the agent expert at Iris. You should be able to find some information that will help you...

You can create a scheduled agent to send you an email. If it is a mail-in database, set the agent to run "If new mail has arrived". Otherwise, set it to run "If Documents Have Been Created or Modified". To receive notifications for newly submitted documents only, you can...

Make sure you have the "NoCache" flag in your @DbColumn formula - if not, the DbColumn data is looked up only once and is cached in memory until you exit the database - this sounds like what is happening. You need: @DbColumn( "" : "NoCache"; server : database...

You have two options: 1. If you have fields in your form with the appropriate names for mailing (SendTo, Subject, Body, etc.) just put the recipient's name in the SendTo field and use @MailSend without parameters. 2. Use @MailSend with parameters and put the field name that contains the...