Use outcome in formula field in another formula field
Accepted Solutions
It’s a replacement for the let returnValue = line…
Here’s a new version that works:
/*
***********************************************************
Airdrop - Fast Lookup
Copyright (c) 2020 by Global Technologies Corporation
ALL RIGHTS RESERVED
***********************************************************
*/
// display app title
output.markdown('# Perform Fast Lookup');
// get the main table data
let mainTable = base.getTable("T1");
// get the data set for the main table
let mainTableRecords = await mainTable.selectRecordsAsync();
// get the lookup table data
let lookupTable = base.getTable("MonthLookUp");
// get the data set for the lookup table
let lookupRangeRecords = await lookupTable.selectRecordsAsync();
// create index hash object for the lookup table
let oLookupData = {};
for (let record of lookupRangeRecords.records)
{
oLookupData[record.getCellValue("Month Name")] = record.name;
}
// output.inspect(oLookupData);
// update the main table based on the lookups
for (let record of mainTableRecords.records)
{
// get the lookup key
let lookupValue = record.getCellValue("DateTypedIn");
// get the lookup values
let returnValue = (oLookupData[lookupValue] == null) ? "Nothing Found" : oLookupData[lookupValue];
// output.inspect(returnValue);
// update the main table
mainTable.updateRecordAsync(record.id, {
"StartDateMonthNr" : returnValue
})
}
Hi Justin,
you are so right - and lost so much time;) Thanks to your right hint - this DAU Problem is solved.
I have another break when I try to use the solution for a lookup.
Let me explain:
I have this 2 tables:
In T1 I already have my StartDateMonth via formulas. Now I want to use the value in fields of {StartDateMonth} to been looked up in the “MonthLookUp” Table:
Therefore I use this script in a script block:
No matter if I use the formula field {StartDateMonth} or the values in {DateTypedIn} (that I just manually typed in randomly to check if it was the field type that mattered)
=> effect is nothing!
=> while expected behavior would be: that I have the corresponding value like 5 (for May) or 7 (for Jul) in T1>{StartDateMonNr}.
Any idea what I am missing here?
Help is highly appreciated.
Reference:
