John Halls

John_Halls

Somerset, England

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

My Posts

Latest Posts

Re: how to add to variables
Hi Mark This is a common newbie gotcha! Your line (select 'PL Matches').'Mark/Ben Total' doesn't return a number. It returns an array, even if it only finds one record.…
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: an you please help me optimize the code structure?
@我是我的我 My pleasure. There are a few mistakes you will need to take care of, but hopefully, you get the idea.
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: an you please help me optimize the code structure?
Try something like this let cr := " "; let a := switch true do case ZM + LM = 0: "No1!" case ZM + LM != 0 and 出库零整' = 1 and ZM < quantity: "No2!" case ZM + LM !…
- John_Halls
- 1 yr ago
- 1
- Get help
- Reported - view
Re: I Need to update field in another table.
Hi Rafael You ae scoping by a text field [projCod = myText] But then assigning an Id to the same field i.(projCod := myTable1) I am guessing the Id has to be assigned to a relationship field instead…
- John_Halls
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Announcing a new Template 'Store' for Ninox Templates
I would be very interested Julian. Can you update the link. Thanks John
- John_Halls
- 1 yr ago
- Learn and share
- Reported - view
Re: Whether the data content of table1 field can become the field of select(table2)
@Fred Makes a change Fred!
- John_Halls
- 1 yr ago
- Get help
- Reported - view
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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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

1 7 8 9 10 11 33

Welcome to the Ninox community

John Halls

My Posts

Re: how to add to variables

Re: an you please help me optimize the code structure?

Re: an you please help me optimize the code structure?

Re: I Need to update field in another table.

Re: Announcing a new Template 'Store' for Ninox Templates

Re: Whether the data content of table1 field can become the field of select(table2)

Re: Whether the data content of table1 field can become the field of select(table2)

Re: HTML Pivot Table

Re: how to duplicate a subtable using a button

Re: Update all recoords

Re: Charging for use of application.

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

Overview