Dynamic Choice triggers twice

When trying to use a 'trigger on update' for a Dynamic Choice field, that actually changes the chosen value, the trigger runs twice. I was under the impression that sensibly a trigger is NOT…

• Answered

Comparing Multi-Selects

Looking for help on how to compare two multi-selects. Specifically, I need to return a true result when none of the options in the second list are selected in the first list.…

How to insert comment in code?

Hi NDB family! Is there a way to insert some kind of code to add a comment within code? I tried to use /* COMMENT */ but it doesn't seem to work. THX. G

Integromat - Trigger after update

I am trying to print a template through Integromat and save it in a record. For this I have a scenario where a yes/no field in the record is updated. This works perfectly.…

Updating calculation - effect on existing records

I have a calculation in my records. Let's say its " 'miles' * 0.50 " so if I travel 50 miles the answer is 25 (£25.00). But I need to increase the rate to 0.60. Now the answer will be £30.00.…

Duplicating a database deletes internal references

I have duplicated a Database in order to start populating it with data from scratch. One of the tables ('Selezioni') exists only to allow the creation of Cascading Dynamic Choice Fields.…

• Answered

Date fields and timezones issue (Unix vs UTC conflict)

Dear Ninox members, I would like to share my experience with other users as well as ask for improvement features from Ninox support in upcoming updates regarding Date fields that are affected by…

Calendar sync - beyond vs above

Could someone explain the difference between "months to sync beyond" and "months to sync ahead" in calendar syncing please? And why each is limited to 12 months? Thanks Nick

Table View column Totals

I have setup a view of my invoice table grouping records by customer and summing the total invoiced, total paid, and total owed fields. What I am wanting to do is to have a total row at the bottom…

How do I change the date format to year.month.day?

New 3.6 Script Editor

Is there a way of turning off the auto-complete function in the new 3.6 script editor? If I want 2x " (double-quotes) or a pair of braces () or {} then it assumes I always want a pair.…

Values of Multiple Choice shown as list in print report

Hi guys, Normally when you put the values of a Multiple Choice field in a print report, it's shown as all the values separated by a comma and a space. Is it possible to get the values shown as a…

• Answered

while loop stops before reaching end

Hi everyone, I created a button in one table which is to export some values to another table creating new records there. I am using a while loop to create the records.…

Organize Reports

Hi all One question about organize reports on DB. I organize a Table Reports ( no informaton here) with for now 3 reports one for each subtable (Disciplines,…

• Answered

I need to build a string for each "checked" multiple choice

Hi, Hope someone can help! I have a multiple choice field which has 5 options (at the moment, this may change). I have another field which is a numerical value,…

• Answered

URL Field expands off layout view

Hi, I've reported it to support as a bug, but just wondering if there's a workaround in the meantime? I have a couple of URL fields in a database and they're already at the maximum width I can go in…

Sending invoice by mail?

Hey guys, i love this database i am building, ninox is quite powerfull! Id like to know if there was a way i could create a button on my invoice page that would add the invoice as an attachment in…

Two questions: All View and Imports

I'm trying to import data into a new database from an old one. I first tried to Export data from the old database, but this only seems to export the view you're currently on.…

Admin mode toolbar hides field at bottom of view! Help?

Hello, I'm trying to edit the size of a field at the very bottom of a view, but when I enter admin mode, the toolbar pops up at the bottom of the screen and hides the field.…

Show field if two conditions are satisfied

Hi, I need to insert a formula that says: show this field just if Field A=1 (it's a button switched on) and Field B=7. I tried to put in the show only...…

Insert automatically customer data

I would like insert automatically customer data in another table without having the user fill them in. The data is same, selectd in a lookup table. It's possible? Thank you

Display immedialty data entry mask

I would like display immedialty data entry mask, when user the table, without viewing the list in table mode, is this possible? Thank you