-
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:…
-
Copying data from one table to another with conditions attached
Hi, Can anyone please offer me advice on the coding. I have a csv file from our supplier with product information. This file changes regularly so there might be new lines or prices might be updated.…
-
choice values from table?
Hi, is it possible to create a multiple choice field where the choice values refer to another table. In my case I want to add multiple keywords (which could be easily done with a multiple choice…
-
Next Version / Beta Site Question
Is the next.ninox.com still used for upcoming changes to the product? If changes are made to that site, is there a list somewhere for testing? I'm always curious as to what might be in the works,…
-
Global Popup ;lert
Okay probably a daft question but does anyone know or has suzzed out if a global popup can be done? I have and internal mailbox form to share by users so based on a particular user who is logged in -…
-
Filemaker related database import issues
Hello I am trying to migrate several relational databases that I have in FileMaker. In my case are databases of a music auditorium. In one base I have the concerts and in differentes bases I have the…
-
Forum usage
Hi all. Is there a way for me to see my (recent) posts in the forum? Thanks!
-
Tab key usage
Hi all. I have a form to do data entry. Form consists of three fields: a date field, a text field and a rich-text field. In that order on the form. Hitting the tab key takes me from the date field to…
-
illusion of Inserting new lines into middle of child table ((invoice/order/quote) lines)
I have been looking at the issue of child tables when used within say invoice/order/quote body. I have parent table (Quotes) and child table (QuoteLines) Each quote may typically have between 1 to 10…
-
Formula Field for Date Calculation showing time as well
I've created a Formula field to determines the "Days until Date" which is working great however the output include the time could down as well "18 Days 14:23:00.…
-
Advice on how to make Field List of Dates
I've got a list of dates that payments are due in a subform. For example if a person has a receipt and that's receipt includes a number of ship dates, one for each line item I'd like to show in a…
Answer questions and share your knowledge