In this post Iโd like to collate some information about how to work with table view.
First of all, hereโs what we have in documentation:
The documentation explains that the โTable view shows information in a very compact way allowing you to quickly scroll to find a rowโ but, unfortunately, thereโs no link to a detailed explanation regarding how to work with table view. I hope this โTips & Tricksโ post will constitute a temporary substitute for that documentation and that this post of mine will eventually be made obsolete by a better โofficialโ documentation page from AppSheet.
Iโll present some common questions about how to work with table view and how they have been answered previously (or, provide my own answer here and there):
I hope some people, especially newcomers, find this Q&A to be useful. I was prompted to put it together because I just learned today how to use โSave and Verifyโ to adjust column width, even though Iโve been trying to work with table view for some time now. I thought there might be others who had not yet figured all of this out yet.
Currently, my Q&A has only the seven questions you see above. If there is another question and answer that you think should be added to this list, please put it in a comment. Thanks!
Doc update is requested
Excelente aporte @Kirk_Masden!
I like it!
This is great Kirk, thanks!
Thanks for adding my text wrapping idea, @Kirk_Masden. Hope it will take off
Iโll need to add that properly later โ havenโt done so yet. Certainly, though, if it becomes possible, I definitely will want to add it to this Q&A list.
Hi @Kirk_Masden, I just read your post today and I can tell you that this kind of write-up is really helpful for newbies like me. Thanks for sharing this.
Late to the game, however just stumbled across this post which turned out to be extremely valuable to overcoming a few obstacles for this morningโs development session. Thank you @Kirk_Masden.
Since quite a lot of time has passed since I wrote this, Iโm no long able to edit the original to add another question and answer. If I could, I would and the following:
I would say bug or need to change the spec. Without delete option the table should be โquickly editableโ
I certainly understand your perspective. On the other hand, I can image why a developer would not want to make it easy to delete multiple records at once in some situations. So, personally, I like being able to choose whether or not to include the โQuick deleteโ function at the top. In regard to quick edit, I donโt see much reason to want to turn it off.
Once we move into table quick edit mode, nine go action available INC delete action. So the setting of the row is deletable or not should be nothing to do with we can take effect the quick edit mode or not .
The multiple-selection button (checkmark in a box) will only show up if there is an action available that can be executed on multiple records at once, such as, but not limited to, delete.
Another way to access this bulk selection (when available) is to long-click on one row of the table.
I have one column โItemโ plus several other columns that I always want to display (but those additional columns seldom have data). Since those other columns would take up too much space, I concatenate them together. Hereโs an example:
[Item]
& If (ISNOTBLANK([List])," (" & [List] & โ)โ,"")
& if (ISNOTBLANK([Notes])," (See Notes)","")
& IF (ISBLANK([Done]),"", "; Done " & [Done Date])
Has anyone figured out what this does?
Provides data validation for the length of the text string.
Sorry manโฆI guess I am not experienced enough to understand what that means
But I guess I can assume that definately does not controll column width?
Definitely not.
Data validation : determines whether or not inputted data is in the proper format and will be accepted.
Those options provide the means to limit the inputted text to a certain length.
So in short โฆleave them as is
I suppose it still a challenge on how best to tackle column width customisation.
I suppose the following ideas would be a bit to complex to implement:
I would agree that column width customization is an issue that has not be completely resolved. Heโs I idea that might be of interest to you until a better solution comes along:
So my above idea on how to handle column sizing is well presented as an example in how you can customise dash sizes. Except the options are only controlling horizontal size on the column. So the options would be Default, Narrow, Wide, Extra Wide and Maybe then a customised size where you enter a size to ofset the standard. eg: Add 5 โunitsโ more etc.