Fred

San Francisco, USA

3528
551
4

Joined: Thu Feb 06 18:42:57 UTC 2020

My Posts

Latest Posts

Re: Need to show only the Deliverables that will be issue in the next 7 Days.
So it looks like you are trying to use a view element in another table. If you create the formula field and put my code, then you can just search on my field for the view formula:…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: NB - Account issues - renewal
Sorry to hear that Ninox has made it difficult for you to upgrade. You should contact Ninox directly for help with subscriptions.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Need to show only the Deliverables that will be issue in the next 7 Days.
Here is something quick off the top of my head: let dcheck1 := workdays(Date1, DataDate); let dcheck2 := workdays(Date2, DataDate); let dcheck3 := workdays(Date3, DataDate); let dcheck4 :…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Need to show only the Deliverables that will be issue in the next 7 Days.
Try creating five new formula fields (one for each Fecha) and put this in the formula: days(FechaPx,DataDate) You will see numbers from positive (days before the DataDate) to negative (days after the…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Need to show only the Deliverables that will be issue in the next 7 Days.
@Rafael said: Need to show only the Deliverables that will be issue in the next 7 Days, from the DataDate. Help me understand what you want a bit better.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Button that fills a table
I have no idea how to create a random text generator. Maybe someone way smarter than me can figure it out. But for the record creation you try something like: let selAll := (select tableName);…
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Filter "OR"
In the filter you can put something like this, assuming it is a text field. ="supplier" or ="partner"
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Using tags for searching
@iliper LTD said: I want to create a table and separate fields for tags, and specifying the name of the tag, the table should display all the data of the department that correspond to the tags.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Copy and open new record
You don't need to close the current record. Just put the openRecord command inside the if statement: let x := dialog("NEW DAY TEMPLATE", "Do you want create template for a next day?", ["No", "Yes"]);…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: How to create records automatically
@Web Name Good to hear. please mark the post answered if you are happy with the solution.
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Ancorare alcune colonne come su excel
what do you mean by anchor columns? Google Translate: cosa intendi per colonne ancorate?
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Show "1" instead UNDEFINED
Yes, I always forget debugValueInfo. One day it will stick in my head.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Record create date function
I'm guessing you are using the cloud version since you mention users. You can use the Created On and Modified On function. See this Nioxus post for more info.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Show "1" instead UNDEFINED
@thomas said: Thank! I've tried this too but I have as result "0" and not "1. Also if there is s value for $5 Can you check the code again? I looked at my example and typed the wrong code.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Show "1" instead UNDEFINED
Please make the following change: if x = "undefined" then "1" else x end I forgot that extractx results is a string so you have to put " " around 1 so the result is also a string.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Show "1" instead UNDEFINED
You can try something like: let x := extractx....; if x = "undefined" then 1 else x end I’m not sure “undefined” is what Ninox sees or just what Ninox shows. You can try null as well.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Button for duplicate last records
You can try something like: let lastRec := last('Hourly Estimation'); let dupRec := duplicate(lastRec); dupRec.('Date+Time' := now()) This assumes that the record with the highest record Id in the…
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 yrs ago
- Get help
- Reported - view

1 89 90 91 92 93 142

Welcome to the Ninox community

Fred

My Posts

Re: Need to show only the Deliverables that will be issue in the next 7 Days.

Re: NB - Account issues - renewal

Re: Need to show only the Deliverables that will be issue in the next 7 Days.

Re: Need to show only the Deliverables that will be issue in the next 7 Days.

Re: Need to show only the Deliverables that will be issue in the next 7 Days.

Re: Button that fills a table

Re: Filter "OR"

Re: Using tags for searching

Re: Copy and open new record

Re: How to create records automatically

Re: Ancorare alcune colonne come su excel

Re: Show "1" instead UNDEFINED

Re: Record create date function

Re: Show "1" instead UNDEFINED

Re: Show "1" instead UNDEFINED

Re: Show "1" instead UNDEFINED

Re: Button for duplicate last records

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.

Overview