Just a heads up (I might be wrong) but I find that I have to set every single value for the record every update from Adalo to Xano. If I leave “No change” it will be blank. Or am I missing something else?
Also you can change Xano from post to put for update.
Hi @Meibe,
XANO user here. the POST or PUT or PATCH in XANO will not change the blank situation, you will need to create a specific Endpoint in XANO for the fields that you only want to Update and hide the other fields, similar to this:
hI jl_LJ it looks like you are quite an expert in Xano… so maybe you may also help me with my other issue: I am not able to use the date+time picker in adalo to create a timestamp-record in xano. I have almost tried everything (including changing the format…). Can you help?
Hi @adyking ,
One thing to mention from beginning, XANO by default is UTC (1 hour less of CET). Xano stores timestamps as a Unix timestamp in milliseconds as UNIX EPOCH.
Unix epoch timestamps in XANO are in milliseconds and in UTC calculated from 01/01/1970.
When you have the date in Adalo you can convert to epoch
Try using this formula: your DATE (In your case Start date) x 86400 (Number of seconds in a day) x 1000 (to convert to Epoch Milliseconds).
Similar to this:
And then just send to XANO.
If you want to test results, use one column with just date in xano and the other with date in CET, to check the 1 hour difference.
It’s me again, sorry for bothering you again…
So I followed your advice and everything worked fine (see Screenshot) → I calculated the time by implementing a formula in my first app.
However, now a couple of weeks later I wanted to implement the same in another app and it is impossible to create a formula (also a workaround with customized formula) is not possible. See Screenshot two. That is very strange as I am doing exactly the same as last time. Does someone has experienced the same. (You see that is not possible to create a forumla as “x” is not green).
To get them the property needs to be a number property. Did you checked that? Maybe this is a text property. If it’s text you should see a section called custom formula to add formulas!
As @dilon_perera already mentioned and on spot, you are using text property, there are no calculations the way you set it up, if you look into the “x” it is black colored, not green colored, this indicates that is it not a formula, also the magic text is a “T” and not an “X”
Formula
Not Formula
So you need to use Custom Formula as @dilon_perera suggests.