Hello,

Im a newbie coming from dabbledb. Please let me ask some questions.

1. I have a table with many columns (fields).  Is it possible to hide/show certain entry fields to certain users? 

2. I have a field that import data from another form with more than 800 of entries.  How can I multi-select these data without having to select from a long checklist or drop down? A series of search box maybe. next that appears after a search box is filled and submitted?

3. Is there a derive field functionality? Example derive count: count the number of entries a  in a target field.

4.  Is there a way to filter or sort date fields by year, month or week?

5. Is there a way to get the sum, average of a numeric field by groups? And is it possible to derive the sum from another form?

6. What will happen after 100,000 records have been used?

Edith