
Are the numbers of fields limited ?
Hi
I have an imported base with a lot of fields.
I find them all in the form but it seems that in the table you can't exceed 23 fields.
Is this normal ?
Can one fix it ?
Thank you
-
Thank you for your answers ;)
I have checked : it is not possible to go any lower in the left window with a field.
Indeed when I select the field 24 in the right window and drag it to the left window after field 23 it refuses to install...It bounces !
On the other hand If there was an import problem how can we explain then that the fields are all in the form ? (There are 92)
-
Re: indeed when I select the field 24 in the right window and drag it to the left window after field 23 it refuses to install...It bounces !
Ninox does not always like like you adding more fields to the very botton in the to the show column when you have a full list.
Try adding it near to the bottom. Then dragging it down into place afterwards
also there seems to be a bit of fine art required to get that list to scroll ! takes a bit of practice! -
Just curious. What percent of your fields are used for each record? Are they all text fields? We have forms with over 500 fields. Depending on your use situation, you might be better off with a forms table that has a related values table. Each record in the values table would contain a single field name/field value pair. That way you could avoid a table with a lot of empty columns. Again, it depends on your situation.
-
The problem is that it is very difficult (but not impossible) to add an element at very end of either list when the list is filled to the bottom. And the trick is to add an irrelevant element at the end of the list as a guard. When a Line break is not possible, one can still define yet another field, and use it as the guard at the end of the list. It makes the operation of adding fields 'at the end' a bit easier, but it's surely no magic bullet.