-
Building your own Function?
Hello, Please van you give some code examples how to define a custom function? Forum description: ++++++ Creating User defined functions locally with the function command: function name(argument:…
-
Is the following formula supported by the Android version?
Hello Is the following formula supported by the Android version? importFile (this, printAndSaveRecord (this, "My Print Layout"), 'Own Name field' + ". pdf") Thank you in advance Fanny
-
attachement on image field
è possibile visualizzare un allegato in un campo immagine??
-
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 :…
-
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,…
-
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 …
-
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,…
-
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?…
-
Using where statement with child or subtables
My database has a parent table: Funds with child table: Balances. Funds has multiple entries, each of which has multiple-year entries in the Balances. I am try to sum the Beginning Balance column in…
Answer questions and share your knowledge