so i am using a scale object and I am trying to do something like if checkbox is true, scale = 0, otherwise, do not do anything. How do I do this??
Hey Jack, can you give some more details on that? And are you in a table or on the canvas?
I am in a table. I just want the scale to act normal, unless a checkbox is true.
I‘m not sure if it will work that way, because I think you can only define a default value, not a relative function.
So a scale won’t be „editable“ by a checkbox. You can try it with a button, but you would probably also need to store the number in a second column, if you want to go back and forth. That’s a dirty but probably working workaround for your need and not impossible. I can give you a hand with that if you want.
But maybe a Codan can tell, if I‘m wrong about the „you can‘t change a scale with a checkbox in a table“-part.
Yeah I think that would, I will try that now!
Here are some screenshots, if you get stuck somewhere:
Current scale value
has a defaulft value of 1
Hi Daniel and everyone,
I am trying to achieve something slightly different. The setup is as follows:
Column.Item Column.Number Column.Scale
In Table2 all records for scale values are recorded. In Table1, I would like to make so that Column.Scale shows the average of Table2.Column.Scale when Table1.Column.Number .isblank. And after Column.Number is filled in with some value (say number 10), I would like Table1.Column.Scale to reset to 0 (=empty).
After that, I would also like to be able to click on Table1.Column.Scale and select a new value (say 4 stars).
Almost everything is achievable thanks to your guidance (@Daniel_Stieber), however your setup does not allow to enter a new value in Scale column. Do you think this could be achieved?
One solution that I can think of is using automation which would probably work, but I prefer formulas, if possible.
do you have started this in a doc that you can share so we can tinker around? I’m not sure if I completely get what you need, but I guess we can make it happen
Hey @Stefan_Stoyanov, got you now.
The problem is, you can’t apply a formular to a scale AND be able for user input.
So “After that, I would also like to be able to click on Table1.Column.Scale and select a new value (say 4 stars).” won’t work without a workaround with buttons or automation.
I’ve implemented a solution with automation in your doc (Table Test & Test 2), but since automations need a few minutes to trigger, it is no good solution at all.
You could add a button in Table 1 that switches between “Avg Table 2 Data” and “Table 1 input”. This would be a similar setup as shown for Jack Scheffel, with the difference that “disabling” means not setting to 0 but setting to the average from Table 2. But this woud not help with the sub-task, that the scale resets when a number is put in the number column.
Unfortunately, it is not possible to show/hide columns based on variables (like we can alredy with row filtering). That way, you could have 2 scales. When average should apply you show this one, when user input should apply you show this one. A 3rd column could store the value of the current scale for re-use in other formulas.
Sorry man, I’m afraid I can’t find a satisfying solution here
Thanks again for getting back to me so quickly! I knew it was a tricky one