Matt Overton Posted July 2, 2020 Share Posted July 2, 2020 (edited) So in a worksheet it's fairly trivial to build a formula that takes the Length and Width of a space object in millimetres and reports the calculated dimensions in Metres with 1 decimal place. How can I use this formula to show my custom text as part of the space label? Edited July 2, 2020 by Matt Overton Quote Link to comment
Matt Overton Posted July 2, 2020 Author Share Posted July 2, 2020 I'm guessing the only way currently is a custom menu command to walk through all space objects and update one the custom fields and use that in the space label. Quote Link to comment
Pat Stanford Posted July 2, 2020 Share Posted July 2, 2020 There is no default way to "push" a calculation from a worksheet cell back to an object. It could be done with a relatively simple Worksheet script. Easier if you are using it in a database row. The worksheet script would do what you suggested for the menu command and store the value into a custom field (or even a custom record.field) that you could then use in the label. The field value would update each time the worksheet is recalculated. Let me know if this seems like it would be helpful and I can see about doing a script. Quote Link to comment
Matt Overton Posted July 6, 2020 Author Share Posted July 6, 2020 I hope it's been noted previously that the link on this page to more information contains less information. Quote Link to comment
Pat Stanford Posted July 6, 2020 Share Posted July 6, 2020 I have posted several Worksheet scripts and tried to comment them as documentation. Let me know what you are trying to do and I will try to help. Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.