Question : What are magic fields ?

[Jerome-Herbinet]

Hi @datenangebot,
I'm currently working on the French translations of the Tables app, and a while ago I came across the notion of a "magic field". To be honest, perhaps due to a lack of culture in this kind of data storage and sorting application, I haven't the slightest idea what the "magic" aspect of certain fields is. Unfortunately, what I saw on the front of the application didn't help. Can you explain to me what it's for, how it works, and what its purpose is... and that will help me understand what's "magic".
Thanks in advance!
Jérôme

[datenangebot]

Hi @Jerome-Herbinet ,
of course!

There will be some points where you can use (insert) magic-fields. For now it is used to filter columns, but there will be more one day. For example the "magic value" could be [me], that means the program will replace this with your individual userId. It is called magic because it depends on the context whose logged in. Another magic field is a date and time. This is also related to your personal timezone... So all fields that will be replaced with values that are different for different users/contexts are called "magic fields".

Does that help?

Kindly regards

[Jerome-Herbinet]

Hi @Jerome-Herbinet ,
of course!

There will be some points where you can use (insert) magic-fields. For now it is used to filter columns, but there will be more one day. For example the "magic value" could be [me], that means the program will replace this with your individual userId. It is called magic because it depends on the context whose logged in. Another magic field is a date and time. This is also related to your personal timezone... So all fields that will be replaced with values that are different for different users/contexts are called "magic fields".

Does that help?

Kindly regards

Thanks a lot @datenangebot 🙂

[stefan-niedermann]

Sorry for seizing this issue, but is there a documentation about which magic field(s) are available?

[datenangebot]

Well, from the users perspective you always get a list with available fields.
From a dev perspective, no not yet. Maybe we could take this issue to add that. 🙃

[datenangebot]

https://github.com/nextcloud/tables/wiki/Developing#magic-values