Daniel Berrow

Daniel_Berrow

Joined: Wed Jun 21 15:10:21 UTC 2023

My Posts

Latest Posts

Re: Ninox 3.13 available
@Paul Chappell Same here
- Daniel_Berrow
- 8 mths ago
- Learn and share
- Reported - view
Re: Hiding new icons etc.
div.Container-dqubpQ.cupfZa{display:none} They've changed a lot of the HTML tags they used for the UI, hope this helps!
- Daniel_Berrow
- 8 mths ago
- 1
- Get help
- Reported - view
createXLSX

Has anyone managed to figure out how to implement this to your script using the new createXLSX function?
- Daniel_Berrow
- 1 yr ago
- 3replies
- 200
- Get help
Re: Inquiry about Generating PDFs and Sending Them via Email in Ninox
A bit outdated, but concept is still the same for PDF creation https://docs.ninox.com/en/tutorial/independent#printing-records and find here how to send emails https://docs.ninox.…
- Daniel_Berrow
- 1 yr ago
- Get help
- Reported - view
Re: Importing Data into a Dynamic Choice Field
A dynamic dropdown works using the record's ID from the table you're pointing it to, so to import data into it you'll need to use the record ID from that table,…
- Daniel_Berrow
- 1 yr ago
- Get help
- Reported - view
Re: Send emails with attachments with Gmail via Make
Try using the shareFile() function on your attachment, add a text field to store this in textField := shareFile(attAllDocs) then in the data use the text field let donnees_api := { RecordID: ID,…
- Daniel_Berrow
- 1 yr ago
- Get help
- Reported - view
Re: Multiple attachments with SendEmail
Try attachments: [myAtt, myAtt2]
- Daniel_Berrow
- 1 yr 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
- 1 yr 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 yr 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 yr 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 yr 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 yr 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 yr 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 yr 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 yr 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 yr 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 yr 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 yr 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 yr 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 yr ago
- 1
- Get help
- Reported - view
Re: Work out annual leave days.
try t.text('Work Days')
- Daniel_Berrow
- 1 yr 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 yr 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 yr 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 yr 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 yr ago
- Get help
- Reported - view

1 2

Welcome to the Ninox community

Daniel Berrow

My Posts

Re: Ninox 3.13 available

Re: Hiding new icons etc.

createXLSX

Re: Inquiry about Generating PDFs and Sending Them via Email in Ninox

Re: Importing Data into a Dynamic Choice Field

Re: Send emails with attachments with Gmail via Make

Re: Multiple attachments with SendEmail

Re: Help please to finish database - Xero/Ninox link

Re: Please teach me how to use this global function :-)

Re: Open Record based on UserName

Re: Open Record based on UserName

Re: Please teach me how to use this global function :-)

Re: Count missing dates

Re: Spinning circle most of the time

Re: Count missing dates

Re: Work out annual leave days.

Re: Symbol experted: ")" at Line 46

Re: How to copy PDF file from Image field to new record.

Re: How to copy PDF file from Image field to new record.

Re: Mirror tables in different databases

Re: Work out annual leave days.

Re: Work out annual leave days.

Re: Problem with this formula

Re: Problem with this formula

Re: Beginner scripting resources?

Overview