Select field preloads description field with Template?

[Valdemar_T]

Hi,

What I want to achieve is this:

In Select field I select one of the available values - e.g. (Tom, Ben, John)

Based on what I selected, it preloads a text template to another field (Description)

E.g. I selected Tom, so it preloads premade text about tom in the description field.

Also I want this field to be editable further if I wish to.

How to do that? Thank you for your help!

[JonathanBowen]

Hi @Valdemar_T - you can do this with a formula (but you won’t be able to edit it later) - pseudo-code:

IF({SINGLE SELECT} = 'Tom', 'Description for Tom........', IF(.....))

As an alternative you should be able to build this into an automation with a script which populates a text field when the single select is chosen. This method would allow you to edit the description later.

[Valdemar_T]

Yes, but I noticed that this automation could theoretically change already existing values e.g. I have a table that already has some instances created, so those would be overwritten if the condition matches?

Also, can I preload those templates from another table, or it must be exactly in the same table?

[Valdemar_T]

Could you possible help with a script, how could it look like?

It is under one base.

Table 1 - Single Select Field “Fruit” (Few values e.g. apples, oranges) which triggers action

Table 2 - contains text templates of apples, and oranges

Once, Fuit is selected, Table 1 - Descritpion Field is populated with a value in our case template from Table 2.

Would be highly appreciated!

[Valdemar_T]

It seems I have managed to find a solution, so sharing it with others. Though I am using not a dynamic records as so, but simply manually added Record ID of the template I want to trigger.

//Preaload values from a Table with templates
let table1= base.getTable('Table with templates name');
let query = await table_sablonai.selectRecordsAsync();
let record = query.getRecord('recorID'); //Here is a record ID of a template

//These are the values I copy from templates fields
let value1= record.getCellValue('value1');
let value2= record.getCellValue('value2');
let value3= record.getCellValue('value3');


//Table in which templates will appear based on trigger
let table = base.getTable("Table name");

//Gets the triggered value on which it will apply changes
let inputConfig = input.config(); 

//Updates the record
table.updateRecordAsync(`${inputConfig.record_id}`, { field_1: value1})
table.updateRecordAsync(`${inputConfig.record_id}`, { field_2: value2})
table.updateRecordAsync(`${inputConfig.record_id}`, { field_3: value3})

Hope this helps others, if you have tips to how improve the code, let me now

[Valdemar_T]

Quicker query to update values.

//Updates the record
table.updateRecordAsync(`${inputConfig.record_id}`, { 
field_1: value1,
field_2: value2,
field_3: value3})