Daniel Berrow's Profile | Ninox Community

Latest Posts

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
- 2 yrs 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 yrs 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 yrs ago
- Learn and 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 yrs 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 yrs 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 yrs ago
- Get help
- Reported - view
Re: Lookup, referencing.. Help!
Hi Vinson, if you just want a specific record field/are using this in a formula for other information to be populated used let t := this; record('Table B', t.…
- Daniel_Berrow
- 2 yrs ago
- Get help
- Reported - view
Re: Help me LOOP please.
Can I ask why you are looping through this way to try and find something that matches? Is this a search function?
- Daniel_Berrow
- 2 yrs ago
- Get help
- Reported - view
Re: Auto-populate tax depending on another dropdown field selection?
@Taylor Hanson You'll need it in the trigger on update section within "job type" so whenever you pick a job type it then updates your "Tax Test" field
- Daniel_Berrow
- 2 yrs ago
- Get help
- Reported - view
Re: Auto-populate tax depending on another dropdown field selection?
Hi Taylor, There are various methods you could use for this, the option i'd look into is using a switch case…
- Daniel_Berrow
- 2 yrs ago
- Get help
- Reported - view
Re: Conditional formula to calculate 'taxable' and 'non taxable' items...
Hi Taylor, To get it from that record you don't need the select statement, you can just do the formula sum('project details'[tax = false].'job status log') Your formula is summing ALL of the records…
- Daniel_Berrow
- 2 yrs ago
- Get help
- Reported - view
Re: Help on changing record color
@Joaquim Boavida You can add conditional formatting into each of the lines of the view, with a formula function to check if the field is alberto
- Daniel_Berrow
- 2 yrs ago
- Get help
- Reported - view
Re: Help on changing record color
What are you trying to change the colour of? Your script will just return color(green) or color(red) without telling it where to set the colour Rather than have it in an "After Update" trigger,…
- Daniel_Berrow
- 2 yrs ago
- Get help
- Reported - view
Re: How to connect this table
You can have a couple of views, of which one is looking at the composer as a comparison let t := this; select books[composer = t.composer] and you can do a similar thing with titles,…
- Daniel_Berrow
- 2 yrs ago
- Get help
- Reported - view
Re: Conditional formula to calculate 'taxable' and 'non taxable' items...
Based on the image you have, this may work better as a sub-table, with the fields of "Type", "Job Item", "Quote", "Tax", "Total+Tax". You can then have the view show this same data,…
- Daniel_Berrow
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: button for Duplicate a record and its links to a sub table
Are you trying to duplicate a Navire record but reset the options that are linked with it, to then create its own options?
- Daniel_Berrow
- 2 yrs ago
- Get help
- Reported - view
Re: Add space between emails in string
Rather than use a loop, could try using the Concat() function, which by default adds ", " between items, as email addresses need to be comma separated
- Daniel_Berrow
- 2 yrs ago
- Get help
- Reported - view
Re: HTML formatting
let AR := "Artists"; html("<h1 style='border: 0px solid darkslategray; padding: 11px; font-family: Helvetica; font-size: 10px; color: black; text-align: center; cursor: pointer; background-color:…
- Daniel_Berrow
- 2 yrs ago
- 1
- Get help
- Reported - view
API into Image Field

Has anyone worked out a way to fill an image field with a file from a different database using API? The goal is to press button in database A and send the picture to database B without needing to do…
- Daniel_Berrow
- 2 yrs ago
- 3replies
- 208
- 1
- Get help
Re: Hiding the '+' for views
Hi Alan, Don't know if you've managed to sort this yet, but this works html("div.TabsRow_actionsContainer.TabsRow_addContainer{display:none}")
- Daniel_Berrow
- 2 yrs ago
- Get help
- Reported - view
Re: Comments???
Hi, You can do comments in Ninox by surrounding your phrase in #{}# A strange choice from Ninox I know, but it works!
- Daniel_Berrow
- 2 yrs ago
- Get help
- Reported - view

1 2

Welcome to the Ninox community

Daniel Berrow

Re: API into Image Field

Re: Problems with condition statement in a while do structure

Re: Ninox script to work with csv files

Re: Print report with Multiple choice....how!

Re: Print report with Multiple choice....how!

Re: Zapier and Ninox Formula Fields

Re: Lookup, referencing.. Help!

Re: Help me LOOP please.

Re: Auto-populate tax depending on another dropdown field selection?

Re: Auto-populate tax depending on another dropdown field selection?

Re: Conditional formula to calculate 'taxable' and 'non taxable' items...

Re: Help on changing record color

Re: Help on changing record color

Re: How to connect this table

Re: Conditional formula to calculate 'taxable' and 'non taxable' items...

Re: button for Duplicate a record and its links to a sub table

Re: Add space between emails in string

Re: HTML formatting

API into Image Field

Re: Hiding the '+' for views

Re: Comments???

Overview