Configuring Tables Parameters
Avnio Tables provides setting to configure it as per need. This step should be completed immediately after installation.
Go to Salesforce Setup => Custom Setting => Tables Configuration
Click on Manage
Create Org Wide Setting if does not exists.
Here are Setting description:
Enable System Time Zone Setting: As in salesforce, multiple users in same org can work in different time zone. If User’s time & System(Machine or Laptop)'s time zone is different, there might be confusion in entering date & time and reading it. By default System Time Zone will be off. Meaning all date time data will be considered based on salesforce user’s time zone, not system’s time zone. If you wish to work with your system’s time zone then you can turn it on.
Refresh View After Record Changes: Ideally when making changes to records through Avnio Tables(either creation or changes), By Default Avnio Tables only refresh records which changed, not all. Sometime on changes of few records, in background we are modifying one or more fields of other records, at that time, we need to refresh entire view after record changes, to reflect those changes.
Empty Cell Value: Ideally any fields in record do not have value, rendered as blank value. This can be problematic when we group records with field which has empty value. Avnio Tables will not able to group records having blank or null values. If that is something require to do, we need to assign any value except whitespace so that Avnio Tables can group those records below single label. Possible value can be: Blank, (Empty), (No Value) etc. If value is blank then It will group by all records having blank value in group by field.
Client Side Page Caching: Avnio Tables provide capability to work with all records at time to improve user experience and data integrity. Because having partial data on client side, do not give accurate results in aggregation, grouping, filtering etc. So as it has to work with larger data set, this setting will enable caching to make data retrieval faster and improve performance. This will have no impact on user experience.
Record Chunk Size: As mentioned above, Avnio Tables has to work with larger data, due to salesforce limitation on heap size, we can query or fetch certain numbers of records only depends on columns. So if we need to work with more columns(i.e. more than 20), we need to reduce chunk size to accommodate heap size issue. Default Value of chunk is 10,000 but can be decreased if there is significant increase in columns numbers to work with any of Object’s View.
Auto Height for Text Area: Ideally Text Area are not wrapped & auto sized by default because that is DOM Intensive operation which can impact performance if data size is larger. Enable this if you want to wrap and auto size all text area for all views.