Fred

San Francisco, USA

3380
533
4

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

My Posts

Latest Posts

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
- 6 mths 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
- 6 mths 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
- 7 mths 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
- 7 mths 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
- 7 mths ago
- Learn and Share
- Reported - view
Re: A consequence of proper DB design...
@Mel Charles there are some interesting 3.13 features announced.
- Fred
- 7 mths 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
- 7 mths 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
- 7 mths 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
- 7 mths 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
- 7 mths 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
- 7 mths 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
- 7 mths 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
- 7 mths 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
- 7 mths ago
- 4replies
- 64
- 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
- 7 mths 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
- 7 mths 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
- 7 mths 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
- 7 mths 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
- 7 mths ago
- Get help
- Reported - view
Re: If condition not working with comparison operators
@Vermaji My response to this would be to look into using dashboards, sorry for sounding like a broken record. I do agree that the discount and VAT fields should be static fields.…
- Fred
- 7 mths ago
- Get help
- Reported - view
Re: If condition not working with comparison operators
@Vermaji said: 2. How to write comments inside a script. It becomes very difficult to write code without comments. There are two ways: 1) you can use double quotes, " ", followed by a semi-colon, ;.…
- Fred
- 7 mths ago
- Get help
- Reported - view
Re: If condition not working with comparison operators
I would second@我是我的我 opinion to use a switch as it will make things easier to read and troubleshoot.
- Fred
- 7 mths ago
- Get help
- Reported - view
Re: If condition not working with comparison operators
Well I got this to work for me: let currentDate := today(); let invoiceDueDate := 'Due Date'; let currentInvoiceStatus := number('Invoice Status'); let overdueDays := days(invoiceDueDate,…
- Fred
- 7 mths ago
- Get help
- Reported - view
Re: Way to Assign multiples fields to another table.
@Rafael that is a good start. Try this: let x := for loop1 in numbers('Category & Rate') do record('Hours by Resources',loop1).'Rate bt Categ' end; sum(x)
- Fred
- 7 mths ago
- 1
- Get help
- Reported - view
Re: Way to Assign multiples fields to another table.
@Rafael if you need a hint on how to get started, try setting a variable using the record() command inside a for loop with the numbers() command around the dynamic multi choice field.…
- Fred
- 7 mths ago
- Get help
- Reported - view

1 21 22 23 24 25 136

Welcome to the Ninox community

Fred

My Posts

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

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

Re: Way to Assign multiples fields to another table.

Re: Way to Assign multiples fields to another table.

Overview