A long term bug is fixed now. It was about Google Calendar as a data source.
The problem was: We could select the [Row ID] in a LINKTOFORM() action but not in a “Add a new row to another table using values from this row” action.
The cool thing is: We can easily create Ref_Rows with that.
- So if you have a customer and create a Google Calendar entrie from it, you can tell AppSheet to use this [Row ID]:
[Customer's Key Column]&UNIQUEID() - Then in the Google Calendar you create a Virtual Column [Customer] with this expression:
LEFT([Row ID],8)and the Type “Ref” to your table “Customers” - With that you will have a system generated navigation action in the Google Calendar’s Detail View that brings you to the Customer.
- And you will have Ref_Rows in your Customers Table with all the Google Calendar entries for that Customer.
But we need to be careful with the [Row ID]. In the expression assistant we get this info:
New value for Google Calendar Event ID: Must be unique per row and contain only lowercase a-v and 0-9 (5-1024 characters). (Text)
This is a must for Google Calendar IDs.
So I think we can use UNIQUEID() ? I’ve never seen that it would create letters like w, x, y, z or uppercase.
Or maybe better: SUBSTITUTE(UNIQUEID(“UUID”), “-”, “”) ?
Does anyone have accurate knowledge about that?
Maybe @Steve ?
@lizlynch If you are still here, this could be added to the Release Notes.