Fred's Profile | Ninox Community

Badges

Latest Posts

v3.11 announced

I'm sure you all got your v3.11 announcement email. We have a couple of weeks now to ponder what could be released. What do people hope for?
- Fred
- 1 yr ago
- 13replies
- 229
- Learn and share
Re: Conditional Formula Request
@Dave Irving This is the one I would recommend. If you stay with the 'where' then you should get faster results as Ninox only gets the records that match all requirements.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Conditional Formula Request
Just a bit of background, if you just put a field name as a filter requirement, in a bracket or after a 'where', then you are telling Ninox to find records that have data in that field.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Conditional Formula Request
is the choice field a simple choice? in the table you want to search is Enrolled Term also a choice field? if not what kind of field is it?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Reference field trigger error
@Sam Please mark the post answered when you get a chance.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Button to Send Message and Create Entry in Log
@adrianlavery If everything works, please mark the post answered when you get a chance.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Button to Send Message and Create Entry in Log
@adrianlavery said: I was sure the 'this' command would have done it. I need to know where to put 't' as the 'Groups' below isn't a field I created, but obviously the link between the two tables.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Reference field trigger error
This is an interesting question. If you take the exact code and put it in a button it works fine. I tried creating a dMC that is not dependent on the reference field and it still gives the same error.…
Attachment
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Updating records in the DB
@demo3678 Since importing Ninox archives doesn't allow Ninox to do any processing of data, you may want to look into exporting csv files and then importing them.…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Staff schedule
@demo3678 Are you saying you want to recreate this table view in Excel in Ninox? Or are you saying you want have this data that you want to import into Ninox?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Print Layout is not being saved
I'm sorry to say I don't have any issues with print layouts. Testing with 3.10.11 with iCloud DBs. I've done it as admin and non-admin (weird that it would allow you to add new print layouts not in…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Parse Dynamic Multiple Choice into JSON object
@Christoph Sander When you get a chance please mark this post answered. :)
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Parse Dynamic Multiple Choice into JSON object
@Christoph Sander glad it all worked out. Your code shows how you can build a quick db from data from other tables and relationships.
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Parse Dynamic Multiple Choice into JSON object
@Christoph Sander said: The swap of text and label was not the issue but the elements get grouped by entry instead of the other way around (as currently).…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Parse Dynamic Multiple Choice into JSON object
@Christoph Sander When I don't have any choices selected in the dMC I get: [] When I have selections in the dMC but the field is empty I see: [{},{}]
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Parse Dynamic Multiple Choice into JSON object
@Christoph Sander said: Any idea how I can put this upside down? entry, elements: [{label, text},{label, text}],... you just swap label and text. myMi.{ entry: 'parent entry', elements: { label:…
- Fred
- 1 yr ago
- Get help
- Reported - view
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

1 60 61 62 63 64 153

Welcome to the Ninox community

Fred

Re: Conditional Formula Request

Re: Conditional Formula Request

Re: Conditional Formula Request

Re: Reference field trigger error

Re: Button to Send Message and Create Entry in Log

Re: Button to Send Message and Create Entry in Log

Re: Reference field trigger error

Re: Updating records in the DB

Re: Staff schedule

Re: Print Layout is not being saved

Re: Parse Dynamic Multiple Choice into JSON object

Re: Parse Dynamic Multiple Choice into JSON object

Re: Parse Dynamic Multiple Choice into JSON object

Re: Parse Dynamic Multiple Choice into JSON object

Re: Parse Dynamic Multiple Choice into JSON object

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

Overview