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…

• 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?

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.…

• Answered

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),…

• Answered

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.…

• 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).…

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.…