I’m wrapping Teacher header in a _Delay() so that this formula renders even if the result of Teacher header is still calculating; otherwise this formula will stay blank instead of showing the Loading message, and will jump right to showing the teacher header. Looks like _Delay() can unblock this calculation and not make it wait on the result of wrapped expression.
(before anyone asks how I figured it out — I know a bit of JS and how its event loop works, and figured Delay could be loosely based on that)
Pets Meal Maker is the Demo account made for that sandbox, with sample recipe and pets
As you can see there are no particular tricks, just the fact that my app is so huge that it loads before that text, and then the custom-current-user formula
When user is calculated “magically” the app is fully loaded, in my case it needs about 1 and half minute on desktop and 3+ minutes on mobile
Thanks @maria for the kind words
Probably i should open another post or use the one of publishing, but is there any plan to let users “save” their change to the published docs?
I mean, just for the already in users, the ones that i’ve added manually
Because the published version of docs is less-prone to wrong edits by users (limited interactions by default, with no hidden sections, ecc), and in some ways lighter to load, and the top nav bar is way cooler
This will really help publishing polished app to users that are not too much practical with coda or doesnt want to dig deeper in the doc
Interesting. Well, I’m doing the same above, checking for current user.
However my problem is that the “Post loading content” formula is itself what takes ~30 seconds to calculate (because it’s based on many underlying user-specific calculations in the doc, like applying user-specific timezone to all times etc). So until that’s done, this formula is itself in the empty  state and never shows the loading message.
But yeah, the _Delay([post loading content that takes a while to load]) seems to do the trick. It lets this formula evaluate immediately and show pre-loading content, but still switch to the post-loading content when loading has completed.
What do you mean by “license is verified”? Are you cross-doccing the list of users who “purchased” the app? You know the doc is still not protected from copying and removing all the checks, right?
P.S. Re honor thanks, but if it wasn’t for the community and these little tricks I found here when I was only starting with Coda, who knows, maybe I wouldn’t be digging into it and discovering any tricks of my own I still remember how I found the “use rectangles as makeshift progress bars” trick and that spiked my curiosity about what else makeshift we could do with Coda. So — great job and keep them going! Every post like this may make a difference in someone’s life
Thanks @Paul_Danyliuk, your presence in this community is really inspiring
i’ve thought about the fact that those are both 2 formula and they should load at the same time, but then i remembered how i designed that piece, and was based on the observation that in a formula made like
“Your name is:” “user.name”
The first part (the static text) was loaded as a “base” nearly after opening the doc, along with tables, and then, after a while, along with the filtered table (that seems to load completely and then filtered) load the second part, about the user.
So i wrote as static text the loading part and with a dynamic content the second part, and it worked logically.
Then i added the random phrases, that are from a cross doc synced table, and here the game should stop, but it work anyway (Probably formulas don’t know that, dont tell them! )
Yes that’s what i’m planning to do, but at the moment i’m in a beta stage so nothing commercial yet!
My integrations work like that, in the cross doc (the “cloud license manager”) i have a table with 3 columns, user email, name and app type (like if you are a breeder, a vet, a nutritionist etc)
This is synced in the main app (and it does not appear to de editable by users) and then a formula check if current.user is inside this synced table.
Then i should blow the doc up if user is not in, with hidden formula, thanks BTW
And in reality nothing happens, just “you’re a cheater” message…
Seriously, coda should protect content creator harder
Thanks also to @Federico_Stefanato, i will keep posting cool ideas and implementation, it’s funnier together
Where hidden formulas are listed (thanks also to @Paul_Danyliuk) i don’t remember now where i read that those could be used to turn the doc in a unusable app, for example after a verify from a license checker, but they could technically be used, apart from the fact that they could stop working like expected in anytime and break docs.
This is not a viable method because of the unstability of those formulas
Coda should work on protect user doc letting other users use those.
Like i was saying, a published doc with a save button (with copy blocked and play mode) would allow us to share our work with just listed people, that are not allowed to edit the doc, but that can use certain fields or control to interact with it!
But you already have figured out this!
I’m preparing a new post with my proposal of payment management in coda, to integrate also license management, to help shape this feature for future
Then, once i know that user is not one of the paying one coda should give us the tools to block that doc
I also have 2 other suggestions, i should be able to view, under the publishing statistics, WHAT are the (in my case) 6 copies of my doc, where they are, who own them ecc, and also i want to know if my ip is counted on the views of the doc (Probably yes because i’ve got 160 in 3 days ahahaahaha )
Nice to see others dealing with public app on coda
Hi @Jean_Pierre_Traets thanks for those links!
I had already seen the Crowdcast, let me tell you that your question made me jump as I was watching it
I’m really interest in your opinion about in my idea for the integration of user subscription model into coda billings!
I’ve made some other post regarding apps in coda, and many other have been made by other community users, i’ll try to keep this post updated with those to create a sort of list of feature useful in using coda as an app maker.
I’ll try to keep those up to date with the post in the community, if you think a post should be here please tell me!
Let’s create apps on coda!
How to manage users and groups of user to share data between them, creating apps for communities
@Johg_Ananda i’ve reviewed with more care your linked post,
i’ve resolved your issue creating a dummy/demo user that is loaded in every filter/formula in place of the usual “User()”.
This resolve the problem in the sense that is this custom formula “currentuser” that tells you if the user is valid or not.
If user is valid the return will be “RealUser”, if not gives back the dummy user.
If an user is “validated” it load the tables according to his/her/whatever email, if not validated the demo account is used.
This will always show only a portion of the data
It’s too late for that?