Look Up tables

Peter

Yes you can lookup values dependant on your drop down selection choice - at the moment not sure if you are saying boiler 1 selected may then have one or more SFG20 options to lookup and autofill. ie Ideal Boiler might have an SFG20-1 - SFG20-2 etc.

Loading images has been broken for while and as of yesterday you are able to load them again. Don't worry about image appearing squashed- Once you have loaded and saved - it presents okay.

(Agree what ever changes you make it still is squashed (Ninox still need to fix this!)

Mel

Hi Peter

Looking at this - ther might be a better way

as doing a giant combo drop dowm might have limitations - ie having to add extra names etc. Might be better to have an Inventory table listing both the name an code

and linking that table to your form....

I've done a sample so follow this as a test (igmoring what you have so far - ie do a another new APP for a test

Create new database (eg i've called it plumbing)

create Table 1  - INVENTORY add 2 text fields ItemName and SFGcode

and fill it with your sample data lines (boiler in. itemname and 03-01 in SFGcode.... just do 3 or 4 lines for now

Create Table 2 - SURVEY - at the foot select link to and choose INVENTORY

now add anothet text field called SFGcode

SAVE !!

 

Still in edit mode click to edit the link field . select more and show as and select ItemName

in trigger after update copy this code

let myC1 := Inventory.SFGcode;
SFGcode := myC1

click ok

edit SFGcode field and in in Trigger after update

copy this code

if SFGcode = null then
SFGcode := Inventory.SFGcode
end

click ok

This lets you clear the sfgcode and reload linked data - so if you want you can overtype info and clear and it will redo the lookup

exit app then re go back in and select SURVEY table and clink iside the link box (itemname) this will open up the rlated table - you can pick one/search /add more products etc.

when you have select it it will return and fill in SFGcode for you.

whne you click the box again you will see it linked.

the funny symbol at then of this box is so you can break the link and slect another item

you will see it ---makes sense when you do it

 

Mel

I'll keep my sample for a few days - just in case !!!

Maybe Sean/Steve etc could offer a btter solution directly with the drop dowm combo but I think you ill run into difficuties tryig to populate big lists maintenace wsie and they are not dynamic (well not in Ninox anyway)

It would be great if Ninox allowed you to direcly load a data set into a combo from a table list !!!

Keep holding on for a few weeks, the new version will contain a dropdown list based on a table.

Steven

Have you seen some release notes then?  ... if so where

Hi Peter

 

Hope I have intepreted this correct.. as i was not sure wher you wanted to out the asste DOB field yu mentioned - but you surley have to have t somewher I have popped it into the survey form

add new table (Life) 2 fields Kit (text field) and Lifesan (Number field)

add some dat ie

Commercial boiler and 20

Fan and say 5

Goto and edit Survey Table

select link at foot and choose Life

in trigger after update on this link field copy this code

let myC2 := Life.Lifespan;
Lifespan := myC2.... 

also change show as to Kit

Save(ok) it

Now add another file called lifespan (number field)

in trigger after update copy this code

if Lifespan = null then
Lifespan := Life.Lifespan
end

add a new field AssetBOB (date field)

add a forumla field - i've called it lifeLeft

add this formula to it

Lifespan - (year(today()) - year(AssetDOB))

Save  - exit and go back in...

 

 

So this gives you the survey frotm linked to 2 other subforms !

oops i meant form not frotm!!

Obviously change the file/table names etc to suit yourself..

Like everthing in life - there will be otherways to solve this for you..

Mel

Steven, I second Mel's question 

@Mel & @Sean,

Sylvain Moesching did mention it several times on the facebook page Ninox Community English. This was also presented to all the partners in December.

oh - I'm not on facebook ( i know how sad am I)

Not sad at all. I've never had a Facebook account. Thanks Steven

Steven, follow up question... When you say, "presented to all the partners", was it via video conference?

Peter 

Up to my eyeballs in work at the moment

but the life left is a formula field

 

code is directly in it - like so

@Sean, yes