Dan James- Dan James Media Ltd's Profile

Latest Posts

Re: Help with a simple formula!
Replace your highlighted code in the screenshot with first('Physicians and associated practices'['Primary Physician' = true]).Contact.'Last Name' Explained: - first() grabs one record,…
- Danjamesmedia
- 3 yrs ago
- Get help
- Reported - view
Re: Relations / Relaties
Hi Michel, You're right - Composition just allows for the cascading deletion of child records. Another feature is that in a composition relationship, the unlink record button is hidden to the parent…
- Danjamesmedia
- 3 yrs ago
- Get help
- Reported - view
Re: Stuck on simple multiple if/else
The best practice is to use "switch case" rather than nested ifs. switch FieldName do case ValueID: OutputtedValue (repeat last line for each ID) default: OutputtedValue end so in your case:…
- Danjamesmedia
- 3 yrs ago
- Get help
- Reported - view
Re: timeline to comment
When you say insert reminders, do you mean have a notification email/message pop up to a user? Might be easier to take this conversation off the forum - feel free to send me an email at…
- Danjamesmedia
- 4 yrs ago
- Get help
- Reported - view
Re: Enter a number in the field do not use the keyboard
The formula in the buttons would be: Number := Number + 1 and Number := Number - 1
- Danjamesmedia
- 4 yrs ago
- Get help
- Reported - view
Re: What's with all the garbage
Hi Michael, You can change the "can delete" permissions at table level to a different role that you (and other users) are not part of (eg, "editor"). This way records cannot be deleted.
- Danjamesmedia
- 4 yrs ago
- Learn and share
- Reported - view
Re: timeline to comment
A simple approach is to add a subtable with a date/time field with default set to now() and a text field to contain the comment. Whenever you need to comment,…
- Danjamesmedia
- 4 yrs ago
- Get help
- Reported - view
Re: compare arrays’ values
You would need to use loops to compare your results against the matrices. Send over an example of the matrices, and how the compliance level is calculated when comparing to them,…
- Danjamesmedia
- 4 yrs ago
- Get help
- Reported - view
Re: I need to have label in different language. What is the best way of doing that? Formula fields? too much space
Labels can only be in one language, so you need to use formula fields to achieve this, positioned to the left of the input field with a hidden label. If you have a language chooser with options: 1.…
- Danjamesmedia
- 4 yrs ago
- Get help
- Reported - view
Re: Bug or Limitation: Combo Box References: Limited Capacity
There is a limit of 100 entries for a dropdown, so your best bet is using a "link to" field. You can stop users creating records (when we want them to only link them) by adjusting the "can create"…
- Danjamesmedia
- 4 yrs ago
- Get help
- Reported - view
Re: How to stop Ninox rewriting URLs in email message body
It's not possible as this is a feature of sendgrid, the transactional email provider that Ninox use. It is possible to make these links "invisible" by sending the message as HTML,…
- Danjamesmedia
- 4 yrs ago
- Get help
- Reported - view
Re: Visualization Tools
https://nioxus.com/products/reports-plus/ is designed specifically for Ninox. Alternatively, Zoho reports
- Danjamesmedia
- 4 yrs ago
- Get help
- Reported - view
Re: Default mail
Another option is using mailto links within a button, if you need a more dynamic approach to adjusting the recipients, subject and body dynamically. The code would be: openURL("mailto:…
- Danjamesmedia
- 4 yrs ago
- Get help
- Reported - view
Re: Automatically change a value when a date is equal to today
You could use a formula field to show the correct status rather than a choice Field, as formulas are calculated at the time the records are shown to the user.…
- Danjamesmedia
- 4 yrs ago
- Get help
- Reported - view
Re: CSV Import assigns wrong date
On the top-right of the first screen in the importer, you can specify the format of date fields. Make sure this matches the date formatting in your CSV
- Danjamesmedia
- 4 yrs ago
- Get help
- Reported - view
Re: Hi, I am a newbie to db, when data is imported into Ninox from Excel can it count time to manage customer subscriptions by sending our renewal emails? Thanks in advance.
Yes, this is possible. You can simply + or - an integer from a date field and it will add/subtract that many days. Eg, DateField + 30 = today() will show records where DateField is due in 30 days.…
- Danjamesmedia
- 4 yrs ago
- Learn and share
- Reported - view
Re: send an email only once a day
If you need to schedule a record/action to be completed daily, you can trigger this from Integromat. I would create a table with a single record with a checkbox field,…
- Danjamesmedia
- 4 yrs ago
- Learn and share
- Reported - view
Re: PROVIDING DIRECT LINKS TO RECORDS
This now works for Ninox cloud by simply copying the URL in the URL bar. With the upcoming release, you can also get direct links to records within ninox Formulas.…
- Danjamesmedia
- 4 yrs ago
- Get help
- Reported - view
Offline?

Anyone else's Ninox offline? Can't seem to log in or access via API!
- Danjamesmedia
- 6 yrs ago
- 1reply
- 876
- Get help
Re: Button to duplicate entry in a second table?
Hi Anna, Yes this is possible. You'll need to write a formula using the "Create Record" function documented here: https://ninoxdb.de/en/manual/calculations/reference-of-functions-and-language The…
- Danjamesmedia
- 6 yrs ago
- Get help
- Reported - view
importFile issues with a link to a file that forces a download

Hi, I'm integrating JotForm with Ninox for a client and having issues adding a file that has been uploaded from a form into Ninox. I'm in a position where I have the image link in a field in Ninox,…
- Danjamesmedia
- 6 yrs ago
- 1006
- Get help
Re: Record Archiving or Hiding
Why not create a sub-table to house each version of the documents? All searches could be on the master table. Creative use of views/formulas will return the values from the latest version,…
- Danjamesmedia
- 6 yrs ago
- Get help
- Reported - view
Re: How do I show information from another table, based on user input?
Here it is: http://cl.danjam.es/61f3640696c9
- Danjamesmedia
- 6 yrs ago
- Get help
- Reported - view
Re: How do I show information from another table, based on user input?
Thanks, Sean. So the formula for the save button is as follows: let SearchTerm := State;let i := number(concat((select OtherTable)[State = SearchTerm].Id));let NewUsername := Username;…
- Danjamesmedia
- 6 yrs ago
- Get help
- Reported - view
Re: How do I show information from another table, based on user input?
Haven't figured it out yet although tried for a while. Maybe someone else can help with updating field values in a record in another table with a given Id.…
- Danjamesmedia
- 6 yrs ago
- Get help
- Reported - view

1 2 3

Welcome to the Ninox community

Dan James- Dan James Media Ltd

Re: Help with a simple formula!

Re: Relations / Relaties

Re: Stuck on simple multiple if/else

Re: timeline to comment

Re: Enter a number in the field do not use the keyboard

Re: What's with all the garbage

Re: timeline to comment

Re: compare arrays’ values

Re: I need to have label in different language. What is the best way of doing that? Formula fields? too much space

Re: Bug or Limitation: Combo Box References: Limited Capacity

Re: How to stop Ninox rewriting URLs in email message body

Re: Visualization Tools

Re: Default mail

Re: Automatically change a value when a date is equal to today

Re: CSV Import assigns wrong date

Re: Hi, I am a newbie to db, when data is imported into Ninox from Excel can it count time to manage customer subscriptions by sending our renewal emails? Thanks in advance.

Re: send an email only once a day

Re: PROVIDING DIRECT LINKS TO RECORDS

Offline?

Re: Button to duplicate entry in a second table?

importFile issues with a link to a file that forces a download

Re: Record Archiving or Hiding

Re: How do I show information from another table, based on user input?

Re: How do I show information from another table, based on user input?

Re: How do I show information from another table, based on user input?

Overview