blackie

Joined: Sun Jul 01 20:40:51 UTC 2018

My Posts

Latest Posts

Re: How to add buttons that create new records or search records in a table
That should be what the third line does. NN.(LEADER := myID); It sets the reference NN.LEADER in the new IMAGES record to point to the record ID of the LEADER record where the the script is run.…
- blackie
- 6 yrs ago
- Get help
- Reported - view
Re: How to add buttons that create new records or search records in a table
it is number(NN.Id) It is getting the record ID of the newly created record as a number.
- blackie
- 6 yrs ago
- Get help
- Reported - view
Re: How to add buttons that create new records or search records in a table
it is number(NN.Id) It is getting the record ID of the newly created record as a number.
- blackie
- 6 yrs ago
- Get help
- Reported - view
Re: How to add buttons that create new records or search records in a table
Maybe also change the first line to let myID := number(Id); But I don't have to do that.
- blackie
- 6 yrs ago
- Get help
- Reported - view
Re: How to add buttons that create new records or search records in a table
Maybe also change the first line to let myID := number(Id); But I don't have to do that.
- blackie
- 6 yrs ago
- Get help
- Reported - view
Re: How to add buttons that create new records or search records in a table
Hmm... in the line NN.(LEADER := myID); LEADER is the name the reference back to the LEADER table. I think be default the link back is named the same as the table,…
- blackie
- 6 yrs ago
- Get help
- Reported - view
Re: How to add buttons that create new records or search records in a table
Id is fixed for every record. NN can be whatever you want. In my case it stands for new note. It is a variable that is only used in the button script.
- blackie
- 6 yrs ago
- Get help
- Reported - view
Re: How to add buttons that create new records or search records in a table
I have a table named Plants, and it has a subtable name PlantLog. This is the script I use on a button on the Plant form to create a new record in PlantLog.…
- blackie
- 6 yrs ago
- Get help
- Reported - view
Re: Table Field Listing
With the REST API if you are using the cloud version of Ninox. check out the Get tables section https://ninoxdb.de/en/manual/api/rest
- blackie
- 6 yrs ago
- Get help
- Reported - view
Re: How do I filter out one or more field values?
You would have to show the new formula column in the view, then you can enter the filter formula. The choice and multiple choice field only let you do the radio button filtering.…
- blackie
- 6 yrs ago
- Get help
- Reported - view
Re: How do I filter out one or more field values?
as a workarond you could create a formula that has something like text(contains(concat(text(Type)), "Clock")) Then filter for !="Yes"
- blackie
- 6 yrs ago
- Get help
- Reported - view
Scheduled script execution

It would be useful if Ninox cloud had the ability to schedule a script to run at specific time. Like a cron job.
- blackie
- 6 yrs ago
- 12replies
- 2434
- Learn and share
Re: Bingo Board Strategies
I like this solution. I am using this idea to pack a lot of info into a small space. I was using formulas in the record, but that took up a lot of space.…
- blackie
- 6 yrs ago
- Get help
- Reported - view
Re: How to create a new role In Ninox cloud
And you can create and change user roles if you are in the web app by clicking on a team member on the right side, then looking at "access rights". There is an option there to create a new user role.…
- blackie
- 6 yrs ago
- Get help
- Reported - view
Re: How to create a new role In Ninox cloud
oh, when you do the invite, there is an option to create a new user role.
- blackie
- 6 yrs ago
- Get help
- Reported - view
Re: How to create a new role In Ninox cloud
If you edit a field, it should be under "more options". You assign a user role when you invite the new user to the team.
- blackie
- 6 yrs ago
- Get help
- Reported - view
Re: Color Code a Formula
Also, is it possible to create a formula field that uses styled(), and also opens a record with popupRecord() when it is clicked?
- blackie
- 6 yrs ago
- Get help
- Reported - view
Re: Color Code a Formula
Is it possible to combine html() and styled() in the same formula?
- blackie
- 6 yrs ago
- Get help
- Reported - view
Re: Ho w can I get this software to work with my HP printer? see below
I have had success using CUPS to set up a network printer on a raspberry pi, then created a node.js REST API for printing. Now I can use a HTTP call in Ninox to print product labels.…
- blackie
- 6 yrs ago
- Get help
- Reported - view
Re: Make a Table appear in the Navigation
Take a look at the section Subtables: The Composition Relationship https://ninoxdb.de/en/manual/tables/table-references-and-relations You basically do the opposite of this:…
- blackie
- 6 yrs ago
- Get help
- Reported - view
Re: Help Please
Edit fields new field formula
- blackie
- 6 yrs ago
- Get help
- Reported - view
Re: Make a Table appear in the Navigation
Is Vocational Skills a sub-table of Contact? You can show the sub-table by clicking the triangle to the right of Contact.
- blackie
- 6 yrs ago
- Get help
- Reported - view
Re: Help Please
Use styled() to set the color of text and the background. You can use if statements or a switch case to set the text color based on the experation date.…
- blackie
- 6 yrs ago
- Get help
- Reported - view
Re: Expiry date
You can use a formula, and simply add the number of days to the date. Date + 14 or if it is a date/time date(DateTime) + 14
- blackie
- 6 yrs ago
- Get help
- Reported - view
Re: Expiry date
You can use a formula, and simply add the number of days to the date. Date + 14 or if it is a date/time date(DateTime) + 14
- blackie
- 6 yrs ago
- Get help
- Reported - view

1 2 3 4 5 6 7 8

Welcome to the Ninox community

blackie

My Posts

Re: How to add buttons that create new records or search records in a table

Re: How to add buttons that create new records or search records in a table

Re: How to add buttons that create new records or search records in a table

Re: How to add buttons that create new records or search records in a table

Re: How to add buttons that create new records or search records in a table

Re: How to add buttons that create new records or search records in a table

Re: How to add buttons that create new records or search records in a table

Re: How to add buttons that create new records or search records in a table

Re: Table Field Listing

Re: How do I filter out one or more field values?

Re: How do I filter out one or more field values?

Re: Bingo Board Strategies

Re: How to create a new role In Ninox cloud

Re: How to create a new role In Ninox cloud

Re: How to create a new role In Ninox cloud

Re: Color Code a Formula

Re: Color Code a Formula

Re: Ho w can I get this software to work with my HP printer? see below

Re: Make a Table appear in the Navigation

Re: Help Please

Re: Make a Table appear in the Navigation

Re: Help Please

Re: Expiry date

Re: Expiry date

Overview