-
Duplicate several records in table
I would like to duplicate records in a table meeting the condition of having the same value in a field (order number). This value has to be change with a new one coming from the table that is…
-
Remaining to a date & style
Hi. I have this: let Countdown := 'Data d''inici' - today();styled(text(Countdown), if Countdown = -1 then"red"elseif Countdown < 0 then "Orange" else "white" endend) I want to format the f(x) like…
-
Filtering Question
I'm rather new to Ninox. I have an easy question. In my table, I have a column that has Y, Y N, and Y P. I need to filter out just Y, not Y N or Y P. What is the best way to do this? Thanks in advance
-
Show button if 2 conditions
Hi all. How can I set a button to show only if 2 conditions are fulfilled? I have 3 buttons:
RC & AA - show only if Selection 1 = 1 or 2 or 3 AND if Selection 2 = 1 
Sin RC & AA - show only if… -
Hello! How can I delete records permanently? If I delete just marked deleted, (I think) and my number calculation is wrong, when I step back one record for a previos number of that redord.
let x := number(record(Tankolas,Id));if record(Tankolas,x) > 1 thenrecord(Tankolas,x).OraAllas - record(Tankolas,x - 1).OraAllasend
-
How to lookup vehicle information based on vehicle ID number
The US Dept of Transportation provides examples of how to use their api, with multiple programming languages at: https://vpic.nhtsa.dot.gov/api/Home/Index/LanguageExampleshttps://vpic.nhtsa.dot.…
-
PDF Unlocker Tool to unlocking PDF files
PDF Unlocker Tool to unlocking PDF files
-
Button Coding for next and previous tab
Hey, Is there such coding for next and previous tab buttons? Thanks.
-
Multiple lines in a row?
Hi NX community, sorry if that's been asked already. Is there a way to display some text in multiple lines of a single row instead of using multiple rows? thanks! G
-
Formula for On Click field to change the value manually by typing that is display from a reference table.
Hi, I have a form which show me fields with values from different tables like for expample the carton measurements Length, Width and Height. However, sometimes it happen that the measurements differs…
-
Sorting within a constraint
I have constraints set for a related field but the ID is the default sorting field. I have changed it manually when entering a record, but this only changes back the next time I go to enter a new…
-
"59 - Global_Functions"
Hello everyone,could someone send me the password for the example "59 - Global_Functions" found in "Webinar EN 2018" - thank you very much
-
HELP! What is wrong with my code? Trigger after update problems
I have a multiple choice field with two options; 'Salvage' and 'Staff Purchase'. I have the code set up to create a line in another table when 'Salvage' is selected,…
-
Whether multiple options can be copied, can be used as a data table reference?
Whether multiple options can be copied, can be used as a data table reference thank you.
-
Problem with language in print form
Good day! I work with Ninox in Russia When I make print form in editor mode it's normal But in pdf it looks like this How to solve this problem?
-
DATABASE BREAKING BUG (Please Read!)
Hello Everyone! okay so, last friday I was messing around with the database to find some neat tricks or random tools to add in my Db when I accidentally added openFullscreen(this) on a formula line…
-
Commenting (Code)
I needed to add a comment to document something important ... I went through ALL the posts I've saved re: commenting (in code) and initially none of them worked (my fault because I didn't put lines…
-
How do amend a basic sum function not add a sub-table field based on another field?
I currently have a basic sum formula that totals all of the 'Item Total Net' fields within a sub-table as shown on the attached screen shots, however i would like a formula that omits any of the…
-
Automatically Import data from a related table based on the name of a given string.
Dear ninox community, i would like to create a table "Overview", in which I have several "historical events" listed. Now each of these events shall be assigned a subtable or a simple view field,…
-
how to make a button in "table 1", change a no to a yes in a "table 2", depending if a different formula in "table 2" is = Yes
how to make a button in "table 1", change a no to a yes in a "table 2", depending if a different formula in "table 2" is = Yes
-
set image size at print out
Hi, I have a problem with the image size when printing out my invoice. I would like to show an image of the product in the same line with all other product information.…
-
Change specific records with button
Hello. I have two fields, and a button. One field is 'Existing Manager' which is linked to a field Employee. Another is 'New Manager' which is also linked to the same field.…
-
Lenght(string)
Buongiorno, Vorrei estrarre il nome del file immagine nel campo 'Foto 1'. La stringa estratta contiene o 14 o 15 caratteri, ma a me interessano solo gli ultimi 12.…
-
Console Error dynamic conversion of Single Quote Character to non-ascii character
Folks, Has anyone else seen this error... I do recall this error from a year or so ago.. I thought the answer was to change a default character somewhere.. but now I cannot find that resolution ..…
-
if/then/else
I have a field named "Units number", I want to create a new fx field to define the units to consider by yes and no like this: if "Units number" > 2 then "yes" else "no" end but the result is "no" in…
Answer questions and share your knowledge