I ended up going a different route with implementing this and followed the approach that was explained by @Victor and @duartefalmeida in this thread:
Specifically, I did NOT use a third-party API platform like Zapier or Integromat, but instead used Adalo’s own API to effectively make an API call to its own database.
The reason I chose this approach is because:
- It avoids the technical complexity and additional risk of relying on an outside platform
- It would save money (if you aren’t already using one of those outside platforms)
Here’s a summary of the steps I took:
- Created a new Property in the User collection called “Adalo copy element ID”
- Created a new External Collection (as described in the above thread) that uses your own app’s User collection’s API (note the debugging step Victor explained that you need to set the Results Key to “records”)
- On the interim screen I use when creating a new user, I update the User collection “Adalo copy element ID” to be the External Collection Users > id > Maximum ids, Filtered by Email is equal to Logged in User Email (you need to ensure the User Email is verified and unique)
- Then I use “Adalo copy element ID” in any APIs going forward
Note: I have not verified this scales to support a larger number of users.
This is of course a workaround and I’m hoping the process ends up being moot once it’s easier to get the Element ID directly.