Forms

Hi klgamble,
click on the active tab and then "Edit fields". You can reorder everything by drag&drop. However, moving a tab won't move tis fields so it might take some effort.
Regards, Frank

Trying to understand the use of tabs. My guess is that the manual is old as it doesn't reflect what I am seeing on my data screen. Is there an updated version available.

Hi Thomas,
the new release is a bit different. We'll update the manual, soon. Sorry for that.
To create new tabs:
- Activate the wrench icon top right.
- The form's toolbox will show up.
- There you'll find: Layout element => Tab
Regards,
Frank

Thanks, that worked. Now, using the tab for "files", I loaded a couple of images. Can't seem to be able to move these images to the other tabs. Not possible or just doing something wrong.

Tabs are a possibility to arrange fields of a table. Each field of a table is unique.
As a workaround you can add a formula field and access the image through that to display it on several tabs.
Best regards, Alexander

Hi,
How can I make summary page/form, where will be for example:
- How many invoices was printed in this month
- How many of them was payed
- How much money my contractors must give me back.

I don't want do print it, only view.

Thanks :)

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

How can I create a full screen input form where the button navigate between menu and forms?

Hello,
You can drag the form view to the left so it covers the table view. Do this in Admin Mode (wrench icon in the top right corner is right) so that this view is proserved. Note that is currently not (yet) possible to force uses to a specific view.
Greetings
Birger - Ninox Support

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!

it's "cmd+n" ("new")

Birger - Ninox Support

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 Steve, it's not possible with a script command. Simply press TAB to activate the first field.
Best
Frank

Hello

How can I delete or hide the tab that is created by default? I do not like that the main tab has to have the name of the table.

Is it possible to erase or hide that tab with the name of the table?

Best regards!

This is not yet possible.

Birger - Ninox Support

Hi, how can i prevent users from creating new records and let them only select an existing record from a referenced table?

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

The layouts of the forms need to be different, depending on the device being used. Is there some way to create an iPhone-only form?

Vivibility of fields can be controlled depending on the outcome of this function:

–––
ninoxApp()
–––

This will return "iphone", "ipad", "mac" or "web".

Birger

Is it possible to create an alternative form for the same table, which can be assigned to a particular user group?

David ^ I would like to see this as well.

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?

You can set access rights to tabs (and all their fields) as well:
Visible if: userHasRole("Admin")

Birger