-
Hi Tomek,
one way to achieve this would be to have a separate table "Reporting" with number fields for Year and Month. Then, add formulas for your monthly reporting as you like, e.g.
let y := Year;
let m := Month;
count(select Invoices where year('Invoice Date') = y and month('Invoice Date') = m)
Best, Frank -
Hi, i normally do data entry in the table form. Can you help create short-cut key, so that when I am done with a record, i can press the short-cut key (like "Enter" or "Cmd-Enter", to create a new record, and jump to the first field in the new record?
Right now I have to use my mouse to point to new record, and to click again in the first field of the new record in the table form.
Thank you! -
Hi Birger,
Thank you!
After creating the new record, Is there a shortcut key for jumping to the first field of the new record?
Of course, it would be great to have a shortcut key for creating a new record AND put the input cursor to the first field of the new record. But I can manually create that, if there is a shortcut key for jumping to the first field of the new record. -
Hi Jaca,
The permission to manage creation of new records and others is present in the table property as "Allowed to Read/Write", "Create new records/Delete records" and "Readable If/Writable If" fields.
Regards,
Sakshi- Ninox Support
http://manual.ninoxdb.de/de/?attachment_id=2444 -
Hi,
this can be done with the option "Display field only, if:" on every field. You can input the formulas:
___________
user() = "Bob"
or
userHasRole("admin")
___________
In this way you can assign every field to a certain user group, thus design different views of the same input form.
For more formulas for user and role please have a look into our "Referenz of Functions and Language":
https://ninoxdb.de/en/manual/calculations/reference-of-functions-and-language
Best, Jörg
-
Thanks, Jorg. I understand that I can make fields appear and disappear for different users. But since I have multiple tabs on my main form, would this not result in scattered fields and some blank tabs? What I'm aiming for is a form for (say) editors that has half a dozen relevant fields visible as soon as the record is opened. Is that possible?