Skip to main content

Forum

Welcome to the Ninox community

Search all topics or ask a question

Badges

Latest Posts

Re: Error in a script to find duplicates
I had a go at this, changing text(i) to i.text in the two lines where it is used. It did work and removed duplicates in a small table but then hung and I had to quit out and come back in again,…
- John_Halls
- 5 yrs ago
- Get help
- Reported - view
Re: Copy Data from one for into another then open that new record
Hi Mel I think you need to change Phone:=a to i.Phone:=a for i in select Table1[Phone=null] do let a := i.fxTemp; i.Phone := aend Regards John
- John_Halls
- 5 yrs ago
- Get help
- Reported - view
Re: Copy Data from one for into another then open that new record
The if statement can be taken out by tweaking the line before, so you end up with for i in select tableOne[Archive="Yes"] do let a := i.FieldA; let b := i.FieldB; let c := create tableTwo; c.…
- John_Halls
- 5 yrs ago
- Get help
- Reported - view
Re: Formatting printing of forms
I've just had a play with the print section for the first time so someone correct me if I am wrong. It looks like fields are represented by {field}. You can change this to {if test then field end}
- John_Halls
- 5 yrs ago
- Get help
- Reported - view
Re: Is it possible to have a filter expression for character count?
Yes you *can*, by creating a formula field with the code length('Field 1'). Show this as a column and filter for 17. I'd be looking for a better solution than this though.…
- John_Halls
- 5 yrs ago
- Get help
- Reported - view
Re: Recors counting
That should have read 'automatically update as you add'
- John_Halls
- 5 yrs ago
- Get help
- Reported - view
Re: Recors counting
Hi Francesco Try adding a formula field to TABLE A and use this formula count ( select 'TABLE B' ) It will update automatically as us add and delete records to TABLE B Regards John
- John_Halls
- 5 yrs ago
- Get help
- Reported - view

1 30 31 32 33 34 35 36

Back to top

Overview

View all topics