-
I set up a system with multiple accounts. Each is a share of a total fund balance which is used to calculate shares of total income. Year Ends April is the individual balance table year and the dashboard year is Fiscal Year. This is tracked by year and I set up a dashboard table to enter total dividends that then get distributed by share. If I enter multiple year info on the dashboard the dividends don't show up. Here's the code that works perfectly when only one year is entered. Any ideas
let y := 'Year Ends April';let i := (select Dashboard where 'Fiscal Year' = y).TempBal;let TempNum := number(i);let j := ('Beginning Balance-Temp' + 'Beginning Balance Perm') / TempNum;let k :…
-
Die Funktion importFile(rpt,URL) sollte funktionell erweitert werden
In der gegenwärtigen Definition von importFile() muss an der zweiten Stelle eine vollständiger WWW URL stehen. Dateien im lokalen File-System lassen sich nur händisch einzeln herunterladen,…
-
Customised print with view table.
I have customised a print from a table that has a view. The view is a list of appointments relevant to the table (customer record) When I incorporate the view in to the print,…
-
Das Fenster des Formeleditors sollte die linke Seitenleiste des Ninox Fensters nicht überdecken.
Gegenwärtig bleibt bei allen Funktionen (Tabellen/Formular/Feldoptionen) die linke Seitenleiste mit den Tabellen unverdeckt. Lediglich der Formeleditor macht hier eine unnötige Ausnahme (wer schreibt…
-
find out if a field is used in scripts
My need is to determine if a field is used in at least one script.
-
Trigger at a specific time
is there a way to start a script, a command, at a specific time ? For example : at 10:12 -> openURL …
-
TOP SHELT
Would this work better on Windows 10
-
Can I automatically enter different choices from a table into a Combobox from another table depending on the choice from another Combobox?
Good day all! I'm quite new to Nin\ox and have a question. I am creating a databse for quoting, invoicing and job profit/loss on individual projects. We are a company making high-end furniture,…
-
print attachment
perché quando stampo gli allegati di un modello non sono in formato originale ma appaiono come una miniatura?
-
This expression returns a total of Rev-Amount from my Revenue subtable until the "where" portion is inserted. Any idea why?
sum(Revenue.'Rev-Amount'where Revenue.'Credit To:'=1)
-
How to trigger two things at once using 'if, then else'
Hello, i'm hoping this is a simple question to answer. In the trigger formula below you'll see that i am trying to trigger two things at the same time (in bold).…
-
How to create customer code
Greetings. I would like to know how to create a field of client codes, something like this: Customer CodeIMC0078IMC0079 The letters would always be the same,…
-
How to create company customer list with multiple contacts?
Good afternoon! I am creating a list of clients, which are companies. I'm almost done, but I'm having trouble designing the contact section. The problem with some companies,…
-
put two text fields together into a multiline Text Field
Sir, How do I put two text fields information together into the multiline text field and make it "multi line"? ie, I have field 1 and field 2, when put them together,…
-
Phone Number Formatting?
When typing a phone number in the phone number field (or even text field, whichever is possible), how do I set an automatic phone number format? I would like my format to be (555) 555-5555.
-
I'm looking for a way to filter and delete records after import
I need a way to filter a field in a table, so after I import records into the field they can automaticly be deleted from the table.
-
Alert and colour
Hi, Is it possible to set up an alert in red and bold? Thank you
-
Automatic progressive number WHEN IMPORTING - Urgent help!
Hello everyone! I have the typical code for a progressive ID Number (in "trigger on create"): let before := max((select CASOS).'Número');'Número' := before + 1; It works good,…
-
trigger at the update with integromat
Good morning, I use this formula to send a push notification on my iPhone let webhookURL := ""https://paste-your-webhook-url.here;let data := {RecordID: ID};http("POST", webhookURL, {'Content-Type':…
-
2 views different fields
Hi is it possible to make 2 form views of the same table , but in view 1 show some fields while in view 2 some fields should be hidden?
-
Champs
Bonjour, Pourriez-vous me dire comment masquer un champ sur un formulaire. Merci d'avance Fanny
-
Print layout iPad vs PC
Hi I am finding that when I have a print layout setup it is not exactly the same if printed from a PC or if printed from a iPad , it seems like when printing from iPad the column are narrower then…
-
Printing Issues--Expanding Rich Text and movement of other fields
I am trying to print a report. I have one side of the page set up with some specifics about the case and 2/3 of the right side of the print layout is the actual report.…
-
What are all the parameters I can use when sending an email in Ninox?
I know you can set the subjct, the body (HTML) Is there a way to set priority? Set CC/BCC, attach MULTIPLE FILES (if so how?), set the reply to a different email, change the name of the sender?…