Fred

San Francisco, USA

3395
538
4

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

My Posts

Latest Posts

Re: Parse Dynamic Multiple Choice into JSON object
Thankfully Ninox has an easier way of creating JSONs. This method is very handy for dynamic printing and creating new DB within a your DB so you can create HTML tables.…
- Fred
- 1 yr ago
- 3
- Get help
- Reported - view
Re: Linking tables after importing from database
@bonniegruber said: The names and addresses are not unique. Could I rename the Addresses.id field to "link" or something else and make that work? No need to change field names,…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Linking tables after importing from database
@bonniegruber but since there is no link we need other info to use to create the links. you can use name or address.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Linking tables after importing from database
@bonniegruber The DB you provided does not have info for me to work with. Is that all the fields you have in Christmas Cards?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Linking tables after importing from database
@bonniegruber Looking closer at your data the Christmas Card.Link field refers to numbers that are not in Addresses.Id so won't work. What did you have in mind to use to link Christmas Card to…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Linking tables after importing from database
@bonniegruber Now can you tell me how a record in Christmas Cards links to a record in Addresses? Is it through the field Christmas Card.Link to Addresses.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Linking tables after importing from database
@bonniegruber yes, you can automate a lot of Ninox. What are you going to do? Can you post a sample DB, no personal info, so we can see how you have it setup?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Interesting HTML formatting
I spent some more time with trying to create a master style sheet for my forms. I came up with the attached example. Check out the CSS example page (yes, my real first use of a Page).…
Attachment
- Fred
- 1 yr ago
- 2
- Learn and share
- Reported - view
Re: Need Assistance with Creating a Search Button and Displaying Results in a Table
Welcome to Ninox and its sad state of documentation. You should look into dashboards. There are some good ones from Nioxus and Ninox. Your Search table could become your dashboard to access data in…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Interesting HTML formatting
To use this to your advantage, I thought you could create a field that you can use as your 'style sheet' put that at the end of your form and not display it,…
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: Interesting HTML formatting
@Sean nice. That is a funny thing to happen.
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Interesting HTML formatting

Hi all - I've been adding HTML tables to my dashboards as they make things prettier and compact. So I found when you have multiple HTML formula fields, you can't change the color of only 1 of them.…
- Fred
- 1 yr ago
- 18replies
- 510
- 3
- Learn and share
Re: Linking tables after importing from database
@bonniegruber Sounds like you need a new N:N (many to many) table. Normally you have a 1:N (1 to many) link between tables, but since you said: @bonniegruber said:…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: For the question of using N:1 search
Let me guess that this is what is happening. Take a look at the attached DB. If you open the Dashboard table you will see two reference fields Table1 and TableA.…
Attachment
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: For the question of using N:1 search
@我是我的我 Can you post a test DB? My Chinese is not very good.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: For the question of using N:1 search
Just to confirm, you are searching on a reference field popup? You added the field web as a column but it is through a reference field?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Staff schedule
Can you be more specific with what you want to happen? For example, in [table name], I want to be able to see all employee linked and their start time. Maybe explain the work flow you are trying to…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Updating records in the DB
@demo3678 wrote Looks like that is a limitation of the Ninox DB import. There is no way to do any checking before importing. Question: After importing do you start fresh and delete the data in DMO…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Updating records in the DB
Under Import Mode what are you selecting? In the field window are you selecting a field to be the Key so Ninox knows if it is new data or updated data?
- Fred
- 1 yr ago
- Get help
- Reported - view
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
- 39
- 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

1 44 45 46 47 48 136

Welcome to the Ninox community

Fred

My Posts

Re: Parse Dynamic Multiple Choice into JSON object

Re: Linking tables after importing from database

Re: Linking tables after importing from database

Re: Linking tables after importing from database

Re: Linking tables after importing from database

Re: Linking tables after importing from database

Re: Linking tables after importing from database

Re: Interesting HTML formatting

Re: Need Assistance with Creating a Search Button and Displaying Results in a Table

Re: Interesting HTML formatting

Re: Interesting HTML formatting

Re: Linking tables after importing from database

Re: For the question of using N:1 search

Re: For the question of using N:1 search

Re: For the question of using N:1 search

Re: Staff schedule

Re: Updating records in the DB

Re: Updating records in the DB

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

Overview