Skip to main content

Welcome to the Ninox community

Search all topics or ask a question

aztory

aztory

16
0
0

Joined: Thu Apr 25 02:04:40 UTC 2019

My Posts

Latest Posts

Add to Ninox icons

Is it possible to add to the Ninox icons? (01_iconset.ninox) I have copied some of the emojis, but would like to be able to add them to the iconset.
- aztory
- 5 yrs ago
- 1reply
- 988
- Get help
Re: Calculate a future date
I broke the miles string apart from the months and tested each individually. Each worked as desired. My next step is to end the string at eye end of miles with “end” then insert the Months string.…
- aztory
- 5 yrs ago
- Get help
- Reported - view
Re: Calculate a future date
I see your formula is different - is that for your test?
- aztory
- 5 yrs ago
- Get help
- Reported - view
Re: Calculate a future date
Yes sir, it is empty.
- aztory
- 5 yrs ago
- Get help
- Reported - view
Re: Calculate a future date
Yes sir, it is a formula field. I have a database to track vehicle maintenance. Part of the information is inspection or replacement. Some requirements are based on Months, others on Miles.…
- aztory
- 5 yrs ago
- Get help
- Reported - view
Re: Calculate a future date
Thank you. I tried that but it returns a huge number in the field. At first I thought it was the number of seconds in a year, but it is much larger than 31,557,600. Surely im doing something wrong!
- aztory
- 5 yrs ago
- Get help
- Reported - view
Re: Calculate a future date
Entered this strig: if 'Service Type' = 4 and 'Miles or Months' = 2 and Item = 8 thentoday() + 365else it works, but returns a very large number. How can I change it to show a future date?…
- aztory
- 5 yrs ago
- Get help
- Reported - view
Calculate a future date

Am a new user, have developed a database for vehicle service. I want to calculate months (6, 12, 18, 36) from the completed date that the next inspection is due.…
- aztory
- 5 yrs ago
- 12replies
- 3340
- Get help
Automatically populate fields in new record

I have a flat file database on my iPhone that I use to track data during travels in my RV. I initiate a new record each day. Of the 28 fields, I would like the new record to populate data from the…
- aztory
- 6 yrs ago
- 1reply
- 1220
- Get help
Re: Question
SUCCESS!! Thank you for your perseverance!
- aztory
- 6 yrs ago
- Get help
- Reported - view
Re: Question
Thank you again. Who knew there were 4 types of quotes? The code was accepted - it just didn’t work. Will keep trying before I give up and go back to my File Maker Pro v4.0 on my PC.
- aztory
- 6 yrs ago
- Get help
- Reported - view
Re: Question
Thanks again. Here is what I entered (3 times) and received the ERR message let prvId := number (last(select ‘Test table’) .Id) - 1; let newRec := this; newRec.…
- aztory
- 6 yrs ago
- Get help
- Reported - view
Re: Question
Thank you sir for your efforts, but I still get an ERR i have difficulty separating the code from comments. Plus the ERR just tells me something is wrong.…
- aztory
- 6 yrs ago
- Get help
- Reported - view
Re: Question
I carefully typed in your your string and got the following: ERR (“Expression expected”) i have an expression, but it’s probably not appropriate here.
- aztory
- 6 yrs ago
- Get help
- Reported - view
Re: Question
Sean, Re: your script to enter a City and State in a new record. let prvId := number(last(select Table1).Id) - 1;let newRec := this;newRec.(City := text((select Table1)[Id = prvId].City));newRec.…
- aztory
- 6 yrs ago
- Get help
- Reported - view
Populate a field in a new record

I have a database where I would like to populate some fields in a new record from a previous record. Instead of entering the values, I would like the field to automatically enter data from the last…
- aztory
- 6 yrs ago
- 1reply
- 1235
- Get help

Back to top

Overview

View all topics