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
3747
594
5
Joined: Thu Feb 06 18:42:57 UTC 2020
Follow
My Posts
Latest Posts
Re: Auto-populate pricing from another table?
What you need is a reference field in Project Details that points to Job Pricing. You can call it whatever you want in Project Details, but let us leave it as Job Pricing for now.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Updating related fields
@John Wilmans said: I have tried to have a way (using the inventory form) where a hostess can go in and use a bottle of wine on the charter and then update the table from that form.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Updating related fields
I would like to be able to add the drinks etc to their table so I can keep a record of: their charter, which boat they were on and what they ate and drank. This can be done.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Conditional formula to calculate 'taxable' and 'non taxable' items...
@Taylor Hanson said: - Create some kind of price table in Ninox. I don’t bill per hour, instead per job. So I’m imagining a list of jobs varying in price/mapping to the client type,…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Count of records in joined table
You must have a N:N (many to many) table linking Event Details with Staff, what is the name of that table? That N:N table should show up in your staff table so you can do a count of the reference…
Fred
Fred
2 yrs ago
1
Get help
Reported - view
Re: NEWBIE - CONFIGURING ONE-TO-ONE AND AUTO UPDATING
Welcome to Ninox. As@simon said, you probably don't need another table since Radio Net Operators. Like you said, the two tables would have a 1:1 relationship which makes me wonder why create a…
Fred
Fred
2 yrs ago
Get help
Reported - view
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
2 yrs 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
2 yrs 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
2 yrs 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
2 yrs 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
2 yrs 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
2 yrs 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
2 yrs 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
2 yrs ago
Get help
Reported - view
Re: Creating a Script Similar to Excel NETWORKDAYS
Check out this post.
Fred
Fred
2 yrs 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
2 yrs 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
2 yrs 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
2 yrs 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
2 yrs 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
2 yrs 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
2 yrs 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
2 yrs 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
2 yrs 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
2 yrs 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
2 yrs ago
Get help
Reported - view
1
71
72
73
74
75
150
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
Backups and storage
Process monitor
View all topics
