Skip to main content

Ninox-Documentation

Daniel Berrow

Daniel_Berrow

44
8
0

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

My Posts

Latest Posts

createXLSX

Has anyone managed to figure out how to implement this to your script using the new createXLSX function?
- Daniel_Berrow
- 2 mths ago
- 2replies
- 82
- 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
- 5 mths 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
- 5 mths 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
- 6 mths ago
- Get help
- Reported - view
Re: Multiple attachments with SendEmail
Try attachments: [myAtt, myAtt2]
- Daniel_Berrow
- 8 mths 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
- 8 mths 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
- 8 mths 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
- 8 mths 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
- 8 mths 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
- 9 mths 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
- 9 mths 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
- 9 mths 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
- 9 mths 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
- 9 mths 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
- 9 mths 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
- 9 mths 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
- 9 mths 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
- 9 mths ago
- 1
- Get help
- Reported - view
Re: Work out annual leave days.
try t.text('Work Days')
- Daniel_Berrow
- 9 mths 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
- 9 mths 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
- 9 mths 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
- 9 mths 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
- 9 mths 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
- 9 mths 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
- 9 mths ago
- Get help
- Reported - view

1 2

Back to top

Ninox-Documentation

Overview

View all topics