Skip to main content

Forum

Welcome to the Ninox community

Search all topics or ask a question

Fred

Fred

San Francisco, USA

3609
568
5

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

My Posts

Latest Posts

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
- 9 mths 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
- 9 mths ago
- Get help
- Reported - view
Re: Create lines for CSV
@Leo Woer When you get a chance please mark the post answered. Thanks,
- Fred
- 9 mths 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
- 9 mths 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
- 9 mths 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
- 9 mths ago
- Get help
- Reported - view
Re: Copy record Id failing
you can try just using me instead of me.Id.
- Fred
- 9 mths 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
- 9 mths 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
- 9 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
- 9 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
- 9 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
- 9 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
- 9 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
- 9 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
- 9 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
- 9 mths ago
- Get help
- Reported - view
Re: Connect 2 entries
@FAIB-Delegaciones Are you talking about separate databases or separate tables?
- Fred
- 9 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
- 9 mths ago
- Get help
- Reported - view
Re: Connect 2 entries
Can you post a sample DB?
- Fred
- 9 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
- 9 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
- 9 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
- 9 mths ago
- Get help
- Reported - view
Re: Record the previous day's figure
@iliper LTD can you tell me where this code is?
- Fred
- 9 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
- 9 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
- 9 mths ago
- Get help
- Reported - view

1 20 21 22 23 24 145

Back to top

Overview

View all topics