Forum Discussion

MichelleMichell's avatar
MichelleMichell
Qrew Cadet
8 years ago

Calculated fields keep diappearing

Hello,

I created two formula fields in a table that are used to extract the year and week number from the date codes in my original data set. However, these fields periodically show up blank in the table and reports, even though they were correct when I viewed them earlier.  The only way I've found to get it to go back to normal is to open the properties for one of the fields and save it again, which causes both to show up correctly again.

While this is only a minor nuisance for me, I'd like to find a way to prevent this from happening to other users when the app is complete.  Any input would be greatly appreciated!
App builders
Ask about Quickbase functionality
Errors
  • MichelleMichell's avatar
    MichelleMichell
    Qrew Cadet
    8 years ago
    I figured it out by creating a separate table just for the date conversions and used those as lookup fields in the main table, which seemed to help since it didn't have to do a separate calculation for every line of data.
  • JohnThomas's avatar
    JohnThomas
    Qrew Cadet
    8 years ago
    I think this will help you to show the year and week directly in a single field

    var number days = ToDays( [Date] -Today());
    Year([Date])&"_"&Ceil(ToWeeks(Days($days)))

    Replace Date with your date field 

    I hope this will solve your issue!!