Can I refer to the selector record in a formula?

Ask for Help
1

Hi!

I have a summary table (A) that I use as a selector for a table widget (B). I’d like to write a formula in the table widget (B) that uses a value of the record that is selected in the summary table (A). Is this possible?

I’m looking for something like this: tableC.lookupRecords(field=SELECTED_RECORD.field)

2

Hi there!

Would you be able to share your document with support@getgrist.com so I could take a closer look at your setup? Once you’ve added the support email to the document, let me know which tables to look at and what data you want returned in the formula. It may be possible to do but is dependent on how data is linked.

Thanks,
Natalie

3

Is there a way to achieve this? a reference to the cursor record (something similar to $group but only the selected row)