Fred

San Francisco, USA

3614
570
5

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

My Posts

Latest Posts

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
Re: calendar option missing
There are major issues with 3.10.10 app (any). So you will have to hang on and wait for a fix. You should email support just to make sure they know of all bugs.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Account flows
@Erik Ivan Bech You mean export the results of a view element? Not from the export menu item. Since the view element is just a window to other tables and not really in the current table.…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Compound filter for a view
@Sam I would love to but MacOS app 3.10.10 broke the export function and I don’t have a Pro account. What questions do you have?
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: Account flows
@Erik Ivan Bech @Erik Ivan Bech said: I basically need to create a separate Balance field for each in the ledger table like OpenBalance and ClosedBalance and have a corresponding script that filters…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Compound filter for a view
@Sam said: I am able to search for a product purchased within a given date range by using another dMC field for products. Do you think it is possible to filter for both at the same time?…
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: Constraints issue
@Alan Cooke said: there are 4 buildings of which I have selected 3. At a later date I want to add the 4th building. When I click Create record and get the list of buildings I only want to see 4 since…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Lead Scoring Assistance
@Dave Irving The contains() command needs an array/string and a single item to check. With multiple choice (regular or dynamic) you should use the numbers() command and not chosen() command.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Does the 'page' feaure work on tablet devices?
seems like there are quite a few big bugs in the app version of 3.10.10. you should wait, not with baited breath, for the next version.,
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Compound filter for a view
@Sam said: You are spot on with the second one. They both do the same thing. Is the 2nd one faster?
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: Alert not working
alert() does not work inside a do as server. You are basically telling Ninox to alert the server.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Create a Date showing Day of Week, Month, Day of week
Take a look at the format() function. You would create a formula field with the code.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Constraints issue
@Alan Cooke said: The first part of the constraint limits Buildings to Organisation. What I need is to limit the Buildings to only those not previously selected.…
- Fred
- 1 yr ago
- Get help
- Reported - view

1 54 55 56 57 58 145

Welcome to the Ninox community

Fred

My Posts

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

Re: calendar option missing

Re: Account flows

Re: Compound filter for a view

Re: Account flows

Re: Compound filter for a view

Re: Constraints issue

Re: Lead Scoring Assistance

Re: Does the 'page' feaure work on tablet devices?

Re: Compound filter for a view

Re: Alert not working

Re: Create a Date showing Day of Week, Month, Day of week

Re: Constraints issue

Overview