i am learning/evaluating Panorama X as a replacement for a complex relational database application in Filemaker.
Is there, in Panorama X, an equivalent of an “onAddEvent” that is triggered when a new record is added to the dataset and can execute a procedure that is attached to that event. (In other languages there are numerous onEvent handlers such as onFieldEnter, onFieldExit, onMouseDown, onMouseUp and so forth).
My need is to populate the primary key (with the GUID that I was shown last week) and enter a fully functional timestamp (YYYY-MM-DD HH:MM:SS) in both a createdTimeStamp field and modifiedTimeStamp field. The modified TimeStamp field is subsequently updated with an onRecordChangeEvent.
The code in the Automatic Field Code (I have tried Formula and/or Code) and neither seems to be triggered until something is entered into the field.
Just clicking the “Add” button on the Tool bar apparently does not trigger or run this code.
However, when I write a procedure that starts with addrecord and then populates these fields with the GUID function and timestamp, a new record is added with fields populated as expected. For testing purposes, I have this function connected to a pushbutton on a form.
So how/where can I call this procedure to add a new record when, for example, a whole new set of .csv records are imported and each record needs these primary keys and timestamps immediately applied?
It would be very helpful to have a tutorial or data exchange example of a simple relational database example that has full CRUD capability for both the parent records and the child records. Or perhaps this is true database capability that Panorama X is not an ideal solution for and I should be sticking with FileMaker and/or MS Access.
Thank you for any advice.