Technical Help / explain this code for selection with where condition
Hello, I saw an example to display views with a filter on a multiple combox. I looked at the code and got a little lost. Can someone explain this to me with the where? Thank you in advance. Sample database in the section Webinar EN 2019 and name data base 100_Selected_Things
Technical Help / Attendance record
I am not quite there yet.. First hack is as follows... the defect is that when taking attendance.. it shows ALL students. Second hack.. Have the Attendance subtable reference the class roster. The drawback here.. When taking attendance within a session .. when looking up against the Roster.. it shows the roster for ALL Classes.. (hence your earlier comment about using a view to filter to just the
Technical Help / Need to Match show rows from a table if email field matches
Hello and good day! I have a table called "Events" where I record emails from or to different Contacts. I have a table called "Contacts" and I'm adding a view to this table where I want to show "Events" just if the fields EmailFrom or EmailTo are = to the Contacts table field called "WorkEmail".I used the formula as shown in the screen but it is not recognizing the field "WorkEmail" which is avail
Technical Help / 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, when you click on a record you will see a view of your Invoice Items table with an Add Record button. If you really want to use a button from your Items table, you can do something like: let xCFT := (create FirstTable);let xCST := (create
Technical Help / Search Inside a Table on Ipad, Apple IOS
@Sean; your suggestion about to open a matching record without clicking using the code below works perfectly... Is it possible to modify this code so that the cursor remains within that "Part Number" field? Currently, you still have to click this field to put the cursor back in (so you can search another record) after you have found your first matching record. This means it is not as fast and easy
Technical Help / Is there a better way to filter selected table for View Layout Element?
Is there a built in way to filter linked Id's for the View element? This is what I have right now... It works, but it is static. The filter is hard coded and I don't see any way to make it automatically adjust for the number of records. Is there a way to code it dynamically?
Technical Help / Showing top performers based on linked records
Okay so I have 3 tables: - Coaches - Challenges - - Participants I then have a dashboard table. I currently have a view with the following formula: let m := Month;(select Coaches).Participants[Challenges.Month = m] I then 'count' the month column of the view, which tells me how many participants each coach has. My problem is that I cant sort that high-low since I'm using the view filter, and not a
Technical Help / Ninox HTTP Calls syntax
@Sean.. I have been kicking the Ninox tires for a bit now.. I have developed some applications that I use such as.. a slant on David Allen's "Getting Things Done" methodology... I call it Getting Sh** Done (GSD) .. LOL.. simple tasks and kanban cards.. I also developed an application that tracks all my Statements Of Work (SOWs) and provides a 30 / 60 / 90 view.. and of course.. my first and favori
Technical Help / First page is blank in Safari and/or Chrome when using PRINT PDF to print long multi-line fields over many pages.
Hi Off-Grid, Thanks for your response and help. What you have described is also what I have experienced. For us, as with almost 99.9999% users, the ability to output data sets in useable formats is at least 50% of why we use a database to store, measure and manipulate data. We have found that it is easy to get a usable format in the app that can be printed as a PDF. We even found that we can achie
Technical Help / Can we link a field to a table view?
another things, I will make a table with all adress and make another table with client info (name, date of birth) and make another table wich linked client and their respectives adresse.I also have a table that contain client and adresse with date. on access it have query, that create a kind of table with all client and all adresse with criteria. So I can make a query with all client and their mos