Hi,
I have been a user of Alpha 4 for about 10 years and have just started to learn Alpha 5. I am stuck trying to do my first "Action Script". I have a table called "Mainmed" with a character field called "Closdate". I would like to have an action script that would mark the current record if the "closdate" field is edited to contain a date. If it is blank, then the record would not be marked. Should be simple, but I'm going around in circles. In Alpha 4, I did this with an exit trigger in the field rules. It would appear that I should use "OnWroteField" in the events rules. I used a "Select" choice with these 2 choices:
isblank CLOSDATE
.not.isblank CLOSDATE
The first selection then had inline Xbasic to .UnMark_Record() and the second selection was to .Mark_Record().
When I try to enter data into a record for the CLOSDATE field, the error message tells me that CLOSDATE is not found or not available. If I try to build the "Select" choices using the Expression builder, I can only use the 3 fields from the system table (i.e. date, page number, page X of Y).
I would greatly appreciate any help.
I do not have any custom forms for this table yet, only the default form. Is that a part of the problem?
Any help would be greatly appreciated. It took me 6 months to build my original application in A4 (I'm not a programmer), but at this rate, it may take 6 years just to redo it in A5!
Robin
I have been a user of Alpha 4 for about 10 years and have just started to learn Alpha 5. I am stuck trying to do my first "Action Script". I have a table called "Mainmed" with a character field called "Closdate". I would like to have an action script that would mark the current record if the "closdate" field is edited to contain a date. If it is blank, then the record would not be marked. Should be simple, but I'm going around in circles. In Alpha 4, I did this with an exit trigger in the field rules. It would appear that I should use "OnWroteField" in the events rules. I used a "Select" choice with these 2 choices:
isblank CLOSDATE
.not.isblank CLOSDATE
The first selection then had inline Xbasic to .UnMark_Record() and the second selection was to .Mark_Record().
When I try to enter data into a record for the CLOSDATE field, the error message tells me that CLOSDATE is not found or not available. If I try to build the "Select" choices using the Expression builder, I can only use the 3 fields from the system table (i.e. date, page number, page X of Y).
I would greatly appreciate any help.
I do not have any custom forms for this table yet, only the default form. Is that a part of the problem?
Any help would be greatly appreciated. It took me 6 months to build my original application in A4 (I'm not a programmer), but at this rate, it may take 6 years just to redo it in A5!
Robin
Comment