How to enable Javascript

Latest Posts

Re: Change lookup field based on the year @Fred Thanks again for your help and expertise. Chris
- Chris
- Truck Driver
- Chris.6
- 3 days ago
- Get help
- Reported - view
Change lookup field based on the year
I need to look up one of two fields depending on the year. The two fields are labeled as follows: ‘2022-HHG-Mileage’ and ‘2023-HHG-Mileage’. Then, the correct field name needs to be inserted in the…
- Chris
- Truck Driver
- Chris.6
- updated 3 days ago
- 2replies
- 34
- Get help
- Answered
- Answered
Right Justify
1: How can I right justify a text field? 2: How can I right justify the sum, count, etc., of a column in a table?
- Chris
- Truck Driver
- Chris.6
- updated 10 days ago
- 1reply
- 26
- Get help
Re: Creation Date Would love to have this feature! Unfortunately, I don’t think it is working on iOS, which is what I use.
- Chris
- Truck Driver
- Chris.6
- 11 days ago
- Get help
- Reported - view
Re: Mileage Chart Spreadsheet to Ninox Table @Fred Thanks for the reply. Yes, and Thank You! Your example is definitely a way to look up the paid miles! The work flow got me confused, as I have no need to track miles by the day;…
- Chris
- Truck Driver
- Chris.6
- 12 days ago
- Get help
- Reported - view
Re: Mileage Chart Spreadsheet to Ninox Table @Fred Thanks for taking a crack at my problem. Your “two cents” might get me on a path to figure this out. Please see my reply to the topic for more context.
- Chris
- Truck Driver
- Chris.6
- 2 wk ago
- Get help
- Reported - view
Re: Mileage Chart Spreadsheet to Ninox Table @RoSoft_Steven Thanks for the suggestions. Unfortunately, Google is for cars, and I need information for Commercial Truck Driving. See more context in my reply to the topic below.
- Chris
- Truck Driver
- Chris.6
- 2 wk ago
- Get help
- Reported - view
Re: Mileage Chart Spreadsheet to Ninox Table Thanks for your suggestions. Allow me to add some context that may help explain how I need to use the Mileage Look Up Table. Unfortunately, as a truck driver,…
- Chris
- Truck Driver
- Chris.6
- 2 wk ago
- Get help
- Reported - view
Mileage Chart Spreadsheet to Ninox Table
What would be the best way to put the data from a Mileage Chart Spreadsheet into a Ninox Table for look up? These are the fields that I am thinking of…Origin, Destination, Mileage.…
- Chris
- Truck Driver
- Chris.6
- updated 1 mth ago
- 7replies
- 94
- Get help
- Answered
- Answered
Re: Count number of fields containing zero @Fred Actually, I’m not tracking my Hometime. I just know that I must have been on Hometime, if the following pay period has zero miles. It’s a good idea, Fred!…
- Chris
- Truck Driver
- Chris.6
- 3 mths ago
- Get help
- Reported - view
Re: Count number of fields containing zero @John Halls thanks for the reply and the information. I hope some background will help find a better way These figures and fields are in a dashboard that Nioxus helped me set up.…
- Chris
- Truck Driver
- Chris.6
- 3 mths ago
- Get help
- Reported - view
Count number of fields containing zero
In a table, I have 14 fields (this week, this week - 1, this week -2, this week -3, and so on, until I have the total miles in a field from 13 weeks ago),…
- Chris
- Truck Driver
- Chris.6
- 3 mths ago
- 5replies
- 65
- Get help
- Answered
- Answered
Re: Define start of fiscal year Figure it out! let tempDate := year('Pay Period End'); let offset := (select FiscalYear)['Calendar Year Number' = tempDate].'Offset Days'; let offsetN := number(offset); let FiscalYearWeek :…
- Chris
- Truck Driver
- Chris.6
- 3 mths ago
- Get help
- Reported - view
Re: Define start of fiscal year Actually, let fiscalYearWeek:=yearweek(tempDate-offset) should actually be… let fiscalYearWeek := yearweek(‘Pay Period Start’ - offset) but I still get the same invalid operator error.
- Chris
- Truck Driver
- Chris.6
- 3 mths ago
- Get help
- Reported - view
Re: Define start of fiscal year Okay, I am finally able to look up and display the offset days with the following script, where ‘Pay Period End’ is a date field for the start of the pay period (which should always be a Monday);…
- Chris
- Truck Driver
- Chris.6
- 3 mths ago
- Get help
- Reported - view
Re: Define start of fiscal year I’ve been trying to figure out a look up formula for a few hours and can’t seem to figure it out. Obviously, the magic happens within… “…look up year(tempDate) in the new table by using the select…
- Chris
- Truck Driver
- Chris.6
- 3 mths ago
- Get help
- Reported - view
Re: Define start of fiscal year I guess I need help with the syntax of looking up the year(tempDate) using the select command. I have created a Table called ‘FiscalYear Offset Days’ The table consists of two fields:…
- Chris
- Truck Driver
- Chris.6
- 3 mths ago
- Get help
- Reported - view
Re: Define start of fiscal year Thanks Paul. I’ll try it out!
- Chris
- Truck Driver
- Chris.6
- 3 mths ago
- Get help
- Reported - view
Define start of fiscal year
I can use the function yearweek() to define the week number within the year, but that does not sync with my employer’s fiscal year, which begins on the first Monday of the new year.…
- Chris
- Truck Driver
- Chris.6
- 3 mths ago
- 8replies
- 63
- Get help
- Answered
- Answered
4 week running average
As a truck driver, I get paid by the mile. I need help figuring out how to look up and calculate the average miles driven in the last 4 weeks (6 weeks, 13 weeks).…
- Chris
- Truck Driver
- Chris.6
- 1 yr ago
- 97
- Get help
Re: Need formula for Button to create a new multi line text field By the way, your initial solution is exactly what I was looking to do...initially, and it answers my initial question, perfectly. But I think that your linked table solution will be more elegant in…
- Chris
- Truck Driver
- Chris.6
- 1 yr ago
- Get help
- Reported - view
Re: Need formula for Button to create a new multi line text field Thanks so much Mel. I figured that there must be a better way to do what I want. I think you guessed at my true intent, so... Would you mind going into a little more detail how you would accomplish…
- Chris
- Truck Driver
- Chris.6
- 1 yr ago
- Get help
- Reported - view
Need formula for Button to create a new multi line text field
I would like to make a button that would create a new multiline text field within the current record. This way, I could add a new note/comment as needed, for each record.…
- Chris
- Truck Driver
- Chris.6
- 1 yr ago
- 4replies
- 167
- Get help

Chris

Chris.6

Truck Driver

23
0
0

Joined: 18 Jan 2022

Follow

Currently using Ninox as a solution to keep track of my Truck Driver pay.