Celin.RUN
Runs a query when a trigger cell range changes.
Example
Create an address book table, named ab
with address book number and name. Select the address number from a cell named Customer
.
/* Address Book Table */
#ab =
/* Table */
f0101
/* Fields (Alias) */
(an8,alph)
/* Where ab number equals cell name Customer */
all(an8=@Customer)
Trigger a re-run of the query whenever the Customer
cell value changes.
=Celin.RUN("ab",Customer)
Display the results with the DATA
function.
=Celin.DATA("ab",-1,-1)