You’re offline. This is a read only version of the page.
Announcements
75
Hello!
I'm currently working on a scheduling app, but I've ran into an issue with all formulas not working the same.
About the backend:
I have 48 columns for each hour and half hour respectfully, all columns are a lookup to another table - The same table.
If the columns value isn't blank i want it to be colored in with the selected color when adding the job/task.
Example:
I have made a task that lasts the entire day, all the columns are filled with the same data to the same table and contains the exact same values.
For the field 00 i have this formula:
Share
ReportIf(ThisItem.'00_00'.OrderID <> Blank(),
Switch(ThisItem.'00_00'.KrasaGrafikam,
Choice_Color.Red,RGBA(227,75,75,1),
Choice_Color.Blue,RGBA(54,199,245,1),
Choice_Color.Green,RGBA(104,241,71,1),
Choice_Color.Orange,RGBA(241,170,58,1),
Choice_Color.Yellow,RGBA(251,253,104,1))
,Color.Transparent)
And for the field 03 i have this formula:
If(ThisItem.'03_00'.OrderID <> Blank(),
Switch(ThisItem.'03_00'.KrasaGrafikam,
Choice_Color.Red,RGBA(227,75,75,1),
Choice_Color.Blue,RGBA(54,199,245,1),
Choice_Color.Green,RGBA(104,241,71,1),
Choice_Color.Orange,RGBA(241,170,58,1),
Choice_Color.Yellow,RGBA(251,253,104,1))
,Color.Transparent)
But for some reason it thinks the value in the lookup field is blank, I know this because I tried to add another switch case with Blank(), Color.Purple and it turned purple, but i checked the value on the table and its not blank and contains the same data as columns 00.
Any ideas and help on why is this happening is greatly appreciated.
Not sure why that is happening, I would try to seperate everything out and do things in a one by one manner and see if that fixes your issue
All responses (
Answers (
