John Halls's Profile | Ninox community

Badges

Latest Posts

Re: Table or Sub-Table?
@Fred Ah, yes. Fred is absolutely correct here. When I said I try and use as few tables as possible, I didn't mean I have Employee1, Employee2 fields in my tables (not that I'm admitting to).…
- John_Halls
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Table or Sub-Table?
Let’s start with Trades. Can you explain what they are? Thanks
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: Table or Sub-Table?
Hi @Michael Cornelissen I would be asking a simple set of questions that determine the relationships. Can a Contact have more than 1 invoice? Yes Can an invoice relate to more than one Contact?…
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: Button with script to populate table
Hi @Alain Fontaine working as it should, thank you. I think it might have been a column formula that threw it, as you said. Maybe I was trying too hard to beat @Fred to an answer and rushed it!
- John_Halls
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Button with script to populate table
@Alain Fontaine I was trying it prior to setting any columns. It doesn’t show any records. Had me flummoxed.
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: Button with script to populate table
@Alain Fontaine I tried this and couldn’t get the view to work. Not sure what I was doing wrong.
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: Button with script to populate table
6. List of Students... is not a table but a view that uses the existing structure. So create a view in the 4. Assignments table with this formula '5. Classes with Assignments'.'2. Classes'.'3.…
Attachment
- John_Halls
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Ninox 3.13 available
@Rafael Yes, it is affecting me
- John_Halls
- 1 yr ago
- Learn and share
- Reported - view
Re: Ninox 3.13 available
@Vermaji This might not be to do with the new version. Go to the child table, set Composition to No, unlink the record and link it to the correct parent and then set Composition back to Yes
- John_Halls
- 1 yr ago
- Learn and share
- Reported - view
Re: Ninox 3.13 available
@Paul Chappell Not just you. Me too.
- John_Halls
- 1 yr ago
- Learn and share
- Reported - view
Re: Relative record numbers in a table
Hi all. Be aware that a select statement in a formula needs a reason to trigger, usually when a non-formula field changes in value, but it's always a risky strategy.…
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: Relative record numbers in a table
Hi @brentjl1 Is this what you are looking for? https://docs.ninox.com/en/tutorial/basics/row-numbers-and-ids They call this the "always visible row number" not to be confused with the record id.…
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: Please check this email script
Hi @Alan Cooke Sending the same email from another Ninox member worked. The email came into my inbox!
- John_Halls
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Please check this email script
Your variable CR should look like this let CR := " "; Regards John
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: Please check this email script
Hi @Alan Cooke Have you checked your spam folder. On testing sending to myself mine are going into spam yet those sent to another email address of mine were received OK.
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: Complex criteria for Select
@Chris Mullett We store the current record, this, to a variable because the current record is not available to reference within a select statement, but variables are.
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: Complex criteria for Select
As you have some "Show All" options you may need to build your where clause as a text string and evaluate it, such as let x := text(Filter by Status); let y := text(Filter by Camera); let z :…
- John_Halls
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Stopped working for me
Hi @Rafael There a few things here Why do you open the record, and then assign new values to it? I would do it the other way round Why do you open the record twice? Why do you have sleep(1000)?…
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: Record reference numbers
Hi Gary I would also prefix this with a letter or two, so my stock records might be ST001, ST002. I do this so that every record in my database has a unique reference number,…
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: Query regarding View Element
Hi @Vermaji Your payments need to be in the same table as your invoices and credit notes, then have an allocations table to allocate payments and credit notes to invoices.…
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: Ninox forgetting entries
Thanks for your reply. It’s not binding. Can you show how the Work Job is connected to Client Detail Brief. How are the Job Charges calculated? Thanks John
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: Ninox forgetting entries
@RoSoft_Steven That crossed my mind too. Seems the obvious one to look at.
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: Ninox forgetting entries
Hi Nick. It would be unusual if Ninox weren’t saving data correctly. The forum would be swamped with queries on the subject. Can you post a sample of your system? Or a screenshot? thanks John
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: Clearing filters on loading a table
@Jacques TUR Thanks Jacques, excellent description of how it does its magic.
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: Query regarding the sale price per item in Sale Order
@Mel Charles I REALLY like this Mel. The fields are always in the same place on screen. Super effective.
- John_Halls
- 1 yr ago
- Get help
- Reported - view

1 6 7 8 9 10 35

Welcome to the Ninox community

John Halls

Re: Table or Sub-Table?

Re: Table or Sub-Table?

Re: Table or Sub-Table?

Re: Button with script to populate table

Re: Button with script to populate table

Re: Button with script to populate table

Re: Button with script to populate table

Re: Ninox 3.13 available

Re: Ninox 3.13 available

Re: Ninox 3.13 available

Re: Relative record numbers in a table

Re: Relative record numbers in a table

Re: Please check this email script

Re: Please check this email script

Re: Please check this email script

Re: Complex criteria for Select

Re: Complex criteria for Select

Re: Stopped working for me

Re: Record reference numbers

Re: Query regarding View Element

Re: Ninox forgetting entries

Re: Ninox forgetting entries

Re: Ninox forgetting entries

Re: Clearing filters on loading a table

Re: Query regarding the sale price per item in Sale Order

Overview