Skip to main content
Ninox-Website
Ninox-Documentation
How to enable Javascript
Sign Up
Log in
Learn & Share
Get help
Webinars
All topics
Contact
Privacy
Overview
Profile
Daniel Berrow
Daniel_Berrow
40
8
0
Joined: 21 Jun 2023
Follow
My Posts
Latest Posts
Re: Multiple attachments with SendEmail
Try attachments: [myAtt, myAtt2]
Daniel Berrow
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
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
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
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
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
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
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
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
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
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
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
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
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
Daniel_Berrow
1 mth ago
1
Get help
Reported - view
Re: Work out annual leave days.
try t.text('Work Days')
Daniel Berrow
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
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
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
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
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
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
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
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
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
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
Daniel_Berrow
2 mths ago
Get help
Reported - view
1
2
Ninox-Website
Ninox-Documentation
Overview
Learn & Share
Get help
Webinars
View all topics