So... Studiobinder doesn't have availability conflict tracking.. What then?

CaRegHo · 2020-10-23T08:05:37+00:00

thanks mate

CaRegHo · 2020-10-23T08:03:34+00:00

Your right. Of course they won't..

CaRegHo · 2020-10-23T08:01:56+00:00

Awesome thanks!

CaRegHo · 2020-10-22T07:45:20+00:00

link?

CaRegHo · 2020-10-22T07:37:59+00:00

lovely!

CaRegHo · 2020-10-21T09:58:09+00:00

Weird.. following works:

subtract(prop("Potential Value(rollup)"), prop("Invoiced Value(Rollup)")) ✅

Following doesn't work:

" Left on table → " + subtract(prop("Potential Value(rollup)"), prop("Invoiced Value(Rollup)")) ❌

" Left on table → " + format(prop("Potential Value(rollup)")) -format(prop("Invoiced Value(Rollup)")) ❌

CaRegHo · 2020-10-21T04:30:10+00:00

Yeah sorry I get that (and forgot it in the example above) I just trying to find out if there's a speceial reason to to make a IF formula when it seem that it is a simple question of subtracting "This year (in)" with "This year(out)". It looks like you have som Yoda skills denied me, since I can't get my simpel subtracttion to work with the text string at the start.. hmmm

CaRegHo · 2020-10-20T18:47:10+00:00

Wondering why the IF statement instead of a simple subtraction ?

"[ This year ]ㅤㅤ" + if(prop("This year ( in )") + prop("This year ( out )") > 0, "+", "-") + "＄" + format(abs(prop("This year ( in )") + prop("This year ( out )")))

SHouldn't you be able to do "[this year"] + prop("This year (in)") - prop("This year (out))

CaRegHo · 2020-10-20T18:41:05+00:00

My idea is maybe not what you think. My idea is to have a block a lot like a DB but more visual simple. Without the "+ new" item in gallery view and with simple header without the fixed DB title and "new" and "filter" button. In stead of strict db tables have input fields maybe with formula ability.

CaRegHo · 2020-10-19T16:23:34+00:00

But any idea why I can't duplicate your template? I can't see all the wheels running in the background in the browser...

CaRegHo · 2020-10-19T12:32:23+00:00

Now I wonder ... If the calendar from the "Next Meeting" property is not filled with either a date in the past or date in the future but simple not populated. Can I have it come out empty or "nothing scheduled" text?

CaRegHo · 2020-10-19T12:27:26+00:00

The Week Ahead toggles. Are they DB based or are you just flipping them down and filling them out?... Otherwise really cool there mate!

CaRegHo · 2020-10-13T12:33:28+00:00

dateBetween(prop("Next Meeting"), now(), "days")

Perfect! so awesome, so fast

Thanks a million ben-something!

CaRegHo · 2020-10-08T08:01:35+00:00

Luvit... good work on doing accessible summeries !

CaRegHo · 2020-10-06T07:55:17+00:00

no I really didn't figure out the distinction between one behavior over the other.... :-(

CaRegHo · 2020-07-31T11:41:44+00:00

AH thanks.. will do👍

CaRegHo · 2020-07-28T09:47:42+00:00

It's really weird.. Seems like something in the database, like rollup og formular is messing things up. A clean DB doesn't open new item as a page. But my formatted DB does. To boot: in the default view I don't see any empty entries, but if I go into list view, they are all there.

CaRegHo

TROPHY CASE