Skip to main content

Forum

Welcome to the Ninox community

Search all topics or ask a question

Badges

Latest Posts

Re: View of table sorted by date within groups
I'm not sure what you are trying to do with the min() command in the slice. Line 4, you ask Ninox to find the minium between 0 and a formula. If the formula is below 0 then it will select the lower…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Create lines for CSV
@Leo Woer said: The reason is that I don’t want my customer to be able to create csv from other places than the button If you are creating a DB for users,…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Create lines for CSV
@Leo Woer said: I haven't figured out out is, how to mark the records as handled when the csv has been created. I see you wrote this: for topLoop in select posteringslinier do "create new invoice…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Create lines for CSV
@Leo Woer We love seeing what people are doing. Please post the updated DB.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Create lines for CSV
@Leo Woer When you get a chance please mark the post answered. Thanks,
- Fred
- 1 yr ago
- Get help
- Reported - view
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

1 28 29 30 31 32 153

Back to top

Overview

View all topics