James

JamesLIv.1

Joined: Fri Apr 05 10:27:37 UTC 2024

My Posts

Latest Posts

Re: Ninox Products - App vs. Cloud
@spinner. 7580 have you had this clarified by anyone yet? As I’m looking to switch over to the cloud myself but this would be a deal breaker
- JamesLIv.1
- 1 yr ago
- Learn and share
- Reported - view
Re: Formulate View field from multiple date entries?
@Fred I was sure that code was going to work then when I put it in, but unfortunately it still only shows the 1st 'Fitting Date/Time' in the results as you can see in the screen shots below.…
- JamesLIv.1
- 1 yr ago
- Get help
- Reported - view
Re: Formulate View field from multiple date entries?
@Fred morning Fred, I just tested the code on the database I sent you and it still returns all blank results the same as what I showed above?
- JamesLIv.1
- 1 yr ago
- Get help
- Reported - view
Re: Formulate View field from multiple date entries?
@James
- JamesLIv.1
- 1 yr ago
- Get help
- Reported - view
Re: Formulate View field from multiple date entries?
@Fred I had made a mistake when I initially tried it, I out an "and" instead of "or". However I just copied your code and put it in but it still doesn't work.…
- JamesLIv.1
- 1 yr ago
- Get help
- Reported - view
Re: Formulate View field from multiple date entries?
@Fred ninox export (sample DB).ninox I've added a couple of customers and created fitting appointments for them. You will see that I have created a 1st and 2nd fitting date for 2 of them,…
- JamesLIv.1
- 1 yr ago
- Get help
- Reported - view
Re: Formulate View field from multiple date entries?
@Fred ah sorry. So the view I'm trying to code is in the Fitting table (underneath Customers) and on the 'Date Search' form. When a new customer is created, a fit is scheduled with a date etc,…
- JamesLIv.1
- 1 yr ago
- Get help
- Reported - view
Re: Formulate View field from multiple date entries?
@Fred ok I think I understand what you mean. I hadn't considered recording it in that way
- JamesLIv.1
- 1 yr ago
- Get help
- Reported - view
Re: Formulate View field from multiple date entries?
@Fred ninox export (blank DB).ninox
- JamesLIv.1
- 1 yr ago
- Get help
- Reported - view
Re: Formulate View field from multiple date entries?
@Fred I'm currently still using the app on iMac
- JamesLIv.1
- 1 yr ago
- Get help
- Reported - view
Re: Formulate View field from multiple date entries?
@Fred how would I go about that? copy database and remove records etc is it? Sorry if I don't seem very tech savvy :) I've never done any sort of coding before but just learnt what I could on Ninox…
- JamesLIv.1
- 1 yr ago
- Get help
- Reported - view
Re: Formulate View field from multiple date entries?
@Fred what would you mean by a different db design as such?
- JamesLIv.1
- 1 yr ago
- Get help
- Reported - view
Re: Formulate View field from multiple date entries?
@RoSoft_Steven I have tried that also but still doesn't work. I can send screenshots of whats going on?
- JamesLIv.1
- 1 yr ago
- Get help
- Reported - view
Re: Formulate View field from multiple date entries?
@Fred Sorry for the delay in replying, I've been off this past week. Thank you for taking a look and providing a possible solution, but I have just tried and it still doesn't get it to work…
- JamesLIv.1
- 1 yr ago
- Get help
- Reported - view
Re: Formulate View field from multiple date entries?
@RoSoft_Steven I've tried the following code but it then only displays the 2nd date and not the 1st let xbeg := 'Start Date'; let xend := 'End Date'; select Fitting where 'Fitting Date/Time' >= xbeg…
- JamesLIv.1
- 1 yr ago
- Get help
- Reported - view
Formulate View field from multiple date entries?

I have a View field to show me fitting appointments between 2 selected dates (start date & end date), where it shows me all appointments where the "Fitting Date/Time" falls in between these:…
- JamesLIv.1
- 1 yr ago
- 30replies
- 315
- Get help
Re: Duplicate record has stopped working
@Nick Hi Nick, I am using Mac OS Sonoma Version 14.4.1 and as of yet it still isn't working
- JamesLIv.1
- 1 yr ago
- Get help
- Reported - view
Re: Minimum cost (coding help)
@Fred this is the formula I have in the trigger after update within my product field. So when I select a product all these values are copied from the product and into fields in my form: Item :…
- JamesLIv.1
- 1 yr ago
- Get help
- Reported - view
Re: Minimum cost (coding help)
@Fred no, sorry if my explanation was confusing. The code as it is works perfectly, but I want to create a minimum value. e.g if the default 'Sq.m' * 'Fitting Rate' * 1.…
- JamesLIv.1
- 1 yr ago
- Get help
- Reported - view
Minimum cost (coding help)

I’ve written a code in my database using a case by case scenario, so that if option 1 is selected then x amount gets added on to the fitting price etc. I now need to add on to that code so that no…
- JamesLIv.1
- 1 yr ago
- 4replies
- 41
- Get help
Re: Duplicate record has stopped working
@Fred the freedom to use it across multiple devices would be a key feature for me, but I was weighing up if it was worth the extra cost involved. But if it is indeed updated more frequently then that…
- JamesLIv.1
- 1 yr ago
- Get help
- Reported - view
Re: Duplicate record has stopped working
@Fred ok thank you for this. I’ve been considering moving to the public cloud version instead of the Mac app which I currently am using. Do you find generally that it experiences less glitches out of…
- JamesLIv.1
- 1 yr ago
- Get help
- Reported - view
Re: Duplicate record has stopped working
@Nick do you know if this problem also occurs on the cloud version rather than the app?
- JamesLIv.1
- 1 yr ago
- Get help
- Reported - view
Re: Duplicate record has stopped working
@Nick ok thank you. Hopefully they will fix it soon. I’ve tried altering the code but couldn’t get any different result
- JamesLIv.1
- 1 yr ago
- Get help
- Reported - view
Re: Duplicate record has stopped working
@Fred yes that seems to be the same issue. As I mentioned that line of code has worked perfectly for me for 3 years, but has suddenly stopped
- JamesLIv.1
- 1 yr ago
- Get help
- Reported - view

1 2

Welcome to the Ninox community

James

My Posts

Re: Ninox Products - App vs. Cloud

Re: Formulate View field from multiple date entries?

Re: Formulate View field from multiple date entries?

Re: Formulate View field from multiple date entries?

Re: Formulate View field from multiple date entries?

Re: Formulate View field from multiple date entries?

Re: Formulate View field from multiple date entries?

Re: Formulate View field from multiple date entries?

Re: Formulate View field from multiple date entries?

Re: Formulate View field from multiple date entries?

Re: Formulate View field from multiple date entries?

Re: Formulate View field from multiple date entries?

Re: Formulate View field from multiple date entries?

Re: Formulate View field from multiple date entries?

Re: Formulate View field from multiple date entries?

Formulate View field from multiple date entries?

Re: Duplicate record has stopped working

Re: Minimum cost (coding help)

Re: Minimum cost (coding help)

Minimum cost (coding help)

Re: Duplicate record has stopped working

Re: Duplicate record has stopped working

Re: Duplicate record has stopped working

Re: Duplicate record has stopped working

Re: Duplicate record has stopped working

Overview