Skip to main content
Forum
Privacy
Contact
How to enable Javascript
Sign Up
Log in
Welcome to the Ninox community
Search all topics or
ask a question
Learn and share
Get help
Service status
Documentation
Solutions
Setup
Databases
Automation
My account
Administration
Webinars
Overview
Profile
Fred
Fred
San Francisco, USA
3616
572
5
Joined: Thu Feb 06 18:42:57 UTC 2020
Follow
My Posts
Latest Posts
Re: Conditional formula to calculate 'taxable' and 'non taxable' items...
@Taylor Hanson said: In this case all the of the toggles are turned off, so the items in that column should total $608. For some reason (sorry, I know the red wrench is covering it) the total says…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Conditional formula to calculate 'taxable' and 'non taxable' items...
@Taylor Hanson said: However, I'm still getting the same issue. Right now my current job number is 1224, and when I add a new job it becomes 12241, instead of 1225.…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Ninext project
@Jacques TUR I was wondering if you have any documentation on how to use the debug() function of Ninext? I have a dashboard that is really slow so I would like to try to figure out where the problem…
Fred
Fred
1 yr ago
Learn and share
Reported - view
Re: Ninext project
@Jan Augustin Funny, those were my thoughts (developer side vs. functionality side) after I clicked Reply. Look forward to the documentation.
Fred
Fred
1 yr ago
Learn and share
Reported - view
Re: Ninext project
@Jacques TUR You have been really busy. I know people have been asking for the field copy/duplicate function for a long time. Sadly, since Ninext is not officially supported it is hard for people to…
Fred
Fred
1 yr ago
Learn and share
Reported - view
Re: Search by Artist ? HTML
Do you want to keep the search by Rating as well? Do you want to the two searches linked or are they unique searches? Meaning, you can search either by Artist, or by Rating or both.…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Solutions are there for small hotels
@iliper LTD said: That's why we decided to create it ourselves, and it will do what we need. But all of the skills learned in your casino DB carries over to the hotel DB.…
Attachment
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Solutions are there for small hotels
If I remember correctly you do these things in your other DB. Why don't you give it a try and I'll help troubleshoot.
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Creating a Script Similar to Excel NETWORKDAYS
Check out this post.
Fred
Fred
1 yr ago
Get help
Reported - view
Re: button for Duplicate a record and its links to a sub table
If you had a button in the Navire table, it would look something like: let t := this; let newRec := duplicate(t); for loop1 in t.Options do let newOp := duplicate(loop1); newOp.…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Solutions are there for small hotels
@iliper LTD said: Do we need another table where all the data will be shown? or will everything be here? Take a look at my first comment. There are two data tables (Rooms and Reservations).…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Solutions are there for small hotels
Sorry to keep posting, but here is a simpler code: let getPast2MonthResv := 'Select a Room'.Reservations[var d := SDate; d > today() - 60 and d < today()]; let getActiveResvDays :…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Solutions are there for small hotels
The first part is an interesting question. Here is one way. I have two tables (Rooms and Reservations) and a Dashboard. On the Dashboard there is a reference field to Rooms called 'Select a Room'.…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Created On - Duplicate Records
I was able to duplicate it on my MacOS app(v3.9.3). Sadly this is probably a limitation of the app. I notice that it doesn't keep track of the creation date so you if you don't track it to start with…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Created On - Duplicate Records
Which platform are your using (browser, MacOS app, mobile app)? When I did it in my browser it works fines.
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Need Script for calculating workdays between 1st record, 2nd record, so on.
@Dave Irving Ok, now we do a bit of troubleshooting. 1) verify that "y" has the record Ids that match. You can do the following in another field: let x := (select Leads); let y :…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Choice field repeat the value of the previous day
@iliper LTD let t := this; let oldData := last('Daly result' order by Date); let newRec := (create 'Daly result'); newRec.( 'LIST OF PLAYERS' := t; Category := oldData.…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Choice field repeat the value of the previous day
iliper LTDForget for a second the category field, You want to also link the parent record to the new Daily Result record as well. If you look in the Daily Result table you will see the new records…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Choice field repeat the value of the previous day
@iliper LTD said: Fred I saw it, but didn’t understand how to do it ) Parent Record - what should I write there? You show a screenshot of a record that has the 'Daily Result' table in it.…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Choice field repeat the value of the previous day
@iliper LTD did you see my recent post about adding the linking to the parent record?
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Choice field repeat the value of the previous day
I forgot to add the part of linking it to the parent record. let t := this; let oldData := last('Daily Result' order by Date); let newRec := (create 'Daily Result'); newRec.…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Choice field repeat the value of the previous day
@iliper LTD can you upload a sample DB?
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Choice field repeat the value of the previous day
This is so that you can track changes in client category, without going into the table. Well then you just need to figure out which record you need to pull the data from.…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Choice field repeat the value of the previous day
@iliper LTD said: I created a button outside the table to create a new record and then in the table, but it didn’t work. Create the button in the table that has the Category field,…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Need Script for calculating workdays between 1st record, 2nd record, so on.
For median you can try something like: let mynumber := ((select 'My table') order by Number).Number; let mycnt := cnt(mynumber); let mymedian := if even(mycnt) then (item(mynumber,…
Fred
Fred
1 yr ago
Get help
Reported - view
1
66
67
68
69
70
145
Ninox-Website
Overview
Learn and share
Get help
Service status
Documentation
Solutions
Ninox E-Invoice
Setup
Installed apps
Public Cloud
Private Cloud
On-Premises
Databases
Tables
Table relationships
Fields and elements
Pages
Views
Import and export
Modules
Printing
Templates
Use cases
Automation
Performance
Scripting
Functions
API
My account
Subscriptions
Administration
Manage workspaces
Manage collaborators
Access permissions
Usage overview
Process monitor
View all topics
