John Halls

John_Halls

Somerset, England

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

My Posts

Latest Posts

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
- 7 days 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
- 9 days 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
- 10 days 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
- 3 wk 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 mths ago
- Get help
- Reported - view
Re: Modularity FAQ and quick start
@Fred Hi Fred. Interested in what you might know about making DBs "Products"? You also mentioned a few days ago about sending emails to Ninox. Any idea how this might work? Thanks John
- John_Halls
- 2 mths ago
- Modules
- Reported - view
Re: Different views on on page
@Philip Meinertz That's ChatGPT for you!
- John_Halls
- 2 mths ago
- 1
- Get help
- Reported - view
Re: printandsaverecord - How do I stop from overriding attachment?
Hi Suzie I would either add a field to your table that you increment after each pdf creation, and append it to the filename. If the field is called pdfCounter then you code becomes…
- John_Halls
- 2 mths ago
- 1
- Get help
- Reported - view
Re: Ninox + n8n
Hi @Sotirios Zormpas I took my first look at n8n a few days ago. It didn’t seem as obvious as Zapier or Make. If you get to grips with it could you provide a walk through for me. Thanks John
- John_Halls
- 2 mths ago
- Get help
- Reported - view
Re: CSV Import Wizard
@Sotirios Zormpas Thank you for this. I am trying to fully automate a CSV import. Your solution will certainly help! I have a Zap in Zapier that triggers when a CSV file is added to a folder and it…
- John_Halls
- 2 mths ago
- Learn and share
- Reported - view
Re: Need a formula between week to place on (%Semana Plan)
@Rafael You can turn text into a number with the number() function, so in your case number(Week) and number(t.Week) Regards John
- John_Halls
- 2 mths ago
- Get help
- Reported - view
Re: Can I control the order in which Ninox displays my tables?
@Fred Hi Fred. Not so sure it's needed for contacts but for events, it stops a new event from being created twice, or more, during the import. Very clever, I thought.…
- John_Halls
- 2 mths ago
- 1
- Get help
- Reported - view
Re: Can I control the order in which Ninox displays my tables?
@Dave Airel Hi Dave I've had a quick look at your solution. Impressive stuff. I did notice that you are using a select statement to get the full name of the donor in the Donations table let e :…
- John_Halls
- 2 mths ago
- Get help
- Reported - view
Re: Can I control the order in which Ninox displays my tables?
@Dave Airel Hi Dave. In that case you have picked up some decent techniques pretty quickly. I haven't tested the revised code but the changes were was mostly swapping out things like Contacts :…
- John_Halls
- 2 mths ago
- 1
- Get help
- Reported - view
Re: Can I control the order in which Ninox displays my tables?
@Dave Airel Hi Dave I can't see anything in your code that would be affected by where you run it. I hope you don't mind but I had a go at tidying it up to this do as server let allContacts :…
- John_Halls
- 2 mths ago
- 1
- Get help
- Reported - view
Re: Control the focus of a field
@Sotirios Zormpas I couldn't find a way of moving the focus to a field and my ePOS still needs a mouse click after the end of a transaction to put the cursor back into a scan field.
- John_Halls
- 2 mths ago
- Get help
- Reported - view
Re: Can I control the order in which Ninox displays my tables?
@Fred Life would be so much easier if we didn't have users. Or customers eh @Mel Charles ?
- John_Halls
- 3 mths ago
- 1
- Get help
- Reported - view

1 2 3 4 5 34

Welcome to the Ninox community

John Halls

My Posts

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

Re: Modularity FAQ and quick start

Re: Different views on on page

Re: printandsaverecord - How do I stop from overriding attachment?

Re: Ninox + n8n

Re: CSV Import Wizard

Re: Need a formula between week to place on (%Semana Plan)

Re: Can I control the order in which Ninox displays my tables?

Re: Can I control the order in which Ninox displays my tables?

Re: Can I control the order in which Ninox displays my tables?

Re: Can I control the order in which Ninox displays my tables?

Re: Control the focus of a field

Re: Can I control the order in which Ninox displays my tables?

Overview