📖 Recreating Standard 'Status' Export on a Reference Widget

One piece of implementing a Custom Reference Page is the Custom List Fields that the widget-scoped form exports. The Status export is a bit tricky.

The following formula logic should reproduce the out-of-the-box Status output:

case
when @excluded = 1 then 'Excluded from consideration'
when @submitted is not null then 'Submitted by recommender on ' + @submitted
when @opened is not null then 'In progress as of ' + @opened
when @delivered is not null then 'Sent to recommender on ' + @delivered
when @delivered is null then 'Not yet sent to recommender'
end

Remember to give @submitted, @opened, and @delivered a nice date format mask to avoid applicants seeing statuses like "Submitted by recommender on 2023-02-09 15:52:26.977."

Try d for 2/9/2023.