-
Timecard employees
Hi, I have two employees, the first works 8 hour per day monday to friday (simple), the second works 4 hour per day except Wednesday that works 8 hours.…
-
Confronting the spam bots
Hey guys, I saw that one of these ads in the forum had a live chat, so I talked to someone on there regarding the big spam in the forums. Hopefully they can do something about it and not ignore the…
-
Issue with ID
Let me better explain: I have created a formula formula to order my price quotation that goes like: “AR” + ID + “” + yearmonth(today()) + “D” (result this month:AR12020/11D).…
-
Would someone please tell me what i“m doing wrong here?
I“m using this formula: let Open := select Tracker where this(Symbol) = Symbol and this(Expires) = Expires.Total; Total + Open First problem is that i get this message: ”End expected:…
-
Sequential numbering
I“m trying to get each entry on a suitable to be numbered 1-2-3 etc each time a new instance of the subtable is created. So, the main table represents a ”Job“ and each entry on the subtable…
-
Custom layout for Cards view
Is there a way to remove the field labels in Cards view? I don't need to see Name: The name. I just need the field data displayed. Also, I have a multiple choice field,…
-
Calendar Name/Title selection
My items are appearing in the calender however can you control what the “title” or event name or what you call the short display name? I usually get a combination of fields which can be unobvious…
-
Selecting date from does not appear to work only for November 1st, 2020
There are many instances in the app where we need to select the previous date“s entry and populate - Example; populate with yesterday”s meter readings. Originally,…
-
Move to field using Trigger after update
A simple I know but I'm brand new at coding in Ninox. I have a field 'Manufacturer' and a field 'Model Number'. I pick a manufacturer and then the model number in two steps.…
-
Import keyed on multipl linked fields
There is a Table 1 “Responses” that refers to Table 2 “Clients” and Table 3 “items” and has a text field “Response”. I want to import data in to the table “Responses” that has Client_Name | Item Name…
-
What is the formula to specify a time range in a calculation?
Is anyone able to help with this? Each record has a date and a value, and I wish to calculate the SUM total of that value within a range of dates (e.g. by month). Many thanks Ben
-
First and last name in a field
If I import a list where first name and last name are in the same field, can I extract automatically the two names in two distinct fields?
-
Fonts in a text box
For example, I'm formatting an invoice template. I make a text box and I need Helvetica Neue Ultralight which is installed on my mac under Helvetica Neue.…
-
Any way to change the Font default? (also in RTF)
I couldnt find any place where this can be done.... I am referring to the overall database (eg set the default font) or more important for me now in some fields eg RTF... RTF has H1, H2 etc..…
-
Host a Ninox DB on my server?
I cnanot get Ninox and iCloud to work together as they are suppose to. My DB with 930 records and many photos will NOT function on my iPhone or iPad. I have spoken with support and so far no solution.…
-
Multiple Dialog Threads On One Button
Hi Everyone, I have tried desperately to program a button to execute a different dialog thread based on the selection of a multiple choice field. I can't get it to work!…
-
How to attract attention if there are attachments
Hi all. If a record has attachments (in the attachment tab, not in picture fields), I'd like to make that fact known graphically. I tried to change the color of the "Attachment" tab, without success.…
-
Time Interval wrong calculation
Hello. I've set the code to calculate the time interval between a dropoff and a pickup. The formula works but for some reason it adds 1 extra hour to the correct calculation..…
-
Triggering Record Creation on another Table
I am looking to create a formula to achieve the following scenario: I have one table called clients - self-explanatory list of clients I have one table called items I have one table called…
-
Simple delete button for the current record
How can i create a simple delete button for the current/open record? Layout element > button > formula Many thanks, Maarten
-
How to create formula to display sum of expenses for a specific month?
Hello I am doing some end of year accounts; so far I have a table that displays the total spent over the whole year for each budget head - that“s the easy bit.…
-
App IOS crashes
A few weeks ago the ninox app on both ipad and iphone, both updated to IOS 12.4, crashes as soon as it's open. why?
-
Can I attach invoice to email and send via a trigger from the email icon
I have created an invoce sheet and want to be able to emailthe invoice directly to the customer via the email icon. can this be scripted to act as a trigger in the invoice sheet?
-
Show Sub-Table IF choice field is equal to... Not working!
Hi there, So I am completely lost and have tried every text and visual editor function known to mankind (I think at least).. But what I am trying to accomplish is this:…
Answer questions and share your knowledge