John Halls's Profile | Ninox Community

Badges

Latest Posts

Re: Trouble finding a column
Sorry, from your original issue, it should be let key := this; if 'Commande?' then let t := (create 'Lignes Commandes'); let d := Offres.Options.'Fiche Option'.…
- John_Halls
- 21 hrs ago
- Get help
- Reported - view
Re: Trouble finding a column
Just looking at your code you can clean it up with some simple changes 1. 'Commande?' = true and 'Commande?' are the same thing 2. You don't then need a second if to test for false. 2. t.…
- John_Halls
- 23 hrs ago
- Get help
- Reported - view
Re: Set a field
I don't think there is a way to have a field always visible in the form, as you scroll down. What I do is make the reference field the left-hand most field in the list,…
- John_Halls
- 7 days ago
- Get help
- Reported - view
Re: Problem accessing a subtable from a reference record
Hi @iliper LTD A couple of things here with lines 5 & 6. 1. You don't need to state the table name, this will bring up an error. 2. You don't have the fields 'USD' and 'ZMW' in the Employees table.…
- John_Halls
- 2 wk ago
- 1
- Get help
- Reported - view
Re: printing multi record reports?
Hi Dave Ninox can't print lists from a view. If you use a script in a button to loop through the records in the view you can update a reference to the record you will be able to print that as your…
- John_Halls
- 2 wk ago
- Learn and share
- Reported - view
Re: Problem accessing a subtable from a reference record
The field is called Employees1 so your first line needs to be let empRec := record(Employees,number(Employees1)); Regards John
- John_Halls
- 2 wk ago
- 1
- Get help
- Reported - view
Re: Seelect where Calculation from 2 entries
@Alexander Prinz This can be written as let myReg := Registration; let myArray := ((select 'Flt Hrs' where Luftfahrzeuge.Registration = myReg) order by Datum); last(myArray).…
- John_Halls
- 3 wk ago
- Get help
- Reported - view
Re: Search for parent
@UKenGB Use a trigger on update in the Grandparent record to keep the parent record up-to-date and in sync
- John_Halls
- 4 wk ago
- Get help
- Reported - view
Re: Views
@UKenGB That's OK. One thing that might be worth doing is to change (select 'bulb∆slightingmodel∆s')['Model∆s¹' = thisModV and not contains(theCurrentLighting,…
- John_Halls
- 1 mth ago
- 1
- Get help
- Reported - view
Re: Views
Hi @UKenGB It's worth a lot! If this is in a formula field, which you say it is, then the problem lies with using a select command to gather the data. Select commands need a reason to run,…
- John_Halls
- 1 mth ago
- Get help
- Reported - view
Re: Views
@UKenGB said: I have a formula field that gathers records from another table Could you post a copy of the code that is in this formula field. Thanks John
- John_Halls
- 1 mth ago
- Get help
- Reported - view
Re: Views
@UKenGB Does the data that's displayed but not being updated come from a formula field, and does this formula field use a select statement?
- John_Halls
- 1 mth ago
- Get help
- Reported - view
Re: Comparing a formula field value with a string from within another formula field
Hi @Vermaji Try taking the alert statement out as it doesn’t work in a formula field. regards John
- John_Halls
- 1 mth ago
- Get help
- Reported - view
Re: rotate a formula date field
Hi When you say rotate, do you mean go from MM/YY to YY/MM, eg 10/25 to 25/10, or do you mean rotate the text by 90° clockwise? Regards John
- John_Halls
- 1 mth ago
- Get help
- Reported - view
Re: Sort the appointments in the calendar
I've only looked at dates, not date+time or appointments but with a bit of testing I can see they are sorted by the ID of the table plus the record ID. As such these are sorted alphabetically,…
- John_Halls
- 1 mth ago
- Get help
- Reported - view
Re: Modularity is here, baby!
Vey exited about this @Fred . I've been waiting a long time for modularity, with more than a hint of more features to come.
- John_Halls
- 2 mths ago
- 1
- Learn and share
- Reported - view
Re: Download file and JavaScript calling
@Jacques TUR Thanks Jacques. I'll look into BarTender's REST API.
- John_Halls
- 2 mths ago
- Learn and share
- Reported - view
Re: Download file and JavaScript calling
@Jacques TUR Hi Jacques. I use a label printing program called BarTender used extensively in production environments (@Mel will know about this). I am using your program to store the many hundreds of…
- John_Halls
- 2 mths ago
- Learn and share
- Reported - view
Re: Download file and JavaScript calling
@Jacques TUR This is EXACTLY what I was looking for. Thank you!
- John_Halls
- 2 mths ago
- Learn and share
- Reported - view
Re: Query about Database architecture (Parent Child Table)
Hi @Vermaji You all but answered you own question in your annotation. If I were writing this I would have Spending and Payments in the same table as they both share the same properties.…
- John_Halls
- 3 mths ago
- Get help
- Reported - view
Re: importing data from csv
On the Import dialogue there is the option for the first line to be a header, or not. It defaults to it being a header and so is not imported. Try setting it off,…
- John_Halls
- 3 mths ago
- Get help
- Reported - view
Re: How to Implement Batch Data Entry and Quoting via a Button After Uploading Product Details?
@lixingyang Not sure but my guess would be that Quotes.Contact is returning an array. Try adding first() to convert this to a record if 'Quantity' != null then this.('Quote Number-B' := Quotes.…
- John_Halls
- 3 mths ago
- Get help
- Reported - view
Re: Stocktaking/inventory
I have written many stock-taking programs over the years. I have yet to perfect it (maybe this year?). Can you let me know Is it a single site Do you have Bins? Do you have Batches?…
- John_Halls
- 3 mths ago
- Get help
- Reported - view
Re: dialog - causes text field "trigger after update" to fail
dialogue doesn't work in a trigger, but does in a button. Triggers don't have to have a user in front of the screen (zapier can add a record and the Trigger on new record will fire),…
- John_Halls
- 3 mths ago
- Get help
- Reported - view
Re: custom form in a table view - weird issue
Hi @Dave Airel Why are you deleting the parent Attendance_Staging table, and not leaving that in place and just deleting the children in the Attendance_Import_Staging_Table intead? No need for select,…
- John_Halls
- 3 mths ago
- Get help
- Reported - view

1 2 3 4 5 34

Welcome to the Ninox community

John Halls

Re: Trouble finding a column

Re: Trouble finding a column

Re: Set a field

Re: Problem accessing a subtable from a reference record

Re: printing multi record reports?

Re: Problem accessing a subtable from a reference record

Re: Seelect where Calculation from 2 entries

Re: Search for parent

Re: Views

Re: Views

Re: Views

Re: Views

Re: Comparing a formula field value with a string from within another formula field

Re: rotate a formula date field

Re: Sort the appointments in the calendar

Re: Modularity is here, baby!

Re: Download file and JavaScript calling

Re: Download file and JavaScript calling

Re: Download file and JavaScript calling

Re: Query about Database architecture (Parent Child Table)

Re: importing data from csv

Re: How to Implement Batch Data Entry and Quoting via a Button After Uploading Product Details?

Re: Stocktaking/inventory

Re: dialog - causes text field "trigger after update" to fail

Re: custom form in a table view - weird issue

Overview