Fred's Profile | Ninox Community

Badges

Latest Posts

Re: Need Help with view table.
Since you are looking for people's name you need to use the field that stores the people's name. I'm guessing HORAS does not store people's name. Looking at your structure you need to use the…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How to create records automatically
You can try this in button in the Customer table: let t := this; let selExpiry := (select Expiry); let st := 'Society Tipology'; let neededExpiry := selExpiry['Which company?' = 1 or (var EfS :…
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Date language
Ninox uses the date format of your computer settings. I haven’t played around with changing it to see how Ninox reacts, but you can try that. Or you can use the format command.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Need Help with view table.
@Rafael said: I need to know the hours spend on Data table for name place on the Search field. What is the name of the field that holds the name place? Use that.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Need Help with view table.
I try with this Formula sum the hours in Data Table for the people, I place in the Search field. But don't work any idea.? let search := lower(Search);…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Private Server
Ninox does have a private cloud option which is what the Connect to server... is for. This is where a company installs a multi user version of Ninox on their own hardware or Ninox hosts it for them.…
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Unique Value Formula
@RoSoft_Steven Thanks for lumping me in with @Jacques . Most of the time I’m just drafting in his wake. @Mel Charles , this site is good to test your RegX code. I haven’t found a good RegX tutorial.…
- Fred
- 3 yrs ago
- Learn and share
- Reported - view
Re: Need Help with view table.
One way is to hide the view until there is something in the search fields. Another way is in the switch command there is a “default” case, so you can try putting null in there.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How to create records automatically
in the example you give, is there 15 records in the expiry table for customer AZName Ltd? So there is a N:1 relationship between Expiry (many) and customer (one) and a N:…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How to create records automatically
@webmaster.antonioferriero said: Can you create such a button? With which code? You can do most things in Ninox. My little brain is having a hard time generalizing your workflow.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How to create a unique list of records
Well @Jacques, your code makes a lot of sense and is much easier to use.
- Fred
- 3 yrs ago
- Learn and share
- Reported - view
Re: How to create a unique list of records
I’ve wanted to do something like this for about a year now.
- Fred
- 3 yrs ago
- Learn and share
- Reported - view
Re: How to create records automatically
@webmaster.antonioferriero said: Question. How to associate Fulfillment to each Customer? In other words, how to fill the Fulfillment table? Are you starting in the Fulfillment table,…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Dynamic Choice Field Assistance
Glad to hear it works for you. Please remember to mark this post answered.
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Dynamic Choice Field Assistance
Once you start working with multiple choice fields (regular or dynamic) then you can't use the equal sign so easily. Once a record in WFM Permissions has more than one option selected in the multi…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Send email and include only fields with value
@Bernd Krell said: With 2 or 3 empty lines between, it looks odd. Any way to prevent this? I would say to play around with putting the carriage returns in the check formulas,…
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Dynamic Choice Field Assistance
Are Eligible Departments and Eligible Titles multi choice fields (thus the use of numbers)? Can thisuserdepartment and thisusertitle have more than 1 record?
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Tables sync
great to hear. You are on your way to master Ninox! Just remember to mark the post "answered".
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Tables sync
@pirinisz said: Yes but in a formula there is no grading by date I have no idea what "no grading" by date means? Since the date field in Table A is a date field.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Tables sync
@pirinisz said: Sorry man, the date field is actually a simple date field, not a reference. Refer back to my original reply about creating a formula field as your Date field for Table B.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Tables sync
@pirinisz said: On Table B I have 2 references (one for name and one for date) Are your two reference fields pointing to Table A?
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Tables sync
@pirinisz said: OK but I don't get to see the date field this way.... I thought you were going to use a formula field? Another way is, you can add the date to the Show data as formula:…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Tables sync
@pirinisz said: I added in the "trigger after update" the following code: if today() > 'date' then 'date' := date(year(today()) + 1, month('date'), day('date')) end Ninox has pretty nice date data…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Tables sync
@pirinisz said: Could you please explain to me with more details the following, according to the values I gave you? In Table B, open Edit Fields. On the right side of the window is a section called…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Tables sync
@pirinisz said: But I noticed that I have to close and reopen NINOX in order to synchronise, right? Which version are you using, cloud or MacOS app?
- Fred
- 3 yrs ago
- Get help
- Reported - view

1 101 102 103 104 105 153

Welcome to the Ninox community

Fred

Re: Need Help with view table.

Re: How to create records automatically

Re: Date language

Re: Need Help with view table.

Re: Need Help with view table.

Re: Private Server

Re: Unique Value Formula

Re: Need Help with view table.

Re: How to create records automatically

Re: How to create records automatically

Re: How to create a unique list of records

Re: How to create a unique list of records

Re: How to create records automatically

Re: Dynamic Choice Field Assistance

Re: Dynamic Choice Field Assistance

Re: Send email and include only fields with value

Re: Dynamic Choice Field Assistance

Re: Tables sync

Re: Tables sync

Re: Tables sync

Re: Tables sync

Re: Tables sync

Re: Tables sync

Re: Tables sync

Re: Tables sync

Overview