Skip to main content

Welcome to the Ninox community

Search all topics or ask a question

Fred

Fred

San Francisco, USA

3376
533
4

Joined: Thu Feb 06 18:42:57 UTC 2020

My Posts

Latest Posts

Re: Get()
You don't need the know the name of the current table to use get(). If you want to modify fields in other tables then you need to get the nid of the record, which is the tableId plus the recordId.…
- Fred
- 4 mths ago
- Get help
- Reported - view
Re: Styled text
For me, I like to use a switch if I have start embedding ifs within ifs. You can try: switch true do case 'field name' = 0: styled(text(AA), "green") case 'field name' < 0: styled(text(AA),…
- Fred
- 4 mths ago
- 1
- Get help
- Reported - view
Re: Fleno Storage
@Sotirios Zormpas They didn’t fix it as I still see ghost DBs in my workspace.
- Fred
- 4 mths ago
- 2
- Get help
- Reported - view
Re: Fleno Storage
@Mario Cuzzi I don't know what to say. It says you are using 4.47GB but it doesn't show where it is. Your DB only uses 1.87GB and your backups are about 1GB so where is the other 1.…
- Fred
- 4 mths ago
- 1
- Get help
- Reported - view
Re: Fleno Storage
Where does Ninox say is using the storage? The DB? or backups? Here is my workspace info: Recently, it was using almost 1GB in automated backups, so I just deleted all backups except for the most…
- Fred
- 4 mths ago
- Get help
- Reported - view
Re: Connect 2 entries
@FAIB-Delegacionesof course: let t := this; let personasRec := first(select Personas where DNI = t.DNI); Personas := personasRec Line 2 is assuming that there will only ever be one Personas record…
- Fred
- 4 mths ago
- 1
- Get help
- Reported - view
Re: Connect 2 entries
@FAIB-Delegaciones You can try: In Personas table create a button with: let t := this; let solicitudesRecs := (select Solicitudes where DNI = t.DNI); for loop1 in solicitudesRecs do loop1.…
- Fred
- 4 mths ago
- Get help
- Reported - view
Re: Connect 2 entries
@FAIB-Delegaciones said: Database Solicituds <-> Database Personas DNI field in Solicituds DNI field in Personas If DNI > 0 (find the same DNI field in Solicituds and Personas),…
- Fred
- 4 mths ago
- Get help
- Reported - view
Re: Connect 2 entries
@FAIB-Delegaciones Are you talking about separate databases or separate tables?
- Fred
- 4 mths ago
- 1
- Get help
- Reported - view
Re: Formatting a field
@Fernando Vivas play around with the substring() command and see if you figure out how to get the first two digits into a variable. Then apply it to the last 4.…
- Fred
- 4 mths ago
- Get help
- Reported - view
Re: Connect 2 entries
Can you post a sample DB?
- Fred
- 4 mths ago
- Get help
- Reported - view
Re: Record the previous day's figure
@iliper LTD said: The problem is that when we create a new record of the same day for the next slot, it also copies this indicator of the previous slot,…
- Fred
- 4 mths ago
- Get help
- Reported - view
Re: Dynamic Printing Table layout
It has finally taken me this long to find out that@Eichelfr was right all along and I just couldn't wrap my wee brain around his answer. So yes, you have to use Table Styles to have your table print…
- Fred
- 4 mths ago
- Get help
- Reported - view
Re: Formatting a field
@Fernando Vivas Since@Nick separated the numbers into easy to use variables, you can just change the last line to: SSN := Num2 + "-" + Num3
- Fred
- 4 mths ago
- Get help
- Reported - view
Re: Record the previous day's figure
@iliper LTD can you tell me where this code is?
- Fred
- 4 mths ago
- Get help
- Reported - view
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
- 4 mths 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
- 4 mths 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
- 4 mths 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
- 4 mths 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
- 4 mths 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
- 4 mths 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
- 4 mths 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
- 4 mths 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
- 4 mths ago
- 1
- Get help
- Reported - view
Re: Dynamic Choice/Multi-Choice
What is the other option you want to add?
- Fred
- 4 mths ago
- Get help
- Reported - view

1 11 12 13 14 15 136

Back to top

Overview

View all topics