Skip to Main Content

Share your product feedback

114 VOTE
Status Shipped
Categories Application
Created by Spencer Abrams
Created on Mar 25, 2020

Allow custom worksheet fields to populate without clicking on field in each record

I created a custom worksheet field for my features, and every row in my worksheet contained formulas that were derived from other fields. The formulas in my worksheet only produce values after I manually click on the worksheet field in every record individually. If I run a List report with the worksheet information included, only those records where I have previously clicked on the worksheet show up with values, even though the data is there to calculate the formulas without entering anything into the worksheet.

It would be great if the worksheet values were populated automatically, or if I could create an automation or run a bulk edit that would trigger the worksheets to calculate.

Release time frame 6 months
  • ADMIN RESPONSE
    Mar 13, 2024

    You can now easily activate any worksheet via bulk edit in list reports:

  • Attach files
  • Nicola Rolando
    Reply
    |
    Mar 26, 2024

    Love it!

  • Steven Schafer
    Reply
    |
    Sep 12, 2023

    Please this will make our use of calculated fields so much easier, as right now we have to open each calculated field in the record, click refresh and then go onto the next one. This is extremely time consuming.

  • Carl Veillette
    Reply
    |
    Aug 18, 2022

    Makes the feature unusab=le we can never trust the value we are looking at. Not knowing if the refresh on items below was done or not.

  • Guest
    Reply
    |
    Jul 27, 2022

    I'm happy to see that the refresh is no longer necessary but what about the initial calculation. Is this part of the request still being considered?

  • Karla Johnson
    Reply
    |
    Feb 15, 2022

    Greetings

    Just checking on status of this idea? Is it still in development?

  • Lisa Bruce
    Reply
    |
    Aug 10, 2021

    I agree this is an oversight. Not an improvement, this is a defect. We have a pet name for this defect called 'Project Pecking Bird' wherein well paid employees have to click refresh 1000s of times as a team, whenever we happen to be on the record.

    One of our very ingenious MIT interns wrote a mac os macro to automatically click the Refresh buttons.

    Please fix this.

  • Admin
    Nathaniel Collum
    Reply
    |
    Aug 10, 2021

    This feature is still in active development. We will update this idea as we make progress.

  • Sneha Gangadharan
    Reply
    |
    Aug 10, 2021

    This looks like a defect to me. The fields need to refresh automatically. It makes adding a worksheet into an VERY time consuming to get each record to update to be usable. At the very least, till you fix it please provide a Bulk Refresh option so we do not have to update every feature.

  • Cyril Bousquet
    Reply
    |
    Dec 10, 2020

    This is a great news Nathaniel. Thank you.

  • Admin
    Nathaniel Collum
    Reply
    |
    Dec 10, 2020

    Hey Paul - Thanks for reaching out. We plan on addressing this in 1H of 2021. It is in active development now.

  • Guest
    Reply
    |
    Dec 9, 2020

    What's the status of this feature request. It appears it's still not updating worksheet fields automatically and there's a lot of votes on this feature. Release time frame says 6 months. Does that mean 1H 2021?

  • Admin
    Nathaniel Collum
    Reply
    |
    Jun 11, 2020

    Sorry about that, Paul. I mistakenly selected the incorrect status. We are planning to address this in the 2H of this year.

  • Guest
    Reply
    |
    Jun 11, 2020

    Disappointed by the status change to "Future consideration". I still consider this a bug rather than an enhancement "nice to have" feature. These fields should simply be updated automatically.

  • Guest
    Reply
    |
    May 15, 2020

    BTW: This is not a new feature request. It's a defect in Aha!'s updating system. Bugs need to be fixed.

  • Guest
    Reply
    |
    May 15, 2020

    I'm suffering from the same issue. Our company purchased the most expensive license to make full use of the customization options. Without automatic updating of the worksheet field it make it impossible to use this customization option effectively.

  • Robert Rodriguez
    Reply
    |
    May 6, 2020

    This is very frustrating functionality. I agree with the other comment, it makes adding a worksheet into an established system very difficult as you have to go feature by feature and click the "refresh" button to generate the worksheet.

    I too would be satisfied with a a bulk edit function where we can trigger the worksheets (for specific features) to calculate.

  • Guest
    Reply
    |
    Apr 16, 2020

    Why is this unlikely to implement? It makes adding a worksheet into an established system VERY time consuming to get each record to update to be usable.

  • +25