Mr. K.'s Profile | Ninox community

Badges

Latest Posts

Re: Show Date as Year Only
Got it. Then in my case, I will delete the date field and create a number field. That will work.
- Mr_K
- 7 yrs ago
- Get help
- Reported - view
Re: Use a number in a choice field as a multiplier of a number field?
Steven, that works great. Thanks. I would like to take this a bit further. My choice field is for commission rates with entries like 50%, 40%, 30%. The formula number(text(Choicefield)) * NumberField…
- Mr_K
- 7 yrs ago
- Get help
- Reported - view
Re: Use a number in a choice field as a multiplier of a number field?
Oh how badly this forum needs an update so a person can edit their post. So my question is: How can I use a number in a choice field as a multiplier of a number field?
- Mr_K
- 7 yrs ago
- Get help
- Reported - view
Use a number in a choice field as a multiplier of a number field?

How can this be done?
- Mr_K
- 7 yrs ago
- 7replies
- 1373
- Get help
Re: Show Date as Year Only
- Mr_K
- 7 yrs ago
- Get help
- Reported - view
Re: Show Date as Year Only
Obviously, I'm not placing the code in the correct place. Where doe it go? I still see the date as Jan 1, 2008
- Mr_K
- 7 yrs ago
- Get help
- Reported - view
Show Date as Year Only

I have a date field named Vintage. How do I format it to only show the year, like 2008?
- Mr_K
- 7 yrs ago
- 5replies
- 1620
- Get help
Re: Find Screen?
Sure wish I could edit posts!
- Mr_K
- 7 yrs ago
- Get help
- Reported - view
Re: Find Screen?
Sorry, I accidentally blurred the Colum headers, but you get the idea.
- Mr_K
- 7 yrs ago
- Get help
- Reported - view
Find Screen?

Where does Ninox pick up the column headers from? My table does not look like that, nor do any of my views.
- Mr_K
- 7 yrs ago
- 4replies
- 1059
- Get help
Re: Formula Help Needed to Hide a Space Field Layout Element.
Mconneen, thanks again for the formula. I used it in a few more places on my form, and it will be very good to have for future use.
- Mr_K
- 7 yrs ago
- Get help
- Reported - view
Re: Formula Help Needed to Hide a Space Field Layout Element.
Oops, You had it right. Switched around is backwards.
- Mr_K
- 7 yrs ago
- Get help
- Reported - view
Re: Formula Help Needed to Hide a Space Field Layout Element.
Thanks much for the formula. I believe that formula shows the Space field when the "choice" in the Status field is Active. I switched the true and false around,…
- Mr_K
- 7 yrs ago
- Get help
- Reported - view
Re: Formula Help Needed to Hide a Space Field Layout Element.
That should read choice field, not chosen field.
- Mr_K
- 7 yrs ago
- Get help
- Reported - view
Formula Help Needed to Hide a Space Field Layout Element.

What would the "display field only if" formula be to hide a space field element? I need the space hidden when "Active" is select in my chosen field name Status.…
- Mr_K
- 7 yrs ago
- 5replies
- 1489
- Get help
Re: Search Dashboard Formula Help Please.
That's it! Thank you, thank you, thank you, Steven! Now I want to change the search field into a choice field to make my searches faster and easier. I'll play with it a bit on my own and ask for help…
- Mr_K
- 7 yrs ago
- Get help
- Reported - view
Re: Display field only, if: either of two other fields has no data?
I've been told that as well. Can't happen too soon!
- Mr_K
- 7 yrs ago
- Get help
- Reported - view
Re: Search Dashboard Formula Help Please.
I see I missed a '
- Mr_K
- 7 yrs ago
- Get help
- Reported - view
Re: Search Dashboard Formula Help Please.
Not quite there yet. Please revise. Thanks. This is what I see:
- Mr_K
- 7 yrs ago
- Get help
- Reported - view
Re: Display field only, if: either of two other fields has no data?
Thank you, Steven! That works perfectly. There's no way I would have ever figured out that code on my own. And you are so right, this forum needs an update badly.…
- Mr_K
- 7 yrs ago
- Get help
- Reported - view
Search Dashboard Formula Help Please.

I'm trying to create a search dashboard. I have it set up, I'm close, but I don't have the formula correct. Here's what I've done so far: 1) I created a From, added a view field,…
- Mr_K
- 7 yrs ago
- 9replies
- 2074
- Get help
Re: Display field only, if: either of two other fields has no data?
That's enter "data"
- Mr_K
- 7 yrs ago
- Get help
- Reported - view
Re: Display field only, if: either of two other fields has no data?
Mac, and that is the formula I am using. When I enter day into Email 1, the third field (the one the formula is added to Display field only, if:) is still visible.…
- Mr_K
- 7 yrs ago
- Get help
- Reported - view
Re: Display field only, if: either of two other fields has no data?
OK, but that still does not work to check if either one has data. Now the formula 'Email 1' = null or length(text('Phone 1')) = 0 only hides the Display field only, if:…
- Mr_K
- 7 yrs ago
- Get help
- Reported - view
Re: Display field only, if: either of two other fields has no data?
Actually, I did another test, and that formula only works if there is data in the Email 1 field. There is no change when there is no data in Email 1 and any data in Phone 1.
- Mr_K
- 7 yrs ago
- Get help
- Reported - view

1 11 12 13 14 15 19

Welcome to the Ninox community

Mr. K.

Re: Show Date as Year Only

Re: Use a number in a choice field as a multiplier of a number field?

Re: Use a number in a choice field as a multiplier of a number field?

Use a number in a choice field as a multiplier of a number field?

Re: Show Date as Year Only

Re: Show Date as Year Only

Show Date as Year Only

Re: Find Screen?

Re: Find Screen?

Find Screen?

Re: Formula Help Needed to Hide a Space Field Layout Element.

Re: Formula Help Needed to Hide a Space Field Layout Element.

Re: Formula Help Needed to Hide a Space Field Layout Element.

Re: Formula Help Needed to Hide a Space Field Layout Element.

Formula Help Needed to Hide a Space Field Layout Element.

Re: Search Dashboard Formula Help Please.

Re: Display field only, if: either of two other fields has no data?

Re: Search Dashboard Formula Help Please.

Re: Search Dashboard Formula Help Please.

Re: Display field only, if: either of two other fields has no data?

Search Dashboard Formula Help Please.

Re: Display field only, if: either of two other fields has no data?

Re: Display field only, if: either of two other fields has no data?

Re: Display field only, if: either of two other fields has no data?

Re: Display field only, if: either of two other fields has no data?

Overview