Skip to main content

I'm creating an extension that will create a table and display a response for the user. I want to be able to color some cells depending on the response they get (true/false). Is there a way to do that? Coding? 

@fabianabbc wrote:

I'm creating an extension that will create a table and display a response for the user. I want to be able to color some cells depending on the response they get (true/false). Is there a way to do that? Coding?   MetroSurvey

Hello,

To color code cells based on user responses in a table within your extension, you'll need to use HTML and CSS. Use JavaScript to dynamically modify cell styles. Set a class or inline style with appropriate colors based on the response. 

 

 

 

Hey @fabianabbc, 

I'm not too familiar with your use-case, but here's a script that will do allow you to dynamically set colour codes, assuming the column name is "Response" and the values are "True" or "False":

 

// Get the table

let tableName = "My Table";

let table = base.getTable(tableName);



// Define the "Response" field

let responseField = table.getField("Response");



// Update the options for the "Response" field

await responseField.updateOptionsAsync({

choices: [

...responseField.options.choices.filter((choice) => choice.name !== 'True' && choice.name !== 'False'),

{name: 'True', color: 'green'},

{name: 'False', color: 'red'},

],

});



// Define the records you want to create

let records = [

{ fields: { 'Response': { name: 'True' } } },

{ fields: { 'Response': { name: 'False' } } },

{ fields: { 'Response': { name: 'True' } } },

];



// Create the records in the table

await table.createRecordsAsync(records);



// Display a response to the user

output.text("Records have been created!");

 

 

Hey @fabianabbc, 

I'm not too familiar with your use-case, but here's a script that will do allow you to dynamically set colour codes, assuming the column name is "Response" and the values are "True" or "False":

 

// Get the table

let tableName = "My Table";

let table = base.getTable(tableName);



// Define the "Response" field

let responseField = table.getField("Response");



// Update the options for the "Response" field

await responseField.updateOptionsAsync({

choices: [

...responseField.options.choices.filter((choice) => choice.name !== 'True' && choice.name !== 'False'),

{name: 'True', color: 'green'},

{name: 'False', color: 'red'},

],

});



// Define the records you want to create

let records = [

{ fields: { 'Response': { name: 'True' } } },

{ fields: { 'Response': { name: 'False' } } },

{ fields: { 'Response': { name: 'True' } } },

];



// Create the records in the table

await table.createRecordsAsync(records);



// Display a response to the user

output.text("Records have been created!");

 

 


Hey! So I tried this code but it seems it's for script. Is that different from an extension code? cuz it's not working for me 😕😕 and I can't use output in an extension code.

Reply


Terms & Conditions