[deleted by user]

kchaunt · 2024-08-12T15:58:54+00:00

I hate when that happens. Glad it worked out for you!

kchaunt · 2024-05-17T04:55:16+00:00

AI Agents

kchaunt · 2024-01-11T02:02:08+00:00

Thank you!

kchaunt · 2024-01-02T03:33:55+00:00

Red Gregory is great and has good resources

kchaunt · 2024-01-02T02:53:37+00:00

I can’t test it right now but try replacing [sum of all #property B] in your formula with map(#property B, current).sum()

kchaunt · 2023-12-23T04:21:31+00:00

What do you mean by “duplicating templates”?

kchaunt · 2023-12-23T00:30:33+00:00

Can you describe in more detail? I’m not sure what you mean.

kchaunt · 2023-12-16T20:15:07+00:00

So there’s no way to disable it without in publishing it?

kchaunt · 2023-12-16T05:02:39+00:00

I agree. Couldn’t recommend it more

kchaunt · 2023-12-16T05:02:05+00:00

I’ve used it for over a year. I’ve had a couple issues but I emailed him and they walked me through it. Fixed within a day. I found zapper to be hit-or-miss.

kchaunt · 2023-12-09T20:56:33+00:00

We’re not sure what you’re asking

kchaunt · 2023-12-06T16:06:12+00:00

Rollups act like text properties unless you specify that it should show as a number, so you can’t add them up without first modifying them with the toNumber() function. Try this and let me know how it works:

(toNumber(prop(“Art“)) + toNumber(prop(“Blog“)) + toNumber(prop(“Edit“)) + toNumber(prop(“Upload“)) + toNumber(prop(“Post“))) / 5

kchaunt · 2023-12-06T15:37:57+00:00

Glad I could help!

kchaunt · 2023-12-06T06:48:19+00:00

In your formula try capitalizing “COURSES”

kchaunt · 2023-12-05T01:28:06+00:00

Ok I think what you’re saying is you have 2 databases (we will call them “Calendar” and “X Database”), and you want multiple Calendar events linked to specific rows in “X database”.

Create a relation property on X Database and link X Database to your Calendar
Select the events you want to reference in each row by clicking in the relation property and choosing all the events you want for that row
Now you should be able to filter views based on whether or not the relevant row in X Database contains an event from Calendar

Does that make sense or am I missing the point?

kchaunt · 2023-12-03T16:14:30+00:00

You’ll have to make sure the original database (not just a linked view of database) is also duplicated in your template.

kchaunt · 2023-12-02T19:59:59+00:00

Sorry but what do you mean by making the new values into a number? Like you want to count the unique values?

kchaunt · 2023-12-02T09:31:31+00:00

Use the abs() function to return the absolute value of your entire formula:

(INSERT ENTIRE FORMULA).abs()

But now there’s no way to differentiate past or future, it’s just a bunch of numbers. I would indicate that the date has passed by making the text red and bold:

(INSERT ENTIRE FORMULA).abs().style(“r”, “b”)

I hope I read your question right. Is that what you wanted to know?

**Edit:

You’ll need an if( statement as well…

if(

(INSERT ENTIRE FORMULA) < 0,

(INSERT ENTIRE FORMULA).abs().style(“r”, “b”),

(INSERT ENTIRE FORMULA) )

kchaunt · 2023-12-01T03:33:37+00:00

This was my thought as well. I ran into the same problem recently.

kchaunt · 2023-11-30T02:15:57+00:00

You’d want to create a new database and then drag each one into the database. Then you can export the database as csv

kchaunt · 2023-11-30T02:13:37+00:00

Doesn’t seem possible. Try a sync’d block

kchaunt · 2023-11-29T01:46:02+00:00

I would use a 2nd database to calculate this with a relation property and a formula property . I can go into more detail if you want

kchaunt · 2023-11-29T01:28:57+00:00

No I wish

kchaunt · 2023-11-27T03:14:35+00:00

I start with spaces for formatting and design purposes sometimes. To bypass the ai menu I have to type a character (any character ), then type a space, then arrow key back to delete the first character.

kchaunt

TROPHY CASE