Fred's Profile | Ninox Community

Badges

Latest Posts

Re: Regarding the issue of matching records after splitting the data.
1) How does the number of records in Create affect the number to create of Invoices? What if you have 5 records in Create then want to create 3 Invoices then want to create 10 Invoices?…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Script Error on line 15
@Rafael said: Categories is a Choice (dynamic) and yes is pointing to Catgories table. Ok, so then you don't need for loop as there is only 1 selection.…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Script Error on line 15
Just to verify: 1) Categories is a dynamic multi choice field. Your comment says it is a dynamic choice field. 2) is the dynamic field pointing to the Categories table?…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Formulate View field from multiple date entries?
Well I tried this: let xbeg := 'Start.Date'; let xend := 'End.Date'; select Fitting where date('Fitting Date/Time') >= xbeg and date('Fitting Date/Time') <= xend or date('2nd Fit Date') >= xbeg and…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Formulate View field from multiple date entries?
@James can you upload another one that is not locked? can you add some test data?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Formulate View field from multiple date entries?
@James so where is this view element?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Formulate View field from multiple date entries?
@James So yes, duplicate the DB and remove any personal info. Go into Admin Mode. Click on the DB name in the top left corner. You should see a button for Export Data. Click it.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Formulate View field from multiple date entries?
@James said: what would you mean by a different db design as such? Many users, myself as the leader, fall into incorrect DB design when they are starting out.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Formulate View field from multiple date entries?
@James are you using the app or the browser? if the browser which level of subscription do you have?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Formulate View field from multiple date entries?
@James said: but I have just tried and it still doesn't get it to work unfortunately Can you provide a sample DB?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Input trigger discrepancy
@Yoyo Gam If you have an issue, please start a new post with what you are trying to achieve, copy of your code, relevant field name and types, and if you want a sample DB attached.
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: A consequence of proper DB design...
@Mel Charles there are some interesting 3.13 features announced.
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: playing with arrays
@Chris I didn't put the writable if code in all of the fields, just way too many. You can check out R9C1 to see an example. My thought process is that you would fill in the initial boxes with numbers,…
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: News on 3.13 Ninox
The big thing, for me, is being able to reference fields with their user friendly name. Now you don't have to have to hard code the field name when referencing them. That is amazing.…
- Fred
- 1 yr ago
- 2
- Learn and share
- Reported - view
Re: playing with arrays
Here is a mock up. There isn't an easy way to do create an interface that you ask for. You can either have an input field or a formula field, but not one that can do both.…
Attachment
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: playing with arrays
Or instead of creating/deleting child records with each input/deleting of value, the Lock button could create all child records necessary (since you need them all), then only lock those with data.…
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: A consequence of proper DB design...
@Mel Charleswell, the 2GB limit is nice. I can now also personalize my background of table view. I should try to some API or dynamic printing. You can create manual backups which then allow you to…
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: Buttons in Tables View (Ansicht) needed
@Michael Blechinger Very pretty. I could never make anything this nice. I try and it comes out a big mess. It would be easier for us if can you post a sample DB,…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: playing with arrays
Interesting question. The way I would go about it is to create a child table that stores the input, corresponding field, and the column/row/small square info.…
- Fred
- 1 yr ago
- Learn and share
- Reported - view
A consequence of proper DB design...

As you know I've been updating my DB structure, which means I'm creating more records. Well, by creating more records mean that I am now over my 50,000 record limit of the starter level.…
- Fred
- 1 yr ago
- 4replies
- 77
- Learn and share
Re: Buttons in Tables View (Ansicht) needed
Are you trying to do this within the same table? If so then I would recommend that you try using a dashboard. It may seem like you are duplicating work,…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: If condition not working with comparison operators
@Vermaji I am definitely not a professional. Just another user helping others out. I use the cloud because the app went free and they started taking a long time between updating the app after the…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: If condition not working with comparison operators
@Vermaji I don't hide things at all since I'm the only user. So play around and see what happens. You can't do anything that you can't undo. Everything shows up under admin mode so no need to worry.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: If condition not working with comparison operators
@Vermaji isn’t the hide user interface the section you want?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: If condition not working with comparison operators
@Vermaji said: Is it possible to hide the Table view when we open a database and go straight to the Switchboard Look in the Options for the DB.
- Fred
- 1 yr ago
- Get help
- Reported - view

1 38 39 40 41 42 153

Welcome to the Ninox community

Fred

Re: Regarding the issue of matching records after splitting the data.

Re: Script Error on line 15

Re: Script Error on line 15

Re: Formulate View field from multiple date entries?

Re: Formulate View field from multiple date entries?

Re: Formulate View field from multiple date entries?

Re: Formulate View field from multiple date entries?

Re: Formulate View field from multiple date entries?

Re: Formulate View field from multiple date entries?

Re: Formulate View field from multiple date entries?

Re: Input trigger discrepancy

Re: A consequence of proper DB design...

Re: playing with arrays

Re: News on 3.13 Ninox

Re: playing with arrays

Re: playing with arrays

Re: A consequence of proper DB design...

Re: Buttons in Tables View (Ansicht) needed

Re: playing with arrays

Re: Buttons in Tables View (Ansicht) needed

Re: If condition not working with comparison operators

Re: If condition not working with comparison operators

Re: If condition not working with comparison operators

Re: If condition not working with comparison operators

Overview