Fred

San Francisco, USA

3376
533
4

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

My Posts

Latest Posts

Re: Slowly getting a handle on Dynamic Printing
@Mel Charles said: So are you saying that using Carbone Studio means I can get around the designing forms within "ms Word) first! as instructed to do so by Niniox. Sadly that is not what I am saying.…
- Fred
- 3 mths ago
- Learn and Share
- Reported - view
Re: Slowly getting a handle on Dynamic Printing
@Sotirios Zormpas Your dashboard template has shown you are quite adept with coding so you should have no problem adding yet another coding platform.
- Fred
- 3 mths ago
- 1
- Learn and Share
- Reported - view
Re: Dashboard Template
@Sotirios Zormpas Your contributions to the group are most welcome and very appreciated.
- Fred
- 3 mths ago
- 1
- Learn and Share
- Reported - view
Re: Duplicate a sub-table while omitting fields.
@Pascal P. Sorry to hear. If you got an answer please mark the post Answered when you have a moment.
- Fred
- 3 mths ago
- Get help
- Reported - view
Re: Problem organising a report.
If you don't hear from anyone, you may want to consider going to Nioxus for help.
- Fred
- 3 mths ago
- 1
- Get help
- Reported - view
Re: Duplicate a sub-table while omitting fields.
@Pascal P. I just tried it on my iPad and: newRecord.('Quote lines'.'quotes #':= null) or something similar, works for me fine. I'm on v3.13.6 and test in iCloud and local DB.…
- Fred
- 3 mths ago
- Get help
- Reported - view
Re: Duplicate a sub-table while omitting fields.
@Pascal P. newRecord.('Quote lines' 'quotes #':= null) doesn't give you and error? It should read: newRecord.('Quote lines'.'quotes #':= null) That should set 'quotes #' to null in all related…
- Fred
- 3 mths ago
- Get help
- Reported - view
Re: Duplicate a sub-table while omitting fields.
Can you post your code for the button?
- Fred
- 3 mths ago
- Get help
- Reported - view
Re: Calculate Cumulative Time with Code
@我是我的我 It doesn't exclude weekends and doesn't take into account years. If you have multiple years then you can use the yearweek() command.
- Fred
- 3 mths ago
- Get help
- Reported - view
Re: Passing Dropdown Value to Another Page
Is Job Setup Page a Ninox Page? Or a Dashboard? Can you post your code from the onclick?
- Fred
- 3 mths ago
- Get help
- Reported - view
Re: Calculate Cumulative Time with Code
I am probably missing something in my suggestion but couldn't you do something like: let thisWeekOrders := (select Orders where Week = 12); let weekDayArray := unique(thisWeekOrders.…
- Fred
- 3 mths ago
- Get help
- Reported - view
Slowly getting a handle on Dynamic Printing

I've been playing around with Carbone studio to get a better handle on how to work with Dynamic Printing and have come up with the following: The dynamic bits of it are the Year and everything in the…
- Fred
- updated 3 mths ago
- 9replies
- 131
- Learn and Share
Re: Formula returning a record causes type mismatch
Ninox has two ways to reference records, one through the table and record Id (called nid), and one with just the record Id (called rid). When you do a select, Ninox will return a nid.…
- Fred
- 3 mths ago
- Get help
- Reported - view
Re: calculate stock
My guess is it had something to do with where you put the sum() and number() commands. I put this in a formula field in Fakturalinier Materialer: let getAllRecs := (select 'Fakturalinier Materialer');…
- Fred
- 3 mths ago
- Get help
- Reported - view
Re: calculate stock
can you post a sample DB?
- Fred
- 3 mths ago
- Get help
- Reported - view
Re: Show value in Choice (dynamic)
@iliper LTD Good start. Can I recommend that you look at your previous post where you learned about the record() command. Here is the link again.
- Fred
- 3 mths ago
- Get help
- Reported - view
Re: Show value in Choice (dynamic)
Take what you learned in your previous post and extend it to the new subtable. Post your code, if it works or not and we can help troubleshoot.
- Fred
- 3 mths ago
- Get help
- Reported - view
Re: Formula for deriving the value
Since Salary is dynamic choice field you can use the record() command to get that record and then you have access to all of the data. record(Salary,number('Choice (dynamic)')).Number1
- Fred
- 3 mths ago
- 1
- Get help
- Reported - view
Re: Dynamic Choice/Multi-Choice
@RoSoft_Steven Wow, that would be awesome. I haven't heard anyone talk about this yet.
- Fred
- 3 mths ago
- Get help
- Reported - view
Re: Dynamic multi-selection in the subform: Display of selected and unselected items.
Forgot the part of showing the data: let selected := unique(Table1.numbers(multichoicefield)); let allPossible := select tableroot; let notSelected := allPossible[(var v := this; not selected[= v])];…
- Fred
- 3 mths ago
- 1
- Get help
- Reported - view
Re: Duplicate a quote a change its number
Depending on how many fields that need to be duplicated, you can always put the Quote# code into your button so it will do the exact same thing as when you create a new record.
- Fred
- 3 mths ago
- 1
- Get help
- Reported - view
Re: Trigger on create with numeric fields
@Mario Cuzzi can you post screenshots of the edit fields window for each table?
- Fred
- 3 mths ago
- Get help
- Reported - view
Re: Trigger on create with numeric fields
Can you post a sample DB?
- Fred
- 3 mths ago
- Get help
- Reported - view
Re: Trigger on create with numeric fields
Just to verify that Monto and 'Monto Prov' are actual number fields and Fecha in both tables are date fields.
- Fred
- 3 mths ago
- Get help
- Reported - view
Re: Dynamic multi-selection in the subform: Display of selected and unselected items.
Well that was dumb of me, you said so in your post. First step is to get a list of selected choices. You can try: unique(Table1.text(multichoicefield)) This will show you the dynamic value name of…
- Fred
- 3 mths ago
- 1
- Get help
- Reported - view

1 8 9 10 11 12 136

Welcome to the Ninox community

Fred

My Posts

Re: Slowly getting a handle on Dynamic Printing

Re: Slowly getting a handle on Dynamic Printing

Re: Dashboard Template

Re: Duplicate a sub-table while omitting fields.

Re: Problem organising a report.

Re: Duplicate a sub-table while omitting fields.

Re: Duplicate a sub-table while omitting fields.

Re: Duplicate a sub-table while omitting fields.

Re: Calculate Cumulative Time with Code

Re: Passing Dropdown Value to Another Page

Re: Calculate Cumulative Time with Code

Re: Formula returning a record causes type mismatch

Re: calculate stock

Re: calculate stock

Re: Show value in Choice (dynamic)

Re: Show value in Choice (dynamic)

Re: Formula for deriving the value

Re: Dynamic Choice/Multi-Choice

Re: Dynamic multi-selection in the subform: Display of selected and unselected items.

Re: Duplicate a quote a change its number

Re: Trigger on create with numeric fields

Re: Trigger on create with numeric fields

Re: Trigger on create with numeric fields

Re: Dynamic multi-selection in the subform: Display of selected and unselected items.

Overview