John Halls

John_Halls

Somerset, England

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

My Posts

Latest Posts

Re: Update all recoords
If your tables are large, you may wish to wrap the whole thing in a do as server
- John_Halls
- 11 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
- 11 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr ago
- Get help
- Reported - view
Re: Help with Changing Multiple If Statement to a Case Statement
@Fred Of course. Neat!
- John_Halls
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
Re: Using triggers for yes/no field
You mght also need to change Status = "Closed" to text(status) = "Closed" or better still status = 1 (the option number of status for Closed). And do the same for Expired.…
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: Using triggers for yes/no field
Hi Rick You need to be checking for an update in the Status and Campaign Premium fields but you have your code in Winner. Place the same code in these two fields and take it away from Winner and all…
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: Button to open a PAGE
@Sam hi Sam. Just got it today.
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: Button to open a PAGE
@Fred Hi Fred. I do use the cloud. The iPhone app allows me to access this on my phone. What's worse than it not recognising openPage() is that if you edit a page on the app it turns it into a table,…
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: Code about random numbers
Hi. Use the random() function, as explained here https://docs.ninox.com/en/script/functions-overview/functions/random Be aware that generating random numbers is a really hard thing to do,…
- John_Halls
- 1 yr ago
- Get help
- Reported - view

1 7 8 9 10 11 33

Welcome to the Ninox community

John Halls

My Posts

Re: Update all recoords

Re: Update all recoords

Re: Payment of several unpaid invoices

Re: Payment of several unpaid invoices

Re: Optimize this Code is to large

Re: chiose table from a variable

Re: Dialog on Trigger on new record

Re: Help with Changing Multiple If Statement to a Case Statement

Re: Help with Changing Multiple If Statement to a Case Statement

Re: Help with Changing Multiple If Statement to a Case Statement

Re: Help with Changing Multiple If Statement to a Case Statement

Re: Ver 3.10 - new PAGES Feature

Re: Why using a choice field's text does not work in an "if" statement?

Re: Custom Buttons

Re: Custom Buttons

Re: A trip down memory lane

Re: Invoice lines of old invoices

Re: How do you give a Yes/No field in Chart text names instead of 1/No

Re: Coding a popup dialog in a for loop if error

Re: How to calculate years and months from a date to the current date?

Re: Using triggers for yes/no field

Re: Using triggers for yes/no field

Re: Button to open a PAGE

Re: Button to open a PAGE

Re: Code about random numbers

Overview