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 |
Love it!
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.
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.
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?
Greetings
Just checking on status of this idea? Is it still in development?
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.
This feature is still in active development. We will update this idea as we make progress.
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.
This is a great news Nathaniel. Thank you.
Hey Paul - Thanks for reaching out. We plan on addressing this in 1H of 2021. It is in active development now.
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?
Sorry about that, Paul. I mistakenly selected the incorrect status. We are planning to address this in the 2H of this year.
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.
BTW: This is not a new feature request. It's a defect in Aha!'s updating system. Bugs need to be fixed.
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.
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.
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.