RoSoft_Steven's Profile | Ninox Community

Badges

Latest Posts

Re: Formula doesn't work until I populate each field in the formula at least one time, then works for the one record. Needs to be repeated in each record?
You should use null instead of 0 like if 'Phone 3' != null then Steven
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: Error in a formula ?
'Premier mot' is a formula field, you can't put data in it. Steven
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: Distributing a database
Hi, Michel I believe you are using a browser to go to your database (I use Google chrome to get the best performance) ? On the startup where you see your TEAMS (top tabs),…
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: Issue with a formula
I think it's because that name begins with a space in your text-field. Steven
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: Progressive sum
let d := this;sum((select Months where 'Month n°' <= d.'Month n°').'Budget €') Steven
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: Extract names from compound names
use this formula: substr(Nom, 0, index(Nom, " ")) Steven
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: http() function isn't working
In my experience, when i use 'do as server' in my http request it works. If I don't, it blocks. e.g.: let responce := do as server http("GET","......... end Steven
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: field name with HTML formatting
Maybe this tread is also usefull:…
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: fields printing visible or invisible
If you mean printing a table view, then you can use different table views to filter what you want to print. It's always what's displayed that would be printed.…
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: table view with both combo box (selected options and 'empty or null option) in same view
Does this expression gives the wanted result? if combobox !> 0 then "empty" Steven
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: delete x qty of records
I would try to put the date in a variable : let d := date(22/01/2015); delete (select DEJOBS where text(Jobstatus) = "cancelled" and Orderdate <= d) Steven
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: Representations of the Id
The left column in your screenshot doesn't show the ID number, its the line number (like excell). To show the id you need to click on a columnheader and there chose to show the ID column.…
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: http() function isn't working
The CORS problem was solved by adding 'do as server' in my GET request. @ Sean , FYI The code is in a button. The result I'm getting starts with this : PK mimetypeapplication/vnd.oasis.opendocument.…
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: To delete some raws in one time
Hi,The menu for the row-actions is here: Steven
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: http() function isn't working
To be complete, on my Macbook with the native app, it also won't work.
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: http() function isn't working
Sean, Can't tell as this is a new created API call I try (carbone.io) I've installed a plugin(CORS Everywhere) in Firefox and now I don't have connect errors.…
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: http() function isn't working
@Sean, Have you looked in the console? I also have also blocked requests due to > CORS-header ‘Access-Control-Allow-Origin’ may not be * Any Solution?
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: Button to populate a separate table from another table (and sub table)
Try with change this ?: ....let xSup := Suppliers;.... i.(Seller := xSup);
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Learn and share
- Reported - view
Re: Button to populate a separate table from another table (and sub table)
Try this: let xPODate := 'Purchase Date';let xPONum := 'PO Number';let xPOID := number(this.Id);let me := this;for p in select 'PO Items' where 'Purchase Orders' = me do let xProduct := p.…
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Learn and share
- Reported - view
Re: Displaying the number of documents
cnt(files(this))
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: Help ! I removed a field ! Can I restore it
I think you need to export in csv first and then import them in an earlier backup.
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: Help ! I removed a field ! Can I restore it
Maybe exporting all the data and go back to a restored backup to recover your removed field. And then import the new data you've exported on the last one.
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: Help ! I removed a field ! Can I restore it
If you have a cloud abo, you can restore an automatic backup. If you don't have one, then contact support. I think the field is gone but the data is still in the history file i think.…
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: display numbers in ascending order that are in a text field ?
I think the quotation marks (guillemets) are of the wrong type in the fieldname. Maybe it's better to click on the fieldname like: Steven
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: display numbers in ascending order that are in a text field ?
Here's a video of this: https://www.dropbox.com/s/ldpg0abddjvtjqy/CalcNumber.mp4?dl=0 Steven.
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view

1 33 34 35 36 37 65

Welcome to the Ninox community

RoSoft_Steven

Re: Formula doesn't work until I populate each field in the formula at least one time, then works for the one record. Needs to be repeated in each record?

Re: Error in a formula ?

Re: Distributing a database

Re: Issue with a formula

Re: Progressive sum

Re: Extract names from compound names

Re: http() function isn't working

Re: field name with HTML formatting

Re: fields printing visible or invisible

Re: table view with both combo box (selected options and 'empty or null option) in same view

Re: delete x qty of records

Re: Representations of the Id

Re: http() function isn't working

Re: To delete some raws in one time

Re: http() function isn't working

Re: http() function isn't working

Re: http() function isn't working

Re: Button to populate a separate table from another table (and sub table)

Re: Button to populate a separate table from another table (and sub table)

Re: Displaying the number of documents

Re: Help ! I removed a field ! Can I restore it

Re: Help ! I removed a field ! Can I restore it

Re: Help ! I removed a field ! Can I restore it

Re: display numbers in ascending order that are in a text field ?

Re: display numbers in ascending order that are in a text field ?

Overview