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 achieve but I can't seem to make it work my aim is to have a master table and 2 child tables (soon to add a third) and for the master to pull the data from the child tables. What I have ended up with is 3 functions which I would ideally like as a single function and the key is to pass the table name & required fields into the select statement.
So what I have is this
Formula P1
let t := this;
let SELFIL := (select table2 where 'orderid' = t.'Channel reference');
SELFIL;
SELFIL.'productname'
Formula P2
let t := this;
let SELFIL := (select table3 where 'Order Number' = t.'Channel reference');
SELFIL;
SELFIL.'Product Name'
Formula Product Name
if P1 = "" then P2 else P1 end
Sorry if this is basic but I am not a coder
Thanks in advance
8 replies

You cannot pass the table name to the select statement because the Ninox language is precompiled and does not support dynamic types like JavaScript.
But you can pass your current record (this) to a function that calculates which subtable is available and retrieves a good product name.
function getProductName( currentRecord : mainTable ) do var subRec1 := first(select table1 where 'Order Number' = currentRecord.'Channel refrence'); if subRec1 then subRec1.'Produc Name'; else var subRec2 := first(select table2 where 'Order Number' = currentRecord.'Channel refrence'); if subRec2 then subRec2.'Produc Name'; else void; end; end; end;
The function is put in the global functions and you can use it anywhere in your database.
On your mainTable, you can put this code in a formula.
getProductName( this );

Why create two tables with the same structure and different data? Perhaps the best solution is to merge the two tables and differentiate them by a field named 'data type'.
This would simplify your work. 
What about using the eval() function like:
let myTable := "Table1";
eval("(select " + myTable + ")", this)
EDIT: This only works on Ninox cloud

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

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 the below utilising a common field from the parent table
let t := this;
if Channel like "abc" then
let SELFIL := (select table1 where 'orderid' = t.'Channel reference');
SELFIL;
SELFIL.'productname'
else
if Channel like "xyz" then
let SELFIL := (select table2 where 'Order Number' = t.'Channel reference');
SELFIL;
SELFIL.'Product Name'
end
end
Content aside
 Status Answered
 1 yr agoLast active
 8Replies
 168Views

3
Following