It seems the before/after delete app scripts don't work the same way as the insert/update ones, but not 100% sure.

I'm trying to prevent the user from deleting a parent record that has any child records from a certain table attached to it.

The script should be pretty simple. On the parent table:

Before Delete

List childRecords = getChildren "TableName", "FieldName"
if(childRecords){
throw new RuntimeException
}

This hasn't worked whenever I've tried it. However I structure it, a Delete app script can't seem to find child records. I'm I misunderstanding something here?

Thanks!

It seems that sorting a List of records by a specific field requires the field value to be cast to the underlying data type? If you don't do that, it seems like the fields will sort by object identity or some other undesired key. Am I right about this?

For example, if I have a date field in a record, must I use
(Date)record["MyDateField"] to actually get a correctly sorting date.

The application script docs describe an update function to update a record, but it seems that changing a field using the Map interface already updates the record. What is the update function used for?

Transport service

I am trying to populate a Link-To-Parent fields via Apps Script and nothing happens.

If copied the format from Drop-down fields, Application User, and Application User Group fields (thinking they would all behave the same), but although the Scripts saves with no errors, and the records can be updated with no errors, the LTP field is not being populated.

If this is possible, can you provide a sample of the code that I can use?

I've been practicing with Apps Scripts and creating multiple child records.

From the documentation (see below), each child record will be created and numbered incrementally from 1 to the total number of records created (1 to 5).

QUESTION: How do you pad the sequence number as 01, 02, 03... instead of 1, 2, 3.

This is so column sorting is correct when more than 10 records exist.

Thanks

How do I create child records ?

// Create 5 child records
(1..5).each {
addChild “Child Table”, “Link to Parent”, [‘Status’ : ‘Active’, ‘Index’ : it ]
}

Is there a way to find records in a table via scripting that have a date column value greater than a value (as opposed to just equal to it as the method seems to work now)?

It would be good to have a list of fields used in application scripts. So that if a table is changed and field name updated it is easy to identify what App Scripts will need changing as well.

Best case scenario would be that the field renames flow into and change the app scripts like they do in calculated fields in tables.

I was already aware that app scripts are unable to handle image/document fields(bummer), but it appears they may not support other calculated field types as well... some clarification on the subject would be nice. I would think you might want this published on your developer site as well.
Thanks!