Skip to main content

Forum

Welcome to the Ninox community

Search all topics or ask a question

Badges

Latest Posts

Re: Styled text
@iliper LTD Is RESULT a number? What happens if you put RESULT in place of AA?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Create lines for CSV
It looks like you want to take a flat table (where you have fields like item 1, item 2, item 3) and want to create a more relational structure. That is a very good idea and will make things easier in…
Attachment
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Dynamic printing and join tables
Ok, so I've had a chance to try it out and I'm able to get this from a table called Production: the template looks like: ProductionItem is a table that links Production (N:1) and Materials (N:1).…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Copy record Id failing
you can try just using me instead of me.Id.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Dynamic printing and join tables
I haven't tried it out, but maybe try: {d.Prog_Staff.Staff[i].Name} {d.Prog_Staff.Staff[i+1].Name} I would think it would be at the Staff level since that is where you really want it to iterate.…
- Fred
- 1 yr ago
- Get help
- Reported - view
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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr ago
- Get help
- Reported - view
Re: Connect 2 entries
@FAIB-Delegaciones Are you talking about separate databases or separate tables?
- Fred
- 1 yr 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
- 1 yr ago
- Get help
- Reported - view
Re: Connect 2 entries
Can you post a sample DB?
- Fred
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr ago
- Get help
- Reported - view
Re: Record the previous day's figure
@iliper LTD can you tell me where this code is?
- Fred
- 1 yr 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
- 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

1 29 30 31 32 33 154

Back to top

Overview

View all topics