Marge two tables' date fields and use it in a Value Lists entry, Dynamically?
Or How to convert list function's result to Value Lists?
Hello and thanks everyone sharing great ideas and solutions.
I am trying, without success, to use list function’s results into Value Lists. I am appreciated if you share some knowledge or guide where I should do.
Here is what I am doing;
1) I have two individual tables, each of which contains unique date (in a date filed), sampling numbers and contained date are irreverent on each table.
2) What I want to do is to marge two tables' date fields and use it in a Value Lists entry.
I want it to be updated dynamic, such as when new date entry is made, the Value Lists be updated accordingly, not every-time importing another table's field or performing scripts...
3)What I came up with is to make use of List() function to get each field's contents as text, then to concatenate each, thus producing what I am intending.
This far I have come and stuck and need your guidance...
what I want to do next are;
4) How to convert this result (return delimited text) in to Value Lists.
5) Additionally, it is quite helpful, if I can sort date.
my working environments: MacOSX 10.93, filemaker pro 13 advanced
Thank you for your attention.
Yoshio, Kyoto Japan