-
HTTP GET JSON response
I am trying to figure out how to pull JSON info from a HTTP GET response. let response := http("GET", url); If the JSON response has both name and values inside " " as if they are all strings,…
-
Save archive as... crashes Ninox
For privacy policy reasons, we cannot use cloud services to save/store our Ninox database. I've been using "Save archive as..." and then "open in" to save it locally using Filr.…
-
Linked tables
Hello, I have a table "Customers" who are linked with a table "Invoices" who have a subtable "Items", when I create a new invoice from "Customers" the invoice are linked to the customer but when I'm…
-
email Attachments
Hi, how can I add cc and bcc in an email? And how can I add more than one attachments at the email? thanks Max
-
How to display subtable of subtable on master table form?
Folks.. Using the project template database as an example, if I add mulitple sub projects to the sample Garden Design project.. and add multiple tasks to each subproject,…
-
delete table
How can I delete a table ?
-
Calculation of dates
Is there a formula that will return a date after a certain number of months, years or days from a given date? For example, If the date entered is June 27, 2005 in Field 1,…
-
Display field only, if: either of two other fields has no data?
What is the formula needed to make this work? The field names I want to check for data are titled Email 1 and Phone 1. I can make the field hidden with either 'Email 1' = null or 'Phone 1' = null,…
-
Tutorial
Hi there, How do you get to "Tutorial – Part 2" ? Regards: JG
-
How do I make a multiple choice box dependent on the value of a specific field?
I have a table with countries and which continent they are on. In a separate table, I have a list of hotels around the world, at the moment I can select the country name and the continent appears -…
-
Dialog box from Update trigger
I cannot get a dialog box to popup if I put it in the 'Trigger After Update' script. I can get an Alert to popup from there - but not a dialog. I can copy/paste the same dialog into a formula or…
-
Multi-page contract
Hi, I'm attempting to set up the print feature to create and print multi-page invoices. I can't seem to get the program to allow me to have more than one page, however. Is this allowed? Thanks!
-
How to add printPdf file on email ?
How to add printPdf file in mail, like filemaker. When press on mail button popup mail with name, subject cet. But how add .Pdf invioce in email.
-
Improved Array Functions
Just an update on Appending Arrays and Replacing Array Items... Append Replace Item
-
Ninox database file on iCloud isn't visible and thus difficult to backup
I am using the Mac version of Ninox on 2 Macs. I have the database file hosted on iCloud. When I look at iCloud storage, I know it is taking up space, but it doesn't show up as file that I can copy…
-
How do you link fields on different tables?
s from two different tables? For example if you had last name on one table and want to link it to last name on the other table?
-
how calculate date from year, week number and weekday?
Date:= year(2019)+week(14)+weekday(0)
-
Embedded charts and views
Has anyone manage to wright a formula to show charts and wiews in a form? Nick
-
How to link add data with a button click
Hello, I have this formula let p := (create Renovaciones);p.(Temporada := "2018-2019"); that let me add the p. to the table Renovaciones. In Renovaciones I have a box for the current user linked.…
-
Select record in a relational field
Hi, I would like to know if it's possible to select a record in a relational field by a text field value. Thanks in advance Max
-
Map image with location field?
Is there a way to automatically insert a screenshot of the map with a location field. I would like to be able to print with a picture of the map next to the location field.
-
Styled formula background
Having some trouble wrapping my head around how to use styled on a formula. I have a yes/no field (Flag Account). If it is unchecked, I want the formula to just use the style I've set in the formula…
-
Can I send a email with the attached file from a specific record
Hello I used the function importFile (see example code) and that works well!In a other step I want to send emails to the customer with the attached file of a specific record (see previous action).…
-
This is driving me crazy
Will someone please test this code in a new database and in the "Global script definitions". I want to know if it works correctly for someone else who hasn't done what I did.…
-
Control to view web page?
Is there a field type or way to display a web page in a form? For example, if you have a customer database and want to display their home page in the form, to have an embedded web view, of course,…
Answer questions and share your knowledge