Skip to main content

Ninox-Documentation

John Halls

John_Halls

Somerset, England

756
123
1

Joined: Thu Feb 11 10:04:26 UTC 2021

My Posts

Latest Posts

Re: Whether the data content of table1 field can become the field of select(table2)
I have created a demo file that uses a sub-table for the values of A, B, C and D in Table2. It is also linked to Table1 to show these values as you requested.…
Attachment
- John_Halls
- 7 mths ago
- 2
- Get help
- Reported - view
Re: HTML Pivot Table
My computer at work struggles to display this data. I get an 'out of memory' message
- John_Halls
- 7 mths ago
- Learn and share
- Reported - view
Re: how to duplicate a subtable using a button
Hi The simplest way is to use the duplicate() function, which also duplicates sub-tables with Composition set to Yes let a := this; let b := duplicate(a); b.(Datum := today()); b.(Status := 0); b.…
- John_Halls
- 7 mths ago
- Get help
- Reported - view
Re: Update all recoords
Hi Leo Put the code in a button, and just run it once. It can go anywhere. Regards John
- John_Halls
- 8 mths ago
- Get help
- Reported - view
Re: Charging for use of application.
Hi Alan This is such a hard thing to decide. I am always being told (via my subscription to a daily email from Jonathan Stark) that it has nothing to do with your cost but is related to the cost of…
- John_Halls
- 8 mths ago
- 1
- Learn and share
- Reported - view
Re: Update all recoords
If your tables are large, you may wish to wrap the whole thing in a do as server
- John_Halls
- 8 mths ago
- Get help
- Reported - view
Re: Update all recoords
Hi Leo Yes you can create an outer loop to loop through all your members for j in select members do let myText := j.Medlemsnr; for i in (select Foto)[Medlemnr = myText] do i.…
- John_Halls
- 8 mths ago
- Get help
- Reported - view
Re: Payment of several unpaid invoices
Hi Nick Sorry, rushed that a bit. It should be Change the Balance to be the TOTAL less the sum of the Allocations Amount TOTAL - sum(Allocation.Amount)
- John_Halls
- 8 mths ago
- 1
- Get help
- Reported - view
Re: Payment of several unpaid invoices
Hi Nick Your receipt is linked to the invoice. You need a many to many Allocations table that sits between your Invoices and Receipts tables. Change the Balance to be the sum of the Allocations…
- John_Halls
- 8 mths ago
- 1
- Get help
- Reported - view
Re: Optimize this Code is to large
I came up with this, which tests the dialog first before proceeding to the update let t := this; let title := [" 🟢 Audit To History"," M A J O R - Non Conformities",…
- John_Halls
- 9 mths ago
- 1
- Get help
- Reported - view
Re: chiose table from a variable
@Fred @francesco.stefanello Francesco, I would encourage you to take up Fred's offer. You have hit the first hurdle of having your data structured the way it is.…
- John_Halls
- 9 mths ago
- Get help
- Reported - view
Re: Dialog on Trigger on new record
@Alan Cooke But what happens when multiple new records are created in a script. as is often the case?
- John_Halls
- 9 mths ago
- Get help
- Reported - view
Re: Help with Changing Multiple If Statement to a Case Statement
@Fred Thanks. It's the same way Multi Choice fields work. If there had been a third field to compare it would be multiplied by 4, etc
- John_Halls
- 10 mths ago
- Get help
- Reported - view
Re: Help with Changing Multiple If Statement to a Case Statement
@Fred Of course. Neat!
- John_Halls
- 10 mths ago
- Get help
- Reported - view
Re: Help with Changing Multiple If Statement to a Case Statement
Your if statements used two test values which we need to convert to one for the switch When Withdrawn = 0 and Graduated = 0, 0 * 1 + 0 * 2 = 0 When Withdrawn = 1 and Graduated = 0,…
- John_Halls
- 10 mths ago
- Get help
- Reported - view
Re: Help with Changing Multiple If Statement to a Case Statement
Try this let t := 'Enrolled Date'; let y := 'Withdrawal Date'; let x := 'Graduation Date'; switch Withdrawn * 1 + Graduated * 2 do case 0: days(date('Enrolled Date'),…
- John_Halls
- 10 mths ago
- 1
- Get help
- Reported - view
Re: Ver 3.10 - new PAGES Feature
@Mel Charles Hi Mel. I can confirm it is, I suffered from being an early adopter and found my page turned back into a table when I accessed it on my phone.…
- John_Halls
- 10 mths ago
- Learn and share
- Reported - view
Re: Why using a choice field's text does not work in an "if" statement?
If you can resist the temptation to use the text, and use the index number instead your code will be better. Using the text would be considered as hardcoding your software,…
- John_Halls
- 10 mths ago
- Learn and share
- Reported - view
Re: Custom Buttons
@Kruna Sorry Kruna, this is beyond my scope. I hope someone else will be able to help
- John_Halls
- 10 mths ago
- Learn and share
- Reported - view
Re: Custom Buttons
@Kruna The code above was missing a final close quote and close bracket on line 23 </html>") Regards John
- John_Halls
- 10 mths ago
- Learn and share
- Reported - view
Re: A trip down memory lane
Hi Fred. Thank you so much for sharing. This is so interesting to look at, not that I am pretending to understand your system. Are you able to share any of the UI as well? Regards John
- John_Halls
- 10 mths ago
- Learn and share
- Reported - view
Re: Invoice lines of old invoices
Hi Raisla67 Yes, Fred is right. Additionally, everything relating to that invoice should be held in a static format, company name, company address, stock code, stock description, stock price,…
- John_Halls
- 11 mths ago
- Get help
- Reported - view
Re: How do you give a Yes/No field in Chart text names instead of 1/No
@Matthew This is an important point regarding 'Yes / No' fields. Unless a default value of 'Yes' or 'No' is set the value will be null, not what you would expect from a 'Yes / No' field.
- John_Halls
- 11 mths ago
- Get help
- Reported - view
Re: Coding a popup dialog in a for loop if error
@Marisol Echaide said: I've been reading that loops cannot be coded to exit Hi Marisol. I feel a duty to say that loops can be coded to exit in Ninox, just not so easily in the form you are using eg…
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: How to calculate years and months from a date to the current date?
Hi Bernd. Have a look at this post https://forum.ninox.com/t/m1hrxas#h7hrbyz Regards John
- John_Halls
- 1 yr ago
- 1
- Get help
- Reported - view

1 5 6 7 8 9 31

Back to top

Ninox-Documentation

Overview

View all topics