Fred

San Francisco, USA

3401
539
4

Joined: Thu Feb 06 18:42:57 UTC 2020

My Posts

Latest Posts

Re: Really dumb .... just want to add 2 number fields together and display total in a 3rd field.
Is your third field a formula field? If it is then you can do something like: field1name + field2name If it is number field then you can put this in Trigger after update of field2,…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: double click in a cell puzzle.
When I double click, in the MacOS app or browser, the record quickly pops out but disappears just as quickly. I don't have any issues with it not allowing me to edit inline.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Pass current viewing record Id to a view element column formula
I found that moving in this direction would just move the load onto the other tables and make those tables slow to respond. So I've moved away from this and now use use the record() command to get…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Total of the selected option
This line: cnt((select Albums)[myObject]) doesn't make sense. Why are you doing a select again? The variable myObject is the result of your filter so you only need that variable in the cnt() command.…
- Fred
- 1 yr ago
- Get help
- Reported - view
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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 1 yr ago
- Get help
- Reported - view
Re: Creating a Script Similar to Excel NETWORKDAYS
Check out this post.
- 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
- 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
- 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
- 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
- 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
- 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
- 1 yr ago
- Get help
- Reported - view

1 57 58 59 60 61 137

Welcome to the Ninox community

Fred

My Posts

Re: Really dumb .... just want to add 2 number fields together and display total in a 3rd field.

Re: double click in a cell puzzle.

Re: Pass current viewing record Id to a view element column formula

Re: Total of the selected option

Re: Auto-populate pricing from another table?

Re: Updating related fields

Re: Updating related fields

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

Re: Count of records in joined table

Re: NEWBIE - CONFIGURING ONE-TO-ONE AND AUTO UPDATING

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

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

Re: Ninext project

Re: Ninext project

Re: Ninext project

Re: Search by Artist ? HTML

Re: Solutions are there for small hotels

Re: Solutions are there for small hotels

Re: Creating a Script Similar to Excel NETWORKDAYS

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

Re: Solutions are there for small hotels

Re: Solutions are there for small hotels

Re: Solutions are there for small hotels

Re: Created On - Duplicate Records

Re: Created On - Duplicate Records

Overview