Skip to main content

Ninox-Documentation

Daniel Berrow

Daniel_Berrow

40
8
0

Joined: 21 Jun 2023

My Posts

Latest Posts

Re: Multiple attachments with SendEmail
Try attachments: [myAtt, myAtt2]
- Daniel_Berrow
- 12 days ago
- Get help
- Reported - view
Re: Help please to finish database - Xero/Ninox link
Have you tried looking at Make (Formerly Integromat), you can set up API links easily using this between Ninox and Xero
- Daniel_Berrow
- 2 wk ago
- Get help
- Reported - view
Re: Please teach me how to use this global function :-)
@Alan Cooke You added the html(html) to the second function, not the first, it needs to be added to both
- Daniel_Berrow
- 1 mth ago
- 1
- Get help
- Reported - view
Re: Open Record based on UserName
are you already in the last record that they created when you're pressing this? try replacing openRecord with popupRecord to see if it is just pointing to the same record
- Daniel_Berrow
- 1 mth ago
- Get help
- Reported - view
Re: Open Record based on UserName
let t := this; openRecord(last(select Timesheet[Staff.name = t.'created by'])) This is assuming your username is the same as what it is stored as in the staff table, otherwise let t := this;…
- Daniel_Berrow
- 1 mth ago
- Get help
- Reported - view
Re: Please teach me how to use this global function :-)
Looks to me like you can just UIHide("print,trash,add")
- Daniel_Berrow
- 1 mth ago
- Get help
- Reported - view
Re: Count missing dates
You can do it with the fields you have already, though it would be more difficult. You can count the records you have for that month, and then have a formula looking at the first of selected month ->…
- Daniel_Berrow
- 1 mth ago
- 1
- Get help
- Reported - view
Re: Spinning circle most of the time
We had this issue when using 3.10, reverting back to 3.9 has reduced our buffering time significantly
- Daniel_Berrow
- 1 mth ago
- Get help
- Reported - view
Re: Count missing dates
If you have a calendar table with each day in it, you could then link these timesheets to the day of the calendar and count how many records in that month/year do not have a linked timesheet against…
- Daniel_Berrow
- 1 mth ago
- 1
- Get help
- Reported - view
Re: Work out annual leave days.
I missed off a close bracket contains(t.text('work days'), text(weekdayName(date))) = false Give this a try
- Daniel_Berrow
- 1 mth ago
- Get help
- Reported - view
Re: Symbol experted: ")" at Line 46
After the first 2 lines with "Pgr" you have a bracket which is never closed. you have 3 open brackets but only 2 close brackets You've included it on the other lines
- Daniel_Berrow
- 1 mth ago
- Get help
- Reported - view
Re: How to copy PDF file from Image field to new record.
@Marisol Echaide I was trying to make the PDF name unique per record, as sometimes this causes an issue in loop. You may be able to get away with it and just use the formula contab.…
- Daniel_Berrow
- 1 mth ago
- Get help
- Reported - view
Re: How to copy PDF file from Image field to new record.
Try contab.(comprobante := importFile(contab, shareFile(x.Comprobante), contab.text(id) + ".pdf"))
- Daniel_Berrow
- 1 mth ago
- Get help
- Reported - view
Re: Mirror tables in different databases
@giuseppe You can do this via the API tools provided in the documentation You can set up trigger on creation of record to create a record in the mirrored table,…
- Daniel_Berrow
- 1 mth ago
- 1
- Get help
- Reported - view
Re: Work out annual leave days.
try t.text('Work Days')
- Daniel_Berrow
- 1 mth ago
- 1
- Get help
- Reported - view
Re: Work out annual leave days.
let t := this; let cnt := cnt(select Timesheet[date > date(1, 5, 2023)][date < date(30, 4, 2024)][contains(t.'work days', text(weekdayName(date)) = false]) I think this will provide what you're…
- Daniel_Berrow
- 1 mth ago
- Get help
- Reported - view
Re: Problem with this formula
@John Halls Ah yes you're right, I wasn't looking that it was actually trying to do the same thing so i assumed the choice had "8" in the field, my mistake
- Daniel_Berrow
- 1 mth ago
- Get help
- Reported - view
Re: Problem with this formula
You need the "where" within the select statement sum((select Expenses where text(Categories) = 8).'Amount Spent') or alternatively sum(select Expenses[text(Categories)= 8].…
- Daniel_Berrow
- 1 mth ago
- Get help
- Reported - view
Re: Beginner scripting resources?
"True" or "1" are most likely referring to a "yes/no" field, as this can only be either True/1 or False/0 A switch can be done using pretty much any field type you want,…
- Daniel_Berrow
- 1 mth ago
- Get help
- Reported - view
Re: API into Image Field
@Fred The modularity only works within the same workspace from my understanding, I've got databases in different workspaces i'm currently linking between.…
- Daniel_Berrow
- 1 mth ago
- Get help
- Reported - view
Re: Problems with condition statement in a while do structure
Rather than making that a while loop, try a for loop for i in select pagos do let n := (create Pagos); n.(Gastos := g); n.('Asientos por Registrar' := x);…
- Daniel_Berrow
- 2 mths ago
- Get help
- Reported - view
Re: Ninox script to work with csv files
Very Interesting! Didn't know you could comment using --- ---;
- Daniel_Berrow
- 2 mths ago
- Learn & Share
- Reported - view
Re: Print report with Multiple choice....how!
@Kruna Tbh I didn't know if an Icon would work or not I was just trying to copy what was in the original design as much as possible, but i'm sure you can use "" or something similar in place using…
- Daniel_Berrow
- 2 mths ago
- Get help
- Reported - view
Re: Print report with Multiple choice....how!
@Alan Cooke You can try using contains if contains(numbers('video tests'), 1) then icon("check") or if contains(text('video tests'), "Display Image") then icon("check") something along these lines…
- Daniel_Berrow
- 2 mths ago
- Get help
- Reported - view
Re: Zapier and Ninox Formula Fields
If you're trying to get Ninox -> Zapier, then copy the formula script into your button as a variable to send let x := "INSERT FORMULA CODE" Then send it as you would any other variable.…
- Daniel_Berrow
- 2 mths ago
- Get help
- Reported - view

1 2

Back to top

Ninox-Documentation

Overview

View all topics