-
The CRM Ninox Hero Webinar with Employees, Deals, and Companies
I saw the Ninox demo from 2011 which went through setting up a basic Ninox application with. In that demo, however, in the "Deals" area, only one linked employee is ever shown.…
-
Save record as PDF
I have created a print layout for my invoice records. Is there a way to reference this view in code so I can create a pdf via a button on the form view of the record instead of going through all the…
-
Client vs Server script differences
Hello all I am building a system for someone and have run into a quirk. As an example, if I have a table called Parent and a child called Child, and both have a number field, Number.…
-
Default Value problem
I would like to ask you if you could undestand the reason why I can't set a default value to my numeric fields. Thanks!
-
Is it possible to trigger code on a timer?
For many use-cases it would be useful to be able to trigger code based on a timed event (i.e. 12pm every day) - or triggered by a date field (i.e. date/time = now). Is this in the roadmap?
-
How to update a field with a lookup value from another table?
In the image above, I have selected an employee from the Employee table via pop-up. Now, however, I want to populate the "emp_fk" field in the Tasks table with the Employee's "emp_pk" field from the…
- Answered
-
Aggiornamento del calendario
Bisogna aggiornare le opzioni del calendario, non è possibile per noi abbonati avere un calendario così debole. Forza Ninox !!!!!!!
-
Button to open calendar
Quando creo un appuntamento tramite un modulo ho bisogno di visualizzare il calendario per cercare una fascia oraria disponibile, come posso aprire il calendario e magari anche ridimensionare la…
-
Delete record if fieldA := fieldB
Hi, is there a way to completely delete the current record if a formula field results in a specific value or equals another given field?
-
How to create a 1:M display?
In the display above, I've attempted to show the tasks for each employee (M:1). Although the tasks for this employee shown at the bottom are correct, the possibly many tasks display isn't a "grid"…
-
Jump to tab from a View
Hi, is there a way to clicking on the result of a view field (which shows the results of records from another table) and jump to that record in a specific tab? (But only from this view)
-
Date of value specific changing
Hello ! I'm looking for how i can get the date of when a value is becoming negative. I'd tried this code : "if 'Value' <= 0 then today() end" but the function today() returns the date of the present…
- Answered
-
SMS/text function?
Is is possible to have a field function that initiates an SMS/text message? It would be separate from the phone number field/button. Similar to what happens now with the phone or mail button,…
- Answered
-
Table Reference Confusion
I created a table reference between employees and invoices. I get the error in the data modeler. But when I add the field to the employee first name (from employee table) to the invoices table,…
-
Searching not working as expected (new to Ninox)
I have a column with a Status. It has values like Complete, Partially Complete, etc. I just want to show the values where it's "Complete", but I can't figure out how to enter that in the search…
-
Ninox Not Syncing with iCloud
I downloaded the iCloud Ninox app, but it doesn't see the Ninox databases that are in my iCloud account. The only (apparently non-synching) way I can get the data on iPhone is to save an archive.…
- Answered
-
How to store binary data like PDFs?
What kind of field supports storing PDFs or other Binary data? Am I able to see a thunbnail of the PDF in a form or view? Thanks
-
How to create balance table from income and expense tables
Hi. I have two tables: 1. Income table - consisting of several fields and a formula named "total income"2. Expense table - with "expense amount" field. How can I create a balance table that will show…
-
database wide variables
I'm a teacher, and a lot of the formulas/views/filters are based off the current school year. Multiple times I reference either a students grade, the current school year, the current trimester etc.…
-
Working with REST Services?
In FileMaker, there is an "INSERT FROM URL" script step that lets you connect to a REST service using GET, POST, or whatever. You then can set the return value from that service (could be binary,…
-
Joining text strings with carriage return
I have a clients table where each record has several address fields. Eg. address 1, address 2, city, state, post code, country. I want to join these fields into a single multi-line address but…
-
# of linked records in LINK FROM fields and VIEW fields
Another question: How can I access in code the # of records linked in a particular LINK FROM field? How can I access in code the # of records in a VIEW?
-
LINK FROM tables
If I link a record from another database using a LINK FROM table as above. How can I access that linked record in code? Or to multiple records linked this way?
-
Populate a Related field
I need to populate a related selection field (consignee) based on the value previous selected in other selection field (entity). The consignee selection field will have various values available…
-
Not to update a field after completed
Is it possible to block a field after it is change or writen after first time? I mean, I dont want to be able to update it.
Answer questions and share your knowledge