-
How do you create a Google map with multiple locations?
Hi, I want to integrate into my Ninox database a Google map to display multiple locations. Has anyone been able to come up with a functional solution that could be shared here or at least give me…
- Answered
-
Single Dynamic field that populates other fields
I am replacing some fields that had quirky lookups with a single dynamic field. I have a JobDockets table (related to Customers) ie N:1 - Customers can have many Jobdockets In Jobdockets Table.…
- Answered
-
<span onclick> , Is it possible in a Formula (html) with for from to do loop ?
Hi, I have seen resent posts where span onclick is discussed. I wonder if it is possible to implement this in my example. I intedent do upload this as a DB,…
- Answered
-
Count missing dates
Hey all! I'm back with ANOTHER question. Is it possible to use Ninox to count missing dates? For example: on a timesheet I may work August 1,2,3,4,5,7,8,10,11,12,13,14,19,20,22,23,24,25,26,27,…
- Answered
-
Split Function Help
hi to all! I have got this tables in Ninox: TABLE: Genres Field: Genre TABLE: Masters Field (in error): Genre The field in TABLE Master can have 1 or more Genres,…
- Answered
-
Get the number of the chosen entry in a Dynamic Choise field
Hi, In a normal Choice field you can have a FX field that dispalys the number of the selected choice like this: number(ChoiceFieldName), then the FX displays 0 if emty, 1 for choice1,…
- Answered
-
Symbol experted: ")" at Line 46
@Fred @RoSoft_Steven Hi I have a Symbol experted: ")" at Line 46, column Some idea I reviewed the entire script and it only gives me that error
- Answered
-
Sort json?
Hi everyone - I'm trying to create an HTML table but want to be able to sort it, probably by using a choice field that would modify the order. I can't just sort the select because one of the fields…
- Answered
-
Formula help
Hi to all! i am trying to activate function through a formula to open specific record. this is the formula: html("<button class='customButton' onclick='openMaster()'>Open Master</button> <script>…
- Answered
-
Sum service amounts from three tables based on dates
Hello. I pay my employees weekly based on how much they bring in for services, products and off-site events (three separate tables) throughout the week. I am using a date field.…
- Answered
-
Trigger on open database
if i put this script into a button on a table form it works. do as server for a in select JobDockets where 'Job Bag' <= 13980 do a.(SupplierQuote := null); a.(SupplierConfirmation := null); a.…
- Answered
-
Sum Based on Choice
Trying to add up all totals from multiple records based on a choice. Data Base is called Receipt Details. When I choose a month, for example OCT under Statement Month,…
- Answered
-
Script problem.
do as server let me := this; for i in select 'Task templates' do let new := (create Tasks); new.( void; Status := 1; 'N1 Main Table' := me; 'Assigned Date' := date(year(me.'Start date'), month(me.…
- Answered
-
Not Exit from a loop
Hi to all! i have got this loop on a formula: let images := response.result.images; let coverimageLink := ""; let foundImage := false; for i in images do if (i.type = "primary" or i.…
- Answered
-
Need Formula on Chart
I have a multiple selection dynamic let uni := unique(((select Gastos) order by Categorias).text(Categorias)); for i in uni do first((select Gastos)[text(Categorias) = i]) end Copy I need the Formula…
- Answered
-
Work out annual leave days.
Good morning. I hope you brilliant peeps would be able to help me out again please. I am working on the tables in my database for staff. I am trying to work out annual leave. I have 3 tables.…
- Answered
-
Formula to sort month
@Fred Hi Fred. Need to sort the graphic from Jan to Dec, the data is in the Gastos table (the gray data). I try this but don't work select Gastos order by month(this.Mes)
- Answered
-
Create Record Button in a Table > Create R. to a Subtable
Hi, I thougt this would be easy, an that I have done similar before, but now I'm stuck. I Have a table "Placenames" , with a Subtable "Farms_Places", whitch have all the sub-places under the main…
- Answered
-
Yes/No function
Hi, I want to change my multiple choice function to several yes/no functions. All works well but one choice. I want to use a yes/no function (named OHW) to indicate that a client is no longer an…
- Answered
-
Problem with this formula
sum((select Expenses).'Amount Spent' where Categories = "Gas") sum((select Expenses).'Amount Spent' where text(Categories) = 8) Where Categories is a Choice field.
- Answered
-
Beginner scripting resources?
I’m trying to teach myself about scripting commands. But I’m having trouble finding full, complete answers. For example, the Switch Statement. In the Ninox Intermediate Tutorial #3, Switch Statement,…
- Answered
-
Click on button in Ninox to view Gmails
Hi everyone, I'm new to Ninox so forgive me for asking this question. When I'm logged into Ninox and also my Gmail account, I'm wanting to click on a button that searches for all emails related to a…
- Answered
-
Ninox tutorials stopped working?
I'm brand new so had been looking at tutorials here (on this web site). But now, when I select a specific course to view, all I get is a. blank white screen, no window to play the video.…
- Answered
-
Auto-populate Music Library Fields
I am working on databasing all of my sheet music and would like to auto-populate a field on one table with information from two other tables if possible.…
- Answered
Answer questions and share your knowledge