Hi,
I have around 20 forms in my database, the documents of this database appear in the same view.
Currently, I am using this approach:
I have a column in my view that contains the following formula : @if(Form=A; "Form is: " + "created on : “+ +” created by the user "+ ;@if(Form=B; "Form is: " + "submitted on : “+ +” created in the department "+ ; …
as you can see, each form has to be displayed differently in the view. I am thinking to change the above approach to store the description inside the document, in a computed field, itself and display 1 single field instead.
My database is 15 GB for now and I think that storing the column description in the document will definitely improve views rebuilding time.
Note that I have 30 views that use the above same formula. so If I retrieve it once from the document will be faster than computing it each time on the view level.
What do you think of this?
thx.