Firestore query by reference / inserting and updating references.
Here's an example of how to specify that a string should be a "reference" type:
Inspired by the MongoDB Extended JSON syntax, you use $ref to specify that the string should be a ref. In any place where you might be a normal value you can now use the following to refer to a reference. { $ref: "collection/documentId" }
The moment-timezone library has been added to Retool. You can now use expressions like {{ moment.tz('2019-10-10 13:43', 'America/New_York').toISOString() }} to convert dates in different timezones