Fred's Profile | Ninox Community

Badges

Latest Posts

Re: Record the previous day's figure
can you post a sample DB? if you can use a relationship then you can remove the need to match 'names'.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Is there a way to find overlapping appointments?
@Kruna If I read the script correctly, thanks to the easy read variable names, this is the heart of the code: xOverlap := count(select Assignments where TASK = thisRecord and 'ROLE PLAYER' =…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Trigger after update not triggered when updating by copy&paste
In my case (Ninox DB app on Mac) it fails whenever I copy & paste that one field With this new info, I went back and tested in my app on the Mac. It does fail like you reported if working on a local…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Sorting Problem
@iliper LTD That is true. You have to do it in your code that puts the text and number fields together.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Sorting Problem
That is not a bug. When you mix text and numbers it is treated as text, so when you sort text you do it one letter/number at a time. That means there is no such thing as 10's or 100's.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Select from Choice Dynamic from button go to record in another table
FYI, if 'Document Choice' uses Document as the root table then you can use the record command to quickly get the same record and remove the select. let rD := record(Document,…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Trigger after update not triggered when updating by copy&paste
I tried it again using a table Trigger after update (because I didn't read your original post thoroughly), though (imho) it seems like better served with a field level trigger.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Trigger after update not triggered when updating by copy&paste
@dennis I, too, was not able to reproduce your problem.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Dynamic Choice/Multi-Choice
@S Moore Since dynamic fields are based on tables, I wish they could also be JSON based, you will need to add a record called All Buildings and somehow mark it to show up in all your filters.…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Dynamic Choice/Multi-Choice
What is the other option you want to add?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Weird do as server issues
Looks like it was my bad coding. 😗 The formula field had code that was: length(ActiveTeams.TeamEventSummary.RoundAnalysis[round = t.round and (var g := RiderIDs; text(g) = text(t.…
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: Dashboard Template
@Sotirios Zormpas That is really cool. You have added a wealth of tools. Thanks, from the community.
- Fred
- 1 yr ago
- 2
- Learn and share
- Reported - view
Re: Ninox APP update problem
@RafaelJust wondering if you can you add data to date/time fields through a button? Not that this is a solution.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Ninox Products - App vs. Cloud
@James If you are worried about using the app with the cloud service and keeping things in sync then from my experience the app updates cloud DBs immediately and vice versa.…
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: Deleting Images from the app and the server! (update)
@Rafael I like the Spotify link. Do you update the link manually or does Spotify have an api that you can use to search their inventory?
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: Ninox APP update problem
@Rafael I've never clicked on that icon before. Thanks.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Hello
@Mario Cuzzi when you get a chance please mark this post”answered”. thanks.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Open 'Dashboard' view when opening Database
@Andy Hill When you get a chance, please mark the post Answered.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Hello
That is a very good question. You have to make fields like price, tax, discount, address, phone, etc all static fields (i.e. text, number, phone fields).…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Iphone layout
The easiest way is to use the ninoxApp() command in the Display only if of the fields you want to hide. If it is a dashboard you could create a tab that is set for the iphone then hide the other tab…
- Fred
- 1 yr ago
- 2
- Get help
- Reported - view
Re: Open 'Dashboard' view when opening Database
Forgot that you could have used a Page. If you did then use the openPage() command.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Open 'Dashboard' view when opening Database
That is where the command goes and it is the openTable() command.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Double search
Try: let xSt := 'Date 1'; let xFh := 'Date 2'; let xY := 2024; select Partidos[Fecha >= xSt and Fecha <= xFh and contains(text(Year),text(yearfieldinPartidos))] assuming the year field in Partidos is…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Double search
What kind of field is Year? simple multi choice or dynamic multi choice?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Weird do as server issues
@Mel Charlessomething as simple as (in the cloud): for statrec in atStats[level = "g"] do statrec.( historical := false; atm := statrec.latm; clears := statrec.lclears; ROLs := statrec.…
- Fred
- 1 yr ago
- Learn and share
- Reported - view

1 29 30 31 32 33 153

Welcome to the Ninox community

Fred

Re: Record the previous day's figure

Re: Is there a way to find overlapping appointments?

Re: Trigger after update not triggered when updating by copy&paste

Re: Sorting Problem

Re: Sorting Problem

Re: Select from Choice Dynamic from button go to record in another table

Re: Trigger after update not triggered when updating by copy&paste

Re: Trigger after update not triggered when updating by copy&paste

Re: Dynamic Choice/Multi-Choice

Re: Dynamic Choice/Multi-Choice

Re: Weird do as server issues

Re: Dashboard Template

Re: Ninox APP update problem

Re: Ninox Products - App vs. Cloud

Re: Deleting Images from the app and the server! (update)

Re: Ninox APP update problem

Re: Hello

Re: Open 'Dashboard' view when opening Database

Re: Hello

Re: Iphone layout

Re: Open 'Dashboard' view when opening Database

Re: Open 'Dashboard' view when opening Database

Re: Double search

Re: Double search

Re: Weird do as server issues

Overview