I have 2 databases, Planner and Plan Phase. I’m trying to click a button in Planner to auto-generate 1 new entry for each date in the date range of the next unplanned Plan Phase, and associate them with that Plan Phase.
In basic (and likely bad) Psuedocode, I imagine the steps being like so:
When you click the button,
Create a new Planner entity and
Look for the “smallest” [Plan Phase].[Date Range].Start() after the “biggest” Planner.[Target Publication Date] without any Planner entities and
Relate that [Plan Phase] to this Planner entity and
Update the [Target Publication Date] to the [Plan Phase].[Date Range].Start() then
For as many days as [Plan Phase].[Date Range], repeat 2, 4, and update that [Target Publication Date] to [Plan Phase].[Date Range].Start() +1
What am I missing that would make this really simple? I tried scripting but keep getting id errors. Tried using formulas but I keep getting “can’t do it that way”…
All the times are supposed to be in UTC - suppose I should’ve expected issues letting it detect my time zone for Today() and Now() but I don’t see why something like a formula extracting the date should change the date. It’s maddening.
If you want the simple explanation for why timezones don’t behave as you would like, it’s this: imagine two users in the same workspace, one in Singapore, and one on New York. What is the result of Today() and Now()?
These users expect different answers, but Fibery doesn’t allow (number/string) formulas to show different values depending on who’s looking. So Fibery chooses to show the same value for both users, based on UTC (which will be wrong for both of them, but wrong in different ways!)
Thanks again so much for the time zones tip - I was just about to look for that documentation.
Overall I’m building a content suggestion engine. Micro for this specific query – I’m trying to relate events (let’s call them Apples, Oranges, and Grapes) to time periods and relate each event in the same time periods. So there’s some events that have spans of time that are relevant (Apples), some some events that only have one day (Oranges), and some events that have a date-time (Grapes).
Whelp, all my data is screwed unless I can set my time zone somehow.
I’m in Denver. I imported a bunch of data in UTC expecting the server to keep the data exactly as I imported it (csv import). Instead, it treated the times as my local time, converted for me being in Denver THEN stored the values.
I saw “all values are stored in UTC” and “the server is not aware of user time zone” and thought it meant “no conversions occur”
Are you saying Fibery does not allow users to set their own time zones? Because I can’t find anywhere to set my time zone.
Or are you saying Fibery does not convert times? This one seems the least likely of the two, given that I have found a different output time value versus the time I know was imported via CSV.
Apart from that confusion… can you help me sort out how to put my data in so that I can get the dates to match? Like, it would be awesome if it could just ignore server time zones and just operate in UTC, like I do, because I’m a digital nomad living anywhere across 5 time zones and working anywhere across 10 time zones.
I see no way to set my time zone to anything so it looks like I’m going to have to delete the databases and start over somehow. But I don’t know how to import it so that the dates match when they’re supposed to.
Well there’s that for my own environment at least, but I was looking to build a tool that can be handed off (one of the main perks to Fibery for this project is the ease of creating another of the same instance via link).