Help

Can a button know in what row he is?

Topic Labels: Scripting extentions
Solved
Jump to Solution
2620 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Omer_Rugi_Hay
4 - Data Explorer
4 - Data Explorer

Let’s say I have a table with few rows - each one has a uniq ID
Can a button cell have a script that will identify the ID in which he was called?
for example - this is my table:
id. Button
1 Click
2 Click
when I click on the button on the first row - I can see what is also the id of this row.

1 Solution

Accepted Solutions
Jonathan_Lutz
6 - Interface Innovator
6 - Interface Innovator

Yes, you can do that with scripting. The sample script called “Record picker” (accessible when you create a new Scripting app) does mostly what you’re requesting. It’s just a matter of changing the field that you want to display once the record is selected. See below:

// Change this name to use a different table
let table = base.getTable("Button Test");

// Prompt the user to pick a record 
// If this script is run from a button field, this will use the button's record instead.
let record = await input.recordAsync('Select a record to use', table);

if (record) {
    // Customize this section to handle the selected record
    // You can use record.getCellValue("Field name") to access
    // cell values from the record
    output.text(`You selected this record: ${record.name} (${record.getCellValue('Record ID')})`);
} else {
    output.text('No record was selected');
}

How to capture record ID with button

See Solution in Thread

2 Replies 2
Jonathan_Lutz
6 - Interface Innovator
6 - Interface Innovator

Yes, you can do that with scripting. The sample script called “Record picker” (accessible when you create a new Scripting app) does mostly what you’re requesting. It’s just a matter of changing the field that you want to display once the record is selected. See below:

// Change this name to use a different table
let table = base.getTable("Button Test");

// Prompt the user to pick a record 
// If this script is run from a button field, this will use the button's record instead.
let record = await input.recordAsync('Select a record to use', table);

if (record) {
    // Customize this section to handle the selected record
    // You can use record.getCellValue("Field name") to access
    // cell values from the record
    output.text(`You selected this record: ${record.name} (${record.getCellValue('Record ID')})`);
} else {
    output.text('No record was selected');
}

How to capture record ID with button

Omer_Rugi_Hay
4 - Data Explorer
4 - Data Explorer

Thank you so much!
I’m trying to build a like mechanism in the table hope it will work