-
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?
-
Removing duplicate fields (emails as example) solution
for i in select Table_Name.Email_field do while cnt(select Table_Name where Email_field = text(i))!=1 do delete last(select Table_Name where Email_field = text(i)) end end Enjoy!
-
Required fields
May I suggest the following: If a field is set to be "Required", the form should not be close-able until a value is set/chosen - just like on web-site forms:…
-
extractx() “g” flag workaround
Here is a basic UDF for extracting all of the values that match a regex pattern... function extractxg(src : text,regex : text) do let extValue := “”; let idx := 0; let idxLen := 0; while testx(src,…
-
Creating an address block from different fields
I have a shipping table with different fields for address components (line 1-4, city, state, post code) I can create a block showing the address without the if formulas,…
-
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"…
-
Are there Trigger limitations?
I have a DCF (DMCF?) where a "Trigger after update" has the code: 'V.Välj Region' := ""; 'V.Välj Distrikt' := ""; 'V.Land' := text('V.Välj Land') it does't work BUT if I have the code: 'V.…
- Answered
-
CSV Import not working on Mac App
I used to use the cloud version of Ninox to all my databases and used to import data via a CSV file. Recently i moved from the cloud version to the Mac App.…
-
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,…
-
Short Contributors Bio
Hi All I'm pretty new to this forum, and to Ninox. I see the same names contribute their knowledge to us all (thank you) and I wonder if they (you) would be willing to give a bit of background about…
-
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…
-
PDF with carbone and OCR-recognition
Hi I have used Carbone to create a fillable PDF created from Ninox. You can add values to it and then send it back. (email?). If the PDF is saved in an image field of the corresponding record,…