Fred

San Francisco, USA

3701
591
5

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

My Posts

Latest Posts

Re: Modularity 3.10 how to relink the remote table (from DEV to Prod install)
You are lucky to have this problem.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Verify working time
The easiest way would be to always use a dashboard to enter in the hours so then you can check to see if the total is over 40 before writing the hours to the record.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Help with a search
Well I think I solved it: let z := for loop3 in x do let subArray := split(loop3, ","); { Group: loop3, Locs: y[var sub3 := text(RR); extractx(sub3, "\[(.+)\]", "$1") = text(loop3)].…
- Fred
- 1 yr ago
- Get help
- Reported - view
Help with a search

I'm trying to find records where a group of numbers match another set of numbers. Here is a demo of what I'm trying to do. let x := array(["545,577,831"], ["121,545,577"]); let y := [{ Loc: 115, RR:…
- Fred
- 1 yr ago
- 1reply
- 42
- Get help
- Answered
- Answered
Re: Verify working time
What do you want to happen when total hours is equal to 40? Do you want some data entry field to not respond? Do you want another field to change to alert you?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: button for Duplicate a record and its links to a sub table
@frsalabert oops, it should be: let t := this; for loop1 in Navire.Options do loop1.Offres := t end Sorry.
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Compound filter for a view
@Sam said: I was hoping to also have the dMC available as well so that it can represent an easy access to filtering for a list of favorites. I could do this with a switch or however you think it…
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: Fail to Read Data
I think you may have forgotten to upload the picture. Make sure you are using the latest version. If you are an still having problems, then it is an issue you should email Ninox about.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: New Ninox Version
Tried out the MacOS and there is a crash bug when you: 1) Open a table 2) Select Export Table 3) Select Ninox 4) Click Save As 5) Click Cancel when at the location window
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: Compound filter for a view
@Sam are you adding both dMC and reference? I thought you were moving away from dMC? Yes this post has the dMC solution, but no reference field.
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: Compound filter for a view
@Sam said: when you have a chance, please attach the small database showing how you handled the filter. here it is. Open the Quick View then go to the Tab tab.
Attachment
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: Coding a popup dialog in a for loop if error
You need to figure out a way to check for No hay Registros a Exportar o Existen Duplicados before you start the loop. So your if statement would be: if [check for Records or duplicates is true] then…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Dynamic reports with JSON formula - loop
It is hard to keep track of loops in the beginning. I find it easier if you rename your loop variables so they are unique so you can track which loop you are talking about.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Beginner: Database for research project - Transition from Excel
@andreas. eich. 1 said: only one table because it would be very wide Once you start using the DB, hopefully you can stop thinking of a spreadsheet and of a DB.…
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: Beginner: Database for research project - Transition from Excel
If it will always be 1:1 then why not just put all the data in the same record. You only need another table to store completely unrelated data or if you need to have more than 1 instance of the same…
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: Compound filter for a view
@SamIt does doesn't it. But since you have switched to a reference field you don't need to do the multi-count step. So line 8 use to run to line 10 now it stops at line 9.…
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: button for Duplicate a record and its links to a sub table
@frsalabert said: I have to link one by one all the vessel’s options to the offer (I hope it is clearer in the map table screenshots) to see them in the template.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Compound filter for a view
@Sam said: How would this read if using the reference field searching through the products table. I would be searching for just one product. With the dMC there are too many to easily search with the…
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: Compound filter for a view
@Sam Sorry, I thought I replied, but obviously I haven't. I'll get to something tomorrow (Dec 18) morning (PST). A reference field is a fine choice. I'm guessing you don't want to have to fill in all…
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: button for Duplicate a record and its links to a sub table
@frsalabert said: I would also like to link all those newly created options to an existing record in my Offer table. Do the Options need to be linked directly to an Offres?…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: button for Duplicate a record and its links to a sub table
@frsalabert said: I could duplicate a vessel and link its options to an existing offer or to a new one if it is too complicated script to access a dedicated record in the offer table Sounds like you…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Linking imported tables
oops, the code should use first() not unique(). let t := this; let findTable1 := first(select Table1 where Number = t.Number); Table1 := findTable1 and do as server let t := this;…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: file unzip Fail
@svs You can always access cloud DBs through a browser on any platform. The apps are buggy right now. but that will be fixed.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Linking imported tables
Have you already imported the table from FM? If so then you can try something like this in a button in Table2 : Table1 = master, Table2 = subject. The reference field names would be same in the…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Compound filter for a view
@Sam You must not have updated your app to 3.10.10. If so then DO NOT UPDATE. 3.10.10 breaks the export. I just tried on my iPhone and it does not work.
- Fred
- 1 yr ago
- Learn and share
- Reported - view

1 57 58 59 60 61 149

Welcome to the Ninox community

Fred

My Posts

Re: Modularity 3.10 how to relink the remote table (from DEV to Prod install)

Re: Verify working time

Re: Help with a search

Help with a search

Re: Verify working time

Re: button for Duplicate a record and its links to a sub table

Re: Compound filter for a view

Re: Fail to Read Data

Re: New Ninox Version

Re: Compound filter for a view

Re: Compound filter for a view

Re: Coding a popup dialog in a for loop if error

Re: Dynamic reports with JSON formula - loop

Re: Beginner: Database for research project - Transition from Excel

Re: Beginner: Database for research project - Transition from Excel

Re: Compound filter for a view

Re: button for Duplicate a record and its links to a sub table

Re: Compound filter for a view

Re: Compound filter for a view

Re: button for Duplicate a record and its links to a sub table

Re: button for Duplicate a record and its links to a sub table

Re: Linking imported tables

Re: file unzip Fail

Re: Linking imported tables

Re: Compound filter for a view

Overview