HI Team,

I want to change a drop down field named Status from Implementation to Active once the Inception date field is today. Can you please hlep me with the script to use to update the Status field.

Thanks!
Bhawana Pandey

How can I get current record's (currentValues') id using script on after update or after insert event? I mean the real id in database, like the recordId in the event passed to an integration, instead of the Record ID.

Is there a way to get the currently operating user record in script?

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.

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!

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)?

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!