Skip to main content
Solved

Get User ID from field - Block

  • June 7, 2020
  • 2 replies
  • 109 views
V

Hello,

I have a field where I have a list of collaborator. I’m developping a block and I would like to get all the users ID from my field of my table.

Currently I can get the name of the collaborator with :

const base = useBase();
cont table = base.getTableByNameIfExists(“name_of_the_table”);
const value_user = my_record[0].getCellValueAsString(“Name_of_collaborator_field”);

I got the name of all my users in the value_user
But now, I would like to get the list of user ID. How can I got it ? Thank you :winking_face: .

Viken

Best answer by JonathanBowen

Hi @Viken_Toramanian - you can just use my_record[0].id to use the unique user id within Airtable. Here’s my script to log them all out (for all records):

let table = base.getTable('Table');
let query = await table.selectRecordsAsync();

for (let record of query.records){
    let collaborators = record.getCellValue('Collaborators');
    if (collaborators) {
        for (let collaborator of collaborators) {
            console.log(collaborator.id)
        }        
    }
    
}
If this answers your question please consider marking this as the "solution". If not, please post again for more help. Thanks!

2 replies

JonathanBowen
Forum|alt.badge.img+18
  • JonathanBowen
  • Inspiring
  • 1110 replies
  • Answer
  • June 7, 2020

Hi @Viken_Toramanian - you can just use my_record[0].id to use the unique user id within Airtable. Here’s my script to log them all out (for all records):

let table = base.getTable('Table');
let query = await table.selectRecordsAsync();

for (let record of query.records){
    let collaborators = record.getCellValue('Collaborators');
    if (collaborators) {
        for (let collaborator of collaborators) {
            console.log(collaborator.id)
        }        
    }
    
}
If this answers your question please consider marking this as the "solution". If not, please post again for more help. Thanks!
V
  • Viken_Toramania
  • Author
  • New Participant
  • 2 replies
  • June 8, 2020

Hi @Viken_Toramanian - you can just use my_record[0].id to use the unique user id within Airtable. Here’s my script to log them all out (for all records):

let table = base.getTable('Table');
let query = await table.selectRecordsAsync();

for (let record of query.records){
    let collaborators = record.getCellValue('Collaborators');
    if (collaborators) {
        for (let collaborator of collaborators) {
            console.log(collaborator.id)
        }        
    }
    
}
If this answers your question please consider marking this as the "solution". If not, please post again for more help. Thanks!

Hi @JonathanBowen,

It works perfectly ! Thank you :thumbs_up:

I just adapt it and use selectRecords() instead of selectRecordsAsync(), because I have a function which is checking if my user is part of field “collaborator”. If I use selectRecordsAsync() the function will not check on time the condition and it will not considere if the user is part or not part of the field “collaborator”.

Thank you again for your help.


Terms & ConditionsAccessibility statement