John Halls's Profile | Ninox community

Badges

Latest Posts

Re: Sub table query - limit to current record
Hi James You have hit the nail on the head. The language has been designed so that almost everything in Ninox has a simple solution. As soon as you feel like you are going down a rabbit hole it's…
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: Script to update records in another table
Hi You can also make if count(existingRecord) > 0 then for record in existingRecord do delete record; end end become for record in existingRecord do delete record;…
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: Sub table query - limit to current record
Hi James No need for a select statement, you can scope with square brakets sum('Event Expenses'[Type = 10].Amount) Regards John
- John_Halls
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Script to update records in another table
Well, I've just spent half an hour writing a detailed reply, only to lose it! Sorry about that...
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: Activate or Deactivate all records in a "Yes/No" field
@Rafael Another approach would be to set the Binding of your Protect field to 'Global variable in memory (browser)'. It then has a single value for all your records.…
- John_Halls
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Issue with trigger conditions in 'Liste' Field: Multiple Text conditions not triggering as expected
Hi. Unfortunately, it's not quite as simple as that. Have a look at this post https://forum.ninox.com/t/83hrts2#y4hrsgn Regards John
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: Analysis of your database structure with Ninext
Hi @Jacques TUR Interesting to see @Fred has the following "relation <= 1:N": 52, "relation => N:1": 52, Which would be expected but you have "relation <= 1:N": 146, "relation => N:1": 144,…
- John_Halls
- 1 yr ago
- Learn and share
- Reported - view
Re: Setting up a FIFO inventory
Hi Andy I can't see it ATM but it wouldn't be too difficult to re-create if you would like me to? I can't today but will do so in the next couple of days if you would like. Regards John
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: New Member Introduction - Seeking Guidance and Tips
Hi Mitchel Welcome to our forum.You will be made to feel more than welcome here, as I was. No question is too big or small. Kind regards John
- John_Halls
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Issue/Bug in report creation
Hi Alan. Yes I am seeing the same issue. Clicking on the cog icon (top right in any highlighted field) brings up the formula builder and you can add / update fields from there. Regards John
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: Values not displaying
Hi The Edit columns section is used to determine what is shown when selecting a record. Regards John
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: Values not displaying
I can understand why you thought that would be the correct place to set this, but in fact, it's set in the 'Show data as' formula field TBH I'm not quite sure where the Edit columns set here would…
- John_Halls
- 1 yr ago
- Get help
- Reported - view
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

1 9 10 11 12 13 35

Welcome to the Ninox community

John Halls

Re: Sub table query - limit to current record

Re: Script to update records in another table

Re: Sub table query - limit to current record

Re: Script to update records in another table

Re: Activate or Deactivate all records in a "Yes/No" field

Re: Issue with trigger conditions in 'Liste' Field: Multiple Text conditions not triggering as expected

Re: Analysis of your database structure with Ninext

Re: Setting up a FIFO inventory

Re: New Member Introduction - Seeking Guidance and Tips

Re: Issue/Bug in report creation

Re: Values not displaying

Re: Values not displaying

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

Overview