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: Regarding the issue of modifying a sub-table of a sub-table.
Where Script is a field to allow you to see the result of running your script instead of shown by an alert
- John_Halls
- 6 mths ago
- Get help
- Reported - view
Re: Issue with a script that does not display the expected value when two fields are equal
Hi Rafael It’s the same as the code I reduced in size in your last post. Take a look at it. I took out the if.. else part where you set a field to null.
- John_Halls
- 6 mths ago
- Get help
- Reported - view
Re: Regarding the issue of modifying a sub-table of a sub-table.
Fred is right, it isn't reccommened to put alerts in a loop. I would set a text or choice field so that you can see the results of running your script. If it was a choice field called Script it would…
- John_Halls
- 6 mths ago
- Get help
- Reported - view
Re: Regarding the issue of modifying a sub-table of a sub-table.
Hi Your codes goes from this for one product line let aa := this; for i from 0 to nb do let newRec := (create Code); newRec.(Products := aa) end To this for all product lines in a order for aa in…
- John_Halls
- 6 mths ago
- Get help
- Reported - view
Re: How to use code to remove extra information?
let cr := " "; join(split('Text 2', cr)[!= ""], cr)
- John_Halls
- 6 mths ago
- 5
- Get help
- Reported - view
Re: Some idea ?
@Rafael Fab. Always tricky when it's being coded outside of Ninox.
- John_Halls
- 6 mths ago
- Get help
- Reported - view
Re: Some idea ?
I think your code can be shorted to this, at least. Test it first though... let vDd := 'Add Data|Date'; if dialog(" Warning ", " ¿Confirm the Progress Update by Disciplines ? ", ["Yes",…
- John_Halls
- 6 mths ago
- 1
- Get help
- Reported - view
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
- 6 mths 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
- 6 mths 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
- 6 mths 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
- 6 mths 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
- 6 mths 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
- 6 mths 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
- 6 mths 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
- 7 mths 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
- 7 mths 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
- 7 mths 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
- 7 mths 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
- 7 mths 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
- 7 mths 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
- 7 mths 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
- 7 mths 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
- 7 mths 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
- 7 mths 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
- 7 mths ago
- Get help
- Reported - view

1 4 5 6 7 8 31

Back to top

Ninox-Documentation

Overview

View all topics