-
Automatic adaptation of views
Hello everyone. I would like to know if there is a solution so that the views adapt in height (number of rows) automatically according to their content.…
-
writable if - otherwise calculate from another field
Hello, I have a numeric field for a measurement in inches, and a second for a measurement in centimetres. When I enter one I would like it to auto-calculate the other.…
- Answered
-
Record create date function
Hello Ninox community, I wanted to create a field that displays the record creation date and which user created the record. Would it be possible to do this?…
-
is there a formula to disconnect the link field to a table ?
i would like to disconnect the field linked to the table with a formula. I am trying to disconnect the field when i update another link field. I hope i've been clear. thanks in advance for your help.
-
Parent / Child / Grandchild
Hello there. I'm a new user and am struggling with the Parent / Child / Grandchild relationships. I have the set-up the following relationships as shown in the picture:…
- Answered
-
Content Refresh on Dynamic Multiple Select
I've run into a perplexing issue... I have a few different dynamic multi select fields in a table pulling in options from other tables. Content in the name, color,…
-
Beginner's question
This is so simple and basic I'm almost embarrassed to ask. I have a recipe database one of whose fields is 'Ethnicity', with various options (Chinese, Italian, Greek, etc.).…
- Answered
-
How can I create a dynamic multiple choice that uses selections from another dynamic multiple choice.
dMC A item 1 item 2 (selected) item 3 item 4 (selected dMC B shows the following item 2 item 4 The user select items 2 and 4 in dMC A. dMC B shows only the items choses in dMC A
- Answered
-
Coding a popup dialog in a for loop if error
I've been reading that loops cannot be coded to exit. But I'm trying to figure out if there could be a way by adding an if statement somewhere in the code.…
- Answered
-
Problems with condition statement in a while do structure
Hi there! Hope you can help me out with this: So, I'm building a Many-to-Many relationship between two tables, one for journal entries ("Asientos por Registrar") and another for Vendor Invoices…
-
NINEXT Error flags - false positive??
I have 7 like this which do not make any sense to me at all. If I follow the wrench I cannot find any issues which reflect this and to be honest the bread crumb does not make sense either.…
- Answered
-
Checking if a record has been linked to another one
Today I noticed an unexpected (to me - as non professional coder) behaviour when checking if a record is linked to another one. I haven't found info about it in the forum nor the documentation,…
-
Export/change/import attachments
Hi gurus, In our DB, we have a huge number of attachments, some of which can be of reducible size. Is there a way to access directly the attachments, in order to reduce their size (pdf, photos) ?…
-
Using 'alert' to overcome real estate issues.
Ninox could improve the form views a great deal by allowing more control over padding between fields, field sizes, font sizes and so on. There is a lot of wasted space in my opinion,…
-
Bigger images in print-layout
Is there a way to make the images in the upper right corner bigger? My aim would be to have larger thumbnails, with the title below each image. At the moment the images are decidedly too small and…
-
Converting a text string to a multiple choice field
Hello! I've been having trouble figuring this out and I would love some help. I have a work flow that involves a potential guest (school groups visiting our site) filling out a form that…
- Answered
-
Elimination of decimal numbers
Hi! How can I remove decimal numbers from a number? I have a Number field which is set to Euro currency with two decimals. But during the calculations what is behind it is considered, i.e.…
-
Form to Sheet view
When one opens a table in form view and then selects (all) the form does not slide out of the way to reveal the sheet/table view which is now underneath, if you know what I mean.…
-
Formula fields not visible to other users
I am attempting to create a dashboard and use a lot of formula fields to display data. However, when any other team member views the form, the fields are not showing up.…
-
Order by date from text field
Hi. I have a date in text field and I want to order it by date. Create a date field is not an option, I need it to be with this text field. Is there any way to do that?…
- Answered
-
Hours result from appointment field
I have an appointmenet field which has started giving weird results in a formula providing hours worked. This is the formula: duration(appointment(datetime('DAY END'),…
-
Passing data from a Text field or MultipleChoice field to a DynamicMultipleChoice field
If you have a MultipleChoice field, and want to pass the same chosen options to a DynamicMultipleChoice field, follow the steps below: - Create a new reference table with the options written exactly…
-
Date of Birth? manually entry
hi, i have to set DOB but I found that on apple app, we I touch date field always display calendar to add a date, that is too annoying when you must set for example 1953 as year of birth,…
-
Look up value in table based on two other values
I'm new to Ninox and am trying to set up a database for a distillery's production records. One thing I need to accomplish is a formula that can look up a value in another table based on two inputs.…
- Answered
-
Duplicate several records with changing one of the fild values
Hello! I need help, guys! How can i duplicate lets say 10 records of a table simultaneously (not one by one), and at the same time automatically changing some text in one of the text fields?…