Skip to main content
Forum
Privacy
Contact
How to enable Javascript
Sign Up
Log in
Welcome to the Ninox community
Search all topics or
ask a question
Learn and share
Get help
Service status
Documentation
Solutions
Setup
Databases
Automation
My account
Administration
Webinars
Overview
Profile
Fred
Fred
San Francisco, USA
Follow
Joined
Thu Feb 06 18:42:57 UTC 2020
3811
posts
606
likes received
5
followers
Badges
Latest Posts
Re: Need to show only the Deliverables that will be issue in the next 7 Days.
@Rafael said: create new table Next7days Where copy your Formula ? and where the select Documentos [newfield = 1] I'lost now, sorry I guess I made too many assumptions.…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Select all choice in a multiple choice (dynamic)
@Web Name said: And then why is it just for the current record? Usually a trigger after update of a field only affects the record you are on. Are you asking to make the trigger affect ALL records in…
Fred
Fred
3 yrs ago
1
Get help
Reported - view
Re: View not showing top line on update
I get the same thing on my iPad with my iCloud DB. I don’t get everywhere, but I do see it at times. I haven’t checked on my MacOS.
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Select all choice in a multiple choice (dynamic)
Sorry, misread your post. Here is what you can put in your trigger after update: let allTable := (select Table1); if YN then dMC := allTable end Change the following references to match your…
Fred
Fred
3 yrs ago
1
Get help
Reported - view
Re: Select all choice in a multiple choice (dynamic)
You can try something like: let selDMC := for loop1 in numbers(dMCfieldname) do record(tablename,loop1) end This will put all selections of a dMC into an array.…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Using tags for searching
@iliper LTD said: the department name is formed from three tags Perfix, number and group. Are each of those in separate fields? If not, can you give an example of the data?
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Button to create empty field
@pirinisz said: but in the original table I want to be able to add a 2nd or 3rd reference to the table "names"!!!! It sounds like you created the reference in the opposite direction.…
Fred
Fred
3 yrs ago
1
Get help
Reported - view
Re: Button to create empty field
I have not seen any function that allows a user to create a field through a button. What you are describing is trying to track multiple instances of similar data to a record.…
Fred
Fred
3 yrs ago
1
Get help
Reported - view
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
Fred
3 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
Fred
3 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
Fred
3 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
Fred
3 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
Fred
3 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
Fred
3 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
Fred
3 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
Fred
3 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
Fred
3 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
Fred
3 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
Fred
3 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
Fred
3 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
Fred
3 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
Fred
3 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
Fred
3 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
Fred
3 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
Fred
3 yrs ago
1
Get help
Reported - view
1
100
101
102
103
104
153
Ninox-Website
Overview
Learn and share
Get help
Service status
Documentation
Solutions
Ninox E-Invoice
Setup
Installed apps
Public Cloud
Private Cloud
On-Premises
Databases
Tables
Table relationships
Fields and elements
Pages
Views
Import and export
Modules
Printing
Templates
Use cases
Automation
Performance
Scripting
Functions
API
My account
Subscriptions
Administration
Manage workspaces
Manage collaborators
Access permissions
Backups and storage
Process monitor
View all topics
