Today's release introduces several much anticipated features:
Page builders can now use a field card to select one or more line items to publish to a page.
You can use a field card to focus the attention of users on a selected line items. If the line item is editable, users can edit the data and see their changes reflected throughout the app, and any other app that is linked to the same model.
When users edit a field, the data updates, in real time, anywhere the value displays or is used in a calculation. Any charts that rely on the data are updated, and where the change affects conditional formatting, this updates, too. Decision making for your business is more informed as the implications for the change are visible.
On the board in this example, the grid displays the target revenue by region (Target), the current planned revenue for each region (Plan), and the percentage difference between the two (Delta). A field card displays the line item Threshold. This line item allows users to set a percentage threshold that Delta should meet. Conditional formatting is applied to the Delta column, so that when the threshold for a region is not met, the Delta cell for that region is highlighted in red.
For example, if we change the threshold from 20% to 30%, the cells for the Delta values for EMEA and APAC change to red as Delta is not meeting the threshold for these regions.
In this worksheet, a grid displays the gross margin for the previous year (Prior Year), the increase target for the current year in dollars (Initial Target), and percentage increase (Initial Target %). These are each broken down by geographic region: USA, EMEA, and APAC. A field card displays the line item GM Target %, which allows you to set the target for gross margin increase.
When you change the GM Target % value from 10% to 20% the related values in the grid update. For example, EMEA's target increase changes from $7,751,208 to $15,502,415.
To create a field card, simply:
Learn more about how to add a field card to a board or worksheet, and how to use the field card.
Forms now support adding items to list subsets, increasing the number of ways that users can interact with your data.
Learn more about configuring forms.
A much-requested feature, waterfall charts are a great way of showing what has resulted in a specific value in your data.
Waterfall charts include settings to:
We value your input! To leave feedback at any time, click Feedback in the navigation bar, then select Feedback.