-
Copy paste a value on all the fields in a row ?
Hi Is there a way to copy paste the same value on all the fields in a row ? For instance, I would like to copy the word "France" on each of the country fields "country" of my database. Thanks
-
Add a base to another ?
Hi How can I add a base to another ? For instance I have an incomplete base 1 I would like to add to it a base 2. Can someone tell me the way to do it ? Thank you
-
How to create a field with a non-required formula
Hello - - this is a newbie question. I've coded a formula field to calculate a rush fee based on a standard 40% surcharge, but I'd like to be able to manually enter an amount if I give the client a…
-
Drop out of a FOR loop early
Is there a BREAK command word to stop a loop - when a condition is met prior to cycling thru all the items in the loop? Can't seem to find a way to make it work without using a WHILE loop instead.
-
Look for someone to open my eyes once in a while.
Look for someone to open my eyes once in a while.As a Filemaker developer, I tend to make the switch to Ninox. But that's not easy. It's a different way of thinking and processing.…
-
Database created flag on iOS version?
Is it possible to have a flag indicate the timestamp that the database was created? Presume that would also mean duplicated or archived, etc? Alternatively (but essentially the same info) a way to…
-
Print more than one line of content?
Print mode only prints the first line of content in the table. Is there a way to expand the row height to print all content?
-
Unable to Format a Formula number & Display the formula as a column
Hi, I'm having a weird problem (from my perspective) in using a Formula in Ninox, calculating the final average Grade for one Student, in one Class : - I'm unable to force a format on the formula :…
-
Complex query and where statement
I am building a KPI table and want to populate it with data from a lead manager I have created so I know what the sales funnel KPI's are for each month.…
-
Maintain a default ascending order?
How do I get my ninox table to maintain an ascending column order? It defaults to a different order whenever I leave the table and come back to it. Thanks
-
Query to update a specific value in a record on click/on trigger
How to I update a specific value of a field in a table. I have a table named 'OpenRequirements' which has a field named 'status' which is set by selecting a value from table 'Status',…
-
To mask a field in the form ?
Hi Can someone tell me if it is possible to mask a field in the form ? If it is, thanks to tell me how.
-
To change the style of the row ?
Hi Is it possible to change the style of some rows in the table (not in the form) ? Thanks
-
Calculate appointment -1 day
I am trying to do the following thing. If the first "PRENOTAZIONI HOTEL" date is before the "Inizio montaggio ufficiale" field, then in "ALLESTIMENTO UFFICIALE" (appointment field) it should enter…
-
Ignorare un campo vuoto o con valore 0 - Ignore an empty field or 0-value
Problema di oggi ;) Durante l'inserimento dei dati ho una formula che controlla se il valore è già presente nel DB, il problema è che ho più campi controllati e non tutti hanno un valore inserito,…
-
Two trigger from same field
I'm trying to make both triggers work but only the second one works. At the beginning I had this formula and it worked fine: Periodo := appointment('Check-In', 'Check-out') After I added this formula:…
-
Sort dates chronologically
I have a date field in to which i am entering customer birth dates (day,month,year) I want to be able to sort these dates to show their birth day and month.…
-
Choosing between different Print layouts
How can I choose between different Print layouts? I know how to create them, but with my function (below) I can only choose the pre-chosen layout. let myFileName := Typ + "_" + 'Nr.' + ".…
-
Meaning of an error ?
Hi, Can someone explain me what does mean "Expected end : Select the line 2, column 6" Thanks
-
Linking a Table by a Field
Hi, I have two tables, one is Products and the other is attributes. There is a 1:N Product to many attributes relationship. I have created a table refence on the Product table to the attributes table.…
-
How can you import csv file into a sub-table?
My goal is to import an google sheet with different columns into a sub-table that I created on a boards in Ninox. How can I do it? I understand how to import in text field but not on sub-table that I…
-
Basic workings
I understand programming and have programmed in Visual Basic and Filemaker. If given an example or two I can usually figure things out. If I create a button that runs a script or a function like…
-
deleting
How do I delete multiple rows at one time?
-
Can you use Zapier to update a field in Nixox from a csv in dropbox?
Hi, I can export a csv to dropbox every hour. The file will contain the SKU (or Ninox ID if I need it) and a number. I want to pull this number into a Ninox field (overriting the existing value).…
-
Avg and sum in the same table
Hi I have a DB of my students. It has different items (with different weighs in the final mark) for the marks. I have a table with marks for each student but I can`t calculate the avg and then the…