Fred's Profile | Ninox Community

Badges

Latest Posts

Re: v5 of Carbone in Beta
I think I am mistaken about not needing an external editor. All their v5 documentation references LibreOffice and Word, so I guess that is not going away.
- Fred
- 1 yr ago
- Learn and share
- Reported - view
v5 of Carbone in Beta

Hi all - Just saw that Carbone announced the beta of v5. With the big announcement of: Designer Assistant: This is the main part of the studio where you can test, debug, and build your templates.…
- Fred
- 1 yr ago
- 2replies
- 77
- Learn and share
Re: Passing Dropdown Value to Another Page
@shane You can try something like this in the onclick of the Method Statement button. let t := this; let otherPage := record('Job Setup',1); otherPage.('Choose Job to Edit' := number(t.…
- Fred
- 1 yr ago
- 2
- Get help
- Reported - view
Re: Not all fields showing
Are you talking about the Table View mode? If you added fields after the initial table creation then you will need to manually add columns (aka fields).…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Slowly getting a handle on Dynamic Printing
@Mel Charles I would definitely move over to Carbone as the built-in print module is not getting any updates with too many limitations.
- Fred
- 1 yr ago
- Learn and share
- Reported - view
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
- 1 yr 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
- 1 yr ago
- 1
- Learn and share
- Reported - view
Re: Dashboard Template
@Sotirios Zormpas Your contributions to the group are most welcome and very appreciated.
- Fred
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr ago
- Get help
- Reported - view
Re: Duplicate a sub-table while omitting fields.
Can you post your code for the button?
- Fred
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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 1 yr ago
- 9replies
- 309
- 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
- 1 yr 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
- 1 yr ago
- Get help
- Reported - view
Re: calculate stock
can you post a sample DB?
- Fred
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr ago
- 1
- Get help
- Reported - view

1 26 27 28 29 30 154

Welcome to the Ninox community

Fred

Re: v5 of Carbone in Beta

Re: Passing Dropdown Value to Another Page

Re: Not all fields showing

Re: Slowly getting a handle on Dynamic Printing

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.

Overview