An example with a nested temporary table
This is a cool task that can be solved using the hide: true parameter of the linkToDataTable function. If this parameter is not present, linkToDataTable opens a window, but if hide: true is present, the window does not open, and the function returns the hash of the created temporary table.
So it works like this:
A temporary table is called, which should be filled via insert — more about auto-filling.
h_insert calls another temporary table with the hide: true parameter.
Even though linkToDataTable is an action function, it can be executed from code.
The nested temporary table performs the necessary calculation.
h_insert, having received the hash of the nested temporary table, retrieves data from it.
All this is packed into the h_insert code approximately like this:
=: selectList(table: 'tmp_table_2'; hash: $linkto; field: 'id')
linkto: linkToDataTable(table: 'tmp_table_2'; params: $row; hide: true)
row: rowCreate()
An example of how to open a nested temporary by a button and return the data to the first one by an action
You can call a temporary table and pass the hash of the temporary table, which is obtained through the variable $#nth that is executed only in the temporary table.
By using this variable in functions like set in the hash parameter, you can pass the value specifically to the version of the temporary table from which the second one was opened.
The implementation order is as follows:
Use a button in the first temporary table to open the second temporary table.
=: linkToDataTable(table: 'tmp_table_2'; title: "Complex data"; params: $row; refresh: true)
row: rowCreate(field: "hash" = $#nth)
Enter data into it.
Use a button to configure the return of data from the second temporary table to the first.
=: set(table: 'tmp_table_1'; hash: #hash; field: 'data' = #data)
An example for an adding row
In the addition row, there are no triggers, so the action code can only be executed from the Button.
By default, the buttons in the addition row are locked, but they can be unlocked with the parameter Enable button in addition row.
You can call a temporary table and pass the addition row hash to it, which is obtained through a variable $#ih that is executed only in the code.
Using this variable in functions like set in the hash parameter allows you to pass the value specifically to the addition row opened by the user.
The implementation order is as follows:
Use the button in the addition row to open the temporary table.
=: linkToDataTable(table: 'tmp_table'; title: "Complex data"; params: $row; refresh: true)
row: rowCreate(field: "insert_hash" = $#ih)
Enter complex data into it.
Use the button to configure the return of data from the temporary table to the addition row.
=: set(table: 'table'; hash: #insert_hash; field: 'data' = #data)