ContributionsMost RecentMost LikesSolutionsExtract Data from separate Table Hi, Within my application, I'm looking importing data from a table into a form for calculation. Was trying to use the GetFieldValues(GetRecord ) command to get a specific value from a table. Will work if I pass a fixed Record Identifier and required Field, but we need to be able to dynamically pass through the Record Identifier. Is it possible to incorporate the value for Record Identifier as variable, which we can be dynamically as required. Rgds Pat ------------------------------ Patrick O'Neill ------------------------------ Expose Count Of Records In ReportHi, I've created a report to pick records from a table based on a set criteria - is it possible to add a formula object to a form to display the number of records in my Record Picker report. Want to use the count of records to enable / disable certain features from within the report. Rgds Pat ------------------------------ Patrick O'Neill ------------------------------ Re: Dynamic Adjust Status IndicatorHi Mark, Worked great and good reference material to have - thanks. Rgds Patrick ------------------------------ Patrick O'Neill ------------------------------ Dynamic Adjust Status IndicatorHi all, With in my Form I'm performing a number of calculations which result in a final score, which I then display with an indicator, where the color depends on the score achieved. However for this indicator is there a method to adjust the width so it increases with the score. Have tried a another variable and then reference it within the width parameter - but that is not processed. Have attached an image and highlighted the attribute I would like to dynamically adjust. Rgds Patrick ------------------------------ Patrick O'Neill ------------------------------ Re: Share Variables Between Formula / Global VariableThanks Mark - will implement and test. ------------------------------ Patrick O'Neill ------------------------------ Share Variables Between Formula / Global VariableHi, Have a numeric formula, which is performing a number of calculations in order to determine an overall result. I must perform this calculation multiple times throughout the form with only minor changes to one of the calculations. Is it possible to expose the variables that will not change, so they could be used throughout the App - making them a Global Variable. Rgds Pat ------------------------------ Patrick O'Neill ------------------------------ Global CalculationHi, Have a common calculation which is being used multiple time (formulas) with a Form. Is it possible to move this formula to a function within a code page and call as required from within the Form. This will future proof my application, as any updated to the formula at the code page level will be automatically utilized within the From, removing the risk of having to update multiple instances of the formula. Rgds Patrick ------------------------------ Patrick O'Neill ------------------------------ Re: Formula Rich TextHi all, Got this sorted - my script was incorrect. Rgds Patrick ------------------------------ Patrick O'Neill ------------------------------ Formula Rich TextHi, Using Formula Rich Text box as visual indicator - is it possible to incorporate text with the indicator. Rgds Patrick ------------------------------ Patrick O'Neill ------------------------------ Re: Multi Choice - Radio ButtonThanks Mark ------------------------------ Patrick O'Neill ------------------------------