-
How to get Multiple Choice selections to appear on Print
I've looked at some example and still struggling to figure this out and basically I am using an "Invoice" like form and I have to instructions that need to be printed depending on if they are…
-
Copy record data from a table and create a record in other table
I need your help in creating a code for a button that allows me to copy and paste the data of a record from one table to another.I have a table 'ORDERS A' and a table with 'ORDERS B'.…
-
Magic trick with palmed values…
Hi, I added 5 new names in a base and it is impossible to see them. Even if I sort my id raws in ascending order this 5 names are not displayed…Their id numbers are missing.…
-
Error in a formula ?
Hi I have this formula with a button : let t := ""; for i in (select 'Oiseaux famille genres espéces') order by 'Premier mot' do if t = i.'Premier mot' then i.('Premier mot':= "xxx") else t := i.…
-
Table records user control
Hi, I have an expenses table shared by different users but I want that each user only sees the records created by themselves. Is this possible. They have the same role and need to access the same…
-
How to ?
I have a table with horses and a subtable with vaccination dates. i want to check if the vaccinations are ok for each horse. The rules are that a horse need a basic vaccination and 30 days after…
-
Importazione in allegati file da google drive
Salve, ho un campo contenente un link ad un file in google drive. COme posso fare ad importare automaticamente negli allegati tale file senza doverlo scaricare e importarlo manualmente?
-
ripete un controllo su tutti i record di una tabella
Salve, dovrei ripetere un controllo, per adesso tramite pulsante, che riempie un campo di un record dopo aver estratto il dato da un altro campo dello stesso record.…
-
how can I get the share link from report or layout with a button?
Hi, I need to create a share link of a record, or share link of pdf generated, can I get the URL (Share link) with a button?. Thanks. Cris
-
Insert "Page break" printing records
Hello and good day to all! I'm sorry and that may be an easy question to you all but I need to make some records appear in a second page when printing, for example:…
-
Correction - Counting the number of items that have a flag set.
Apologies for the second post. I had a confusing typo. Good afternoon; I'm trying to learn how to count the number of entries with a particular status set. 1. I have two tables: JOBS and TASKS. 2.…
-
Is there a way to see or list Team Members who are currently signed in.
Can this be done?
-
Is there a way to hide a formula field from displaying in a global search
I have changed the text and background colour so it is not visable on the form. The table only has one text field and a save & close button.
-
Invitations
Hi, I have invited a person and this works, but when I go to the iPad of that invited person, he has access to all my databases. Can I grant access to 1 specific database? Tx regards Michel
-
Duplicates… Ninox… Excel…
Hi I try to select names wich are displayed only one time. So I use a formula for duplicates like this one : let myV := 'Bird name'; if cnt(select 'table name' where 'Bird name' = myV) > 1 then…
-
MacOS v3.3.2 long response times
Well I forgot to turn off automatic updates on my apps and now I got pushed out v3.3.2 for the MacOS and now I'm experiencing long responses on a table that has a lot of fields that reference other…
-
Distributing a database
Hi, I am still new to Ninox and I still have a lot of questions. I am an experienced programmer in Frontend Access database and Backend SQL Server. If i want to distribute a program (here an…
-
A black line in a rectangle
Hi I want to create a transparent rectangle in the form view I create a formula I enter : html("<hr>") I get a rectangle with a blalck line inside I go to "style" on RGB I select "background color"…
-
Missing Post
Very odd... I just replied to someone looking for help to create a child timesheet entry, and the post has disappeared. Regards John
-
Issue with a formula
Hi I have an issue with a formula wich extract the first word of a coumpound word : substr(Nom, 0, index(Nom, " ")) That works perfectly but not with one name.…
-
Sort Dynamic Choices
Hi, Is there a way to sort the new Dynamic Choices, they currently appear in order of ID but struggling to order them by a field within the record alphabetically / numerically Thanks
-
Activate / Local or cloud database
Hi, I am new to the Ninox area. I have 2 questions: 1. Is Ninox always opened via a browser or can Ninox also be installed on the PC. 2. In 2 courses on the internet, when creating a database,…
-
Help in setting up an accountability system
Hi all, We are trying tset up an internal "accountability system" for our Ninox, and I might use some technical help to figure out what's the best way to implement it.…
-
Hi, How do I check if the current Year has changed?( I want to reset a counter on the first record of the new year)
let i := last((select Projects).'P#'); let lDate := last((select Projects).'Created on'); if i = null or year(today()) > year(lDate) then i := 1000; 'P#' := i + 1 else 'P#' := i + 1 end
-
Email sender
I have created a button to automatically send an email.However, I have the problem that the sender I am using is not the email I use in the Ninox account.Is there any way to use this mail?
Answer questions and share your knowledge