Fred

San Francisco, USA

3743
594
5

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

My Posts

Latest Posts

Re: Update only some some children
if this is a one time action with the same data then you can use the Update Multiple Records function. 1) in your child table your would filter the dataset 2) click on the gear icon and select Update…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: How do i create a record on a SubTable button?
Hi Julian - Since Items is a child of Invoice, it seems like doing data entry from your Invoice table would be the better place to start? On your Invoice table,…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Filtering a view
You can create two tables or just one dashboard table and create tabs that show just motorcycle and cars. Dashboards are meant as a way to look into your data.…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Filtering a view
Have you considered "dashboards"? You would create another Table with only 1 record that shows only in full form view and pulls data from another table so you can look at summary data?…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Case statement
Ninox said they have hired a technical writer a few months ago. I guess they are still working on rewriting everything as we haven't seen any real improvement in the manual.
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Case statement
Can you give an example of what you mean by a case statement?
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: disappearing formulas
I stand corrected. My brain is bit muddled today.
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: disappearing formulas
Unless it is a child table, then Ninox considers any table relationship to be N:N. Like I said eariler, while your data might be 1:N, it could change so Ninox always treats related tables as N:N.…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: I add data, save it, then it's disappeared from the table. Tried all sorts of things to get started with this free trial. Help, I've got about 600 customer to enter...this is not working
Did you check that your table hasn't been filtered? Can you post screenshots of the issue?
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: YES / NO Default value
So managers do not see the form with the switches? But you want managers to have the ability to change the values on these fields? Do you make a new record every day and you want to carry over the…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: YES / NO Default value
If you want to set the default value, there is an option when you edit the field. Does that not work?
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: disappearing formulas
Are you pulling data from another table that is not a child of the current table? Can the other table have a N:N relationship to the current table, even if you only have data that is 1:N?…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: YES / NO Default value
So the only way these fields change from On/Off is for someone to manually do it? There is no formula anywhere that will change their value? If the above is true then I don't see how the values can…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Information is not displayed windows computer
So is everything OK now? It looks like your Ninox subscription plan is not active so I wouldn't expect things to work properly.
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: YES / NO Default value
Can you be a bit more specific? Nothing changes unless you tell it to so a bit more info would be helpful.
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Information is not displayed windows computer
Can you post a screenshot?
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Searching in a n:1:n table not working
Hi Robert - To clarify for myself, your catalogue table stores all items that you could have in your store. Your inventory table has a reference field to catalogue so you can list the items you…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Formula - Visual Vs Text
Hi ATDG - What do you mean by "display-only scenario"? You also didn't link to the "formula as described above 'visually'". Are you talking about switching between Visual and Text in a formula,…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Relational database design and functionality advice - linking groups of records at once
Hi Q - Well you do have lots of questions. I don't think I can answer all of them. But I can give you an idea of a solution to a small part of your problem.…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Concatenating
for the conditional formatting, what is it based on? another field? the concatenated text? An easy example is if we use already created third field. So we start with our new field, formCon.…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Concatenating
To concate two fields, you would create a new formula field and put this in the formula: concat(field1 + "," + field2) You can put anything inbetween the quotes to separate the two fields,…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: End time MINUS start time = total time in hours and minutes. Then total time X hourly rate = $xxx.xx
On the tutorial part? Nixous has some good videos on YouTube. There is a generic timesheet DB that you can look at. If you create a new DB you can select some Ninox template DBs and Timesheet is one…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: End time MINUS start time = total time in hours and minutes. Then total time X hourly rate = $xxx.xx
Hi John - Ninox time works in milliseconds. So if you have a start time fields and and an end time field, if you subtract start from end, Ninox will show you a time that makes sense to humans,…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Relational database design and functionality advice - linking groups of records at once
Hi Q - That is a lot to do. Let us start small. Let us tackle your package issue. You are correct you will need a new table. In fact you will need two new tables.…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Dashboard - limit to single record?
Hi Mel - Have you also created a new Form view then go back and delete the default "all" table view so it always open in Form view? If you need to go further, have you tried hidding the buttons?…
- Fred
- 4 yrs ago
- Learn and share
- Reported - view

1 136 137 138 139 140 150

Welcome to the Ninox community

Fred

My Posts

Re: Update only some some children

Re: How do i create a record on a SubTable button?

Re: Filtering a view

Re: Filtering a view

Re: Case statement

Re: Case statement

Re: disappearing formulas

Re: disappearing formulas

Re: I add data, save it, then it's disappeared from the table. Tried all sorts of things to get started with this free trial. Help, I've got about 600 customer to enter...this is not working

Re: YES / NO Default value

Re: YES / NO Default value

Re: disappearing formulas

Re: YES / NO Default value

Re: Information is not displayed windows computer

Re: YES / NO Default value

Re: Information is not displayed windows computer

Re: Searching in a n:1:n table not working

Re: Formula - Visual Vs Text

Re: Relational database design and functionality advice - linking groups of records at once

Re: Concatenating

Re: Concatenating

Re: End time MINUS start time = total time in hours and minutes. Then total time X hourly rate = $xxx.xx

Re: End time MINUS start time = total time in hours and minutes. Then total time X hourly rate = $xxx.xx

Re: Relational database design and functionality advice - linking groups of records at once

Re: Dashboard - limit to single record?

Overview