Hi there. I am looking to deconstruct a snowflake value, the users id, from an external platform so that I can return the user’s creation date on this platform. I have their User ID and need to effectively:
- Convert this to binary
- Extract the first 42 bits
- Convert this to a decimal
- Run some maths and add a certain amount to convert this into a UNIX timestamp
- Finally save this into bubble.
Here is the breakdown by Discord, the external platform.
I am kinda stuck on this one, I think that doing this via Toolbox is the easiest way but I am a bit of a noob with JS and if there is a Bubble way then I’d like to pursue that first.
Thanks