Create a script that combines 2 records and that automatically fill a field

Wow !

Well, first of all, thank you so so so much for your answers guys ! I appreciate so much and it helps me to improve myself as much as I can but it’s not that easy when you’re a beginner all alone

In fact, I want to do this kind of things with many fields such as links for Whatsapp, Telegram, Instagram and so on in order to create a big adress book of my contacts.

The script you created seemed to contain an error (or I don’t know but I had an error message) that I could solve thanks to chatGPT (I wasn’t able to do it alone) :

The issue is in the following line:

javascript
const phone_number = var phone_number_id = ‘fld-XXX’;
In this line, you declare a constant (const phone_number) and try to initialize it with another declaration (var phone_number_id). This is not valid in JavaScript because a declaration cannot be used as an initialization value.

Fix
You need to separate the declarations and initializations properly. Here’s a corrected version of the script:

Changes Made
Separated Declarations:

Removed const phone_number = var phone_number_id = … and declared phone_number_id and whatsapp_id_id separately.
Correct Identifier Usage:

Used phone_number_id and whatsapp_id_id in the appropriate places.

I tried another one by myself, can you tell me what you think (take a look at the type of the field because it’s not a number phone here) ? It seems to work perfectly :

function Nouveau_Script() {
    // Replace with your own code
    var hello_world = "Bonjour tout le monde !"; 
    return hello_world;
}

Nouveau_Script();

function Script() {
    // Define used fields
    const id_id = 'fld-XXX';
    const lien_id_id = 'fld-XXX';

    // Define Twitter API
    const lien = "https://twitter.com/i/user/";

    // Get the ID from the record (assuming this method exists)
    let id = record.getFieldValue(id_id);

    // Define call URL
    let url = lien + id;

    // Set URL
    record.setFieldValue(lien_id_id, url);

    // Save changes
    document.saveAllChanges();

    // Output result to console
    console.log(url);
}

Script();

– Is there a way to add the ID directly to the link or have I to create a 3rd field in which there will be [Link] + [ID] ? Or at least I’ll hide the useless field with the default value.
– If I use the method of Brendan : will it create a complete link in the tapforms app (I mean will it combine the two fields in the link field and show the complete link or will it combine only if I click on the globe button in order to access to the website) ?

Sorry in advance for my English mistakes.

Best regards,
Jo M

(sorry for the duplication but I edited my message and it doesn’t appear so I post it again)