Record creation date / modification date of an item

Ask for Help
18

You mean modified by Glide?
That’s always going to be a challenge, because:

  • Glide only ever triggers a Change event, and
  • A Change event does not support the range object

Which means that although you can tell which sheet the change occurred in (via event.source), there is no way to directly determine which range or cell was modified.

That doesn’t mean it isn’t possible, it just means you need to get a little creative with your solution/approach.

NB. The Google Apps Script reference doc suggests that event.source isn’t available with a change event. But in this case, the reference docs are wrong :wink:

1 Like