
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
āMar 10, 2020 11:36 AM
Is it possible to convert integer values into ASCII characters in Formula columns? Pseudo code example: convertToChar(71) returns the char āGā.
Solved! Go to Solution.
1 Solution
Accepted Solutions
Solved
See Solution in Thread
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
āMar 10, 2020 01:11 PM
Hi @Josh_Jennings - donāt think you can do this with a formula, but you can achieve it with a script block:
// @ts-nocheck
let table = base.getTable("Table");
let tableQuery = await table.selectRecordsAsync();
for (let record of tableQuery.records) {
let result = record.getCellValueAsString("Name");
let updateValue = String.fromCharCode(result);
await table.updateRecordAsync(record, {
"Result": updateValue
})
}
JB
Reply
1 Reply 1
Solved
See Solution in Thread
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
āMar 10, 2020 01:11 PM
Hi @Josh_Jennings - donāt think you can do this with a formula, but you can achieve it with a script block:
// @ts-nocheck
let table = base.getTable("Table");
let tableQuery = await table.selectRecordsAsync();
for (let record of tableQuery.records) {
let result = record.getCellValueAsString("Name");
let updateValue = String.fromCharCode(result);
await table.updateRecordAsync(record, {
"Result": updateValue
})
}
JB
Reply
