Can we link a field to a table view?

I am a little confused by ... "each phone number will be assigned only once"...  Are you saying that John's number cannot match Mary's phone number?   Or are you saying that John cannot re-use a prior phone number?  What if both John and Mary are clients.. and they are married / cohabitate ? 

You are 90% there with the out of the box "Contacts" template database.  You can add logic in the phone numbers trigger after update to determine if the number is a duplicate.. and if so.. set it back to the prior number and pop up an alert.   If the new number is NOT a duplicate, copy that number to a hidden / history table that is also linked to the contact by creating a new history.. assigning it the phone number value.. and setting it's Client to this (the current client row).. 

Hope that helps.. 

@plafontaine.. I defer to Ninox Support on that one..  I do recall some threads discussing where Ninox stores the database locally.. I do not have this use case.. so never really worried about it.   Good luck tho! ;) 

You can manually export to any place. And you can import the Ninox database from any place. Please note that there will be no synchronisation this way.

Birger

@plafontaine... You should start another thread / question as opposed to adding a different topic to this one.. At least my two cents.. :)   That said..  here is an example of a dashboard.. aka "real time stats" . 

I have a different application that tracks about 37 different KPIs.. So.. I built a KPI Template table (has all 37 KPI descriptions).. then I built a Dashboard table.. and put logic behind the "Populate KPI" button that builds the main KPI table.   You could do something similar. 

Did you start with the Contact template? 

The tricky part will be how you want the new contact add to work..

Rather than simply "linking" to the contact phone composite table, create a view and show the row where EffectiveDate = max(EffectiveDate).   

i was not aware that we could make a view within composite table... can you gives me more detail on how to do it please?

Thanks again!

OK.. Using the Contact database template... and let us assume that the most current 'Contact Phone'.'Modified on' date represents the "current number" for that label ... (you can use your own effective date if you wish)... 

I added a column to the 'Contact Phone' called 'Current Number' as follows.. 

On the Contact form.. I added a View element as follows:

which yields..   The following... NOTE.. because the above uses t.Phone .. meaning this.Phone on the contact.. Ninox has already filtered the 'Contact Phone' list to 'Contact Phone'[number(Contact.id) = number(t.id)]  for me.. so that is not required.. 

thank you! Seem to work...but I have a little problem! I dont know why but I change the label name and also updated my formula with the right names... then I addes a field in the contact table with this formula:

if (concat(Phone.Label) = "Maison" and concat(Phone.ACTUEL)) = true then
concat(Phone.Number)
end

so I hope to show a phone number if it s actual and the label is ''Maison''. But the number already in the phone table stay ''no'' in actual field even if I added a date for last changes (I have change your formula to take that field) and when I add some number to get an actual number, the number disapear from the contact table! Seem to do the opposite that I want... 

Do you have any solution for this? 

it s not making the difference between label too. It takes the first actual number. Is there a way to have each label actual number? And like I said in previous post it still dont like single phone number entry (stay not actual).

another things, if i edit the date and make it ''now'' for a number, the table will make it actual but keep last actual to true. It seems to not recalculate on changes...

If you create a formula with the function 

–––
now()
–––

it will constantly update. If you fill a regular field it will not.

Birger

how should i do that? I already have a formula in my field. And how to modify my formula to have the max date for every different label? 

here my formula:

let t := this;
t.DERNIER_CHANGEMENT = max((select 'Contact Phone')[number(Contact.ID) = number(Contact.ID) and text(Label) = text(t.Label)].DERNIER_CHANGEMENT)

dernier_changement = date of changes

other fields are from contact templates

thanks!

IS there a way to take time in consideration when using max(date) ?

for my last question, I tryed this:

let t := this;
t.DERNIER_CHANGEMENT = max((select 'Contact Phone')[number(Contact.ID) = number(Contact.ID) and text(Label) = "Maison"].DERNIER_CHANGEMENT)

But it return yes only if it s "Maison" and the max date of all label, not just "Maison".

I keep searching... if you can help me on that one! Wish to get max date for each label (if maxdate among all "MAison" label then ruturn yes and if maxdate among all "cell" label then return yes...etc) a kind of array because I wont enter all label value manually!

Thanks!

My previous example (see page 2) ... provided max date for each label. 

Hi,

       Sorry but I just do like you said, I just changed the 'modified on' by ma field name for the date and it give me only the maxdate for the entire label list...I dont know why...it s the same thing as you...

I ll try to start another db with contact template and redo all that to see!

In your above syntax of. 

t.DERNIER_CHANGEMENT = max((select 'Contact Phone')[number(Contact.ID) = number(Contact.ID) and text(Label) = "Maison"].DERNIER_CHANGEMENT)

Because you have 

and text(Label) = "Maison"]

it will only return the max of Maison...

yes that was a test...but i must have done something wrong because I restart it from scratch and it seem to works now! 

I m trying to display each label number in the contact table.

thank you!