Iโve made an app to demonstrate the issue Iโll describe here. Itโs called โFormat testโ and can be found here.
https://www.appsheet.com/portfolio/230844
What I want to do is make the Japanese column big in the detail view but not in the deck view. So, I used the following condition:
It works at first:
But when I navigate from the table to the detail view, it no longer works:
By the way, I was also unable, in a different app, to get it to distinguish on the basis of the view name. In either case, the app seems to โrememberโ the format that it applies to the table view and does not adjust when the user navigates to the detail view.
Thanks in advance. I hope this can be fixed easily.
Solved! Go to Solution.
Recently, I have been avoiding โcontextโ expressions with format rules. Instead, I make virtual columns that I only use in contexts where I want the rule to be applied and then make a format rule just for that virtual column. That seems to work well.
Even though Iโve been using AppSheet for a while and should know how to share a prototype on my โfreeโ account, I still wind up getting messages like this. Iโm requiring sign in, but Iโm the only user and I expect people to copy my app if they want to look into it in. If someone could help my understand the proper procedure for sharing prototype apps on a free account, Iโd appreciate it.
Hi @Kirk_Masden I posted a tips and tricks, hope that helps. App needs to be deployed. Profile apps are free.
By the way, itโs interesting to me that the order of operations seems to make a difference.
This suggests a format ruleโs condition is evaluated only at sync-time, not dynamically as the user interacts with the app. Similar to the way an app formula is only evaluated on sync (except in forms).
I can confirm that other format rules work without syncing. Also, even after the refresh (sync), if I navigate back to the table view and then tap on one of the records to view the detail view, Iโm back where I started โ the format is gone again. So, I think itโs a matter of some kind of influence that the table view has on the related detail view that follows it โ not just sync issues.
For now, Iโve resolved the problem by using a VC column to make a duplicate of the column I need to format differently in different contexts. This has allowed me to make format rules that are not dependent on context (โMake column A normal size and make column A-VC bigโ etc). I just need to decide which column to make visible in various views. Still, it would be nice if context expressions worked reliably in format rules.
@morgan Any thoughts?
Recently, I have been avoiding โcontextโ expressions with format rules. Instead, I make virtual columns that I only use in contexts where I want the rule to be applied and then make a format rule just for that virtual column. That seems to work well.
User | Count |
---|---|
35 | |
34 | |
26 | |
23 | |
18 |