James
-
Select only hosts not working on a certain date from joined table.
We host events. Each event has a host. The host data is stored in a Host table. It is tied to the Event Details table via (N:1). What would the query be to populate a view of all hosts from Host…
-
How do I show only records for staff not already working on a specific date?
I have a Page where I want to show any staff not scheduled to work one of our events on a specific date. We have multiple events on a single date. - User selects a date - View would then show any…
-
Sub table query - limit to current record
I have a table -> Event Details and a subtable - Event Expenses. Each event can have expenses of different types, there is a "Type" field in the expense table.…
-
Query Help - Count of records in joined table that meet X criteria
I have a tables called Staff and Event Details. There is a join table called event_staff_join to show what gigs they worked. The join is "Relationship from Staff to event_staff_join (1:…
-
Information only appearing on refresh after new Ninox release
My team has been complaining that information that should be in a form is missing until they either refresh or log-out/log-in. Has anyone else experienced this since the new release?…
-
Admin Column Filters overriding individual user filters. Can I prevent this?
If I filter a column in a view by date for example, that filter overrides anyone else's date filters. Is there any way to avoid this? I am the only admin and it seems to be true regardless of whether…
-
Count of records in joined table
I have a table for our Corporate Events we plan called Event Details. There is a table named Staff that is joined to it containing all of our staff. One event could have multiple staff and a single…
-
Determine Net New customers via Select Statement for Dashboard
I would like a formula field that will represent the number of clients we have in a month that are first time customers. We are an event company. This will be via a field on a dashboard I'm creating.…
-
Different results using Checkbox vs Button to update text field with today() using the exact same code
I was having an issue with dates not storing correctly with some of my code. The code was storing dates as the next day instead of current day. While trying to figure out where my problems were…
-
Formula fields not visible to other users
I am attempting to create a dashboard and use a lot of formula fields to display data. However, when any other team member views the form, the fields are not showing up.…
-
How to create a field that displays all gigs worked within a range of dates?
I have the following tables Event Details, Staff, and a join called Event_Staff_Join. My payroll person would like to pull a list of staff that have worked any event between a date range.…
-
Multiple views have changed their column positions and formula columns have disappeared our cloud account. Why?
One view that used everyday just lost any formula columns I had created. It's like it rolled back to a super basic version of itself. Any idea why a view would do this?
-
Use Formula field to display subset of a linked table??
I have a table called "events". I then have a sub-table called "Expenses"(1:N). I want to create a formula field that only displays records from the Expenses table that have a specific type(one of…