+3Hello ,
I am trying to link a row to another row via an automation script , how can I get the url link to a cell because when I do a for(let record of tableQuery.records) i can only get the record.id or record.name isn't their a way to get the record.urlLink ?
Thanks for the help
Best answer by zazadi
Like @TheTimeSavingCo already wrote you can gues the url by your self. Just open manualy a record in your base and than copy the url from your browser. This url contains the id of your base, table, view and the record. The id of the record is at the end of the url. In your script, you can use the url which you copied but you have to replace the record_id part.
For example if this is the URL you copied: https://airtable.com/appID/tableID/viewId/recYqE6YKYkF3cUcL
The bold marked text is the record_ID which you have to replace in your script.
In your script you can build the url like this: "https://airtable.com/appID/tableID/viewId/" + record.id;
+31I don't think that's possible I'm afraid. You could try constructing it yourself with the app ID, table ID and record ID?
How would the record's url link help you with linking records to each other though?
And here's the documentation for the linked record field if that's helpful: https://airtable.com/developers/scripting/api/cell_values#multiple-record-links
+4Like @TheTimeSavingCo already wrote you can gues the url by your self. Just open manualy a record in your base and than copy the url from your browser. This url contains the id of your base, table, view and the record. The id of the record is at the end of the url. In your script, you can use the url which you copied but you have to replace the record_id part.
For example if this is the URL you copied: https://airtable.com/appID/tableID/viewId/recYqE6YKYkF3cUcL
The bold marked text is the record_ID which you have to replace in your script.
In your script you can build the url like this: "https://airtable.com/appID/tableID/viewId/" + record.id;
+3Like @TheTimeSavingCo already wrote you can gues the url by your self. Just open manualy a record in your base and than copy the url from your browser. This url contains the id of your base, table, view and the record. The id of the record is at the end of the url. In your script, you can use the url which you copied but you have to replace the record_id part.
For example if this is the URL you copied: https://airtable.com/appID/tableID/viewId/recYqE6YKYkF3cUcL
The bold marked text is the record_ID which you have to replace in your script.
In your script you can build the url like this: "https://airtable.com/appID/tableID/viewId/" + record.id;
Thank you , I proceeded eventually with this method also .
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.