Dorich
-
Help with sorting on 4 columns
Using the method suggested elsewhere in the forum I created a sorting number/code to sort 4 columns. Its of the form Value1"."Value2"."Value3"."Value4. This results in a field that gives me a result…
-
How to restrict choices in Table References
I want to select a value from a table to use in another table, but only want to select from certain records. Example Table 1 has four fields - Title - P1 - P2 - Subject (To be filled from Table 2)…
-
Using Id as record counter
I want to create a simple record ID for use in concatenation. I know how to do that using a formula to build a counter but I wondered if its possible to use the database record Id for the same…
-
How to extract numbers from a field record
I need help extracting some information from a field. I have a field the contents of which take the form of X-x-x Text Where x is a number consisting of 1 to 3 digits.…
-
Creating serial numbers for group and sub groups
I’m attempting to use Ninox to create a filing system that is broken into the following sections - Box - Group - Subject A group is contained inside a box, and a subject is contained inside a group.…
-
How to use the "Form" option in "Views"
Note - This relates to the Mac version I'm confused about the purpose of "Form" when you click on the "New View" selection. My expectation is that I can create a form in which I choose the fields and…
-
Hiding Fields
This attempt to hide a field is not working 'Financial Prefix' = "BA" The field 'Financial Prefix' is a choice field. The field to hide is a simple text field that will display if the 'Financial…
-
How to create a field that consists of the last four digits of another field.
This question is probably more basic than it sounds. I want to take the last four digits/characters of a number and use them as the content in another field.…
-
Is there a way to order the "Many" list when making a selection?
Perhaps best explained with an example: I have a table with a list of objects I have another table with a list of specific dates I've linked the Objects (1) to the dates (Many) When I click on the…