How to enable Javascript

Latest Posts

Re: Parameters it is possible to pass to a function After a bit of testing, I decided to go back to basics and something I tried before without success as I only used SELFIL at the end rather than as each part of the IF statement so have settled on…
- support
- support.1
- 2 mths ago
- Get help
- Reported - view
Re: Parameters it is possible to pass to a function Thanks I did try something similar to this but not using EVAL, which only returned data from 1 of the tables, I am using the MAC app and will also try using EVAL
- support
- support.1
- 2 mths ago
- Get help
- Reported - view
Re: Parameters it is possible to pass to a function @Jacques TUR the data sources have different data there are only a couple of common fields, merging them is what I originally did and as I progress with Ninox realise it is not that straight forward,…
- support
- support.1
- 2 mths ago
- Get help
- Reported - view
Re: Parameters it is possible to pass to a function @Jacques TUR Thanks for the suggestion I'll certainly give that a go
- support
- support.1
- 2 mths ago
- Get help
- Reported - view
Parameters it is possible to pass to a function
Hi, fairly new to Ninox and now in the process of "tidying" up a database which has become a bit untidy in terms of number of fields and duplication, this thread sort of fits with what I am trying to…
- support
- support.1
- 2 mths ago
- 8replies
- 68
- Get help
- Answered
- Answered
Re: Function parameters - which types are possible Hi, fairly new to Ninox and now in the process of "tidying" up a database which has become a bit untidy in terms of number of fields and duplication, this thread sort of fits with what I am trying to…
- support
- support.1
- 2 mths ago
- Get help
- Reported - view
Re: does Ninox have a tool to search for duplicates ? and… approximative duplicates ??? I only have around 11000 records with around 35 fields and yes it does take a little time on the copied view, but as this should only really be an adhoc task after a dodgy import or some bad input,…
- support
- support.1
- 2 yrs ago
- Get help
- Reported - view
Re: does Ninox have a tool to search for duplicates ? and… approximative duplicates ??? No easy answer my workaround is to create a formula in the table you want to search which looks like this let ORDERCHK := 'Field name You want to Check';let ORDERCHK :…
- support
- support.1
- 2 yrs ago
- Get help
- Reported - view
Re: Text / Date calculations I will, that patricular field is always padded out and never has any spaces, however I have other projects where it will come in useful as they are padded with spaces,…
- support
- support.1
- 2 yrs ago
- Get help
- Reported - view
Re: Text / Date calculations Many thanks let dateArr := split(substr(esd, 0, 10), "-");date(number(item(dateArr, 0)), number(item(dateArr, 1)), number(item(dateArr, 2))) Worked perfectly
- support
- support.1
- 2 yrs ago
- Get help
- Reported - view
Re: Text / Date calculations Thanks getting closer when I try let DD := split('esd', "-");let DD2 := date(number(item(DD, 0)), number(item(DD, 1)), number(item(DD, 2)));DD2 the value in ESD is 2020-09-24T23:00:00+00:…
- support
- support.1
- 2 yrs ago
- Get help
- Reported - view
Text / Date calculations
Hi, I seem to be going round in circles and losing the plot for something which should be really simple. I import a file which has a text field which is a time stamp in the format yyyy/mm/dd hh:mm:…
- support
- support.1
- 2 yrs ago
- 7replies
- 816
- Get help
Re: Read Data from Tables without creating manual Links Thanks for the help so far, So to work this out I created a new database with 3 tables with very little data to simplyfy the whole thing as it was running forever (Between the tables around 150k…
- support
- support.1
- 2 yrs ago
- Get help
- Reported - view
Re: Read Data from Tables without creating manual Links Tried the button text again but get stuck on line 3 Button Code for oneRec in select Table1 dofor manyRec in select Table2 where Field1 = Table1.'Field 1' domanyRec.…
- support
- support.1
- 2 yrs ago
- Get help
- Reported - view
Re: Read Data from Tables without creating manual Links Thanks for the swift replies, I'll certainly take look at Webinar EN 2020, I couldn't get that button code to work, I will take another look once I am properly awake,…
- support
- support.1
- 2 yrs ago
- Get help
- Reported - view
Read Data from Tables without creating manual Links
Despite extensive searches and experimantation I now concede I am stuck I have 4 tables of data which one way or another are connected, all data comes from separate sources but are linked Tables 1…
- support
- support.1
- 2 yrs ago
- 12replies
- 1,706
- Get help

support

support.1

16
0
0

Joined: 13 Jan 2020

Follow