Hi,
First Iโm not english, sorry if my english is bad
Iโm a new appsheet user and Iโm trying to develop an app which allows you to enter what youโve done (an operation), the date, whoโve done it and the price.
But, all operations have a fixed price, and there is a last operation called โOtherโ which has no fixed price (itโs in a calc, letโs say there is op1, op2, op3 with a value in euros and โOtherโ with no value).
When you add an operation, the price is fixed (the formula is [Operation].[Price]). But, when you choose the operation โOtherโ, you canโt manually enter a price and if you add the row you just have no price.
What I want is when you choose for example op1, it suggests you the price of op1 but you can still change it, and when you choose other, it suggests no price and you have to enter one (eventually it suggests 0, if necessary).
Baptiste
For the Price column, configure Editable? with the expression:
AND(
ISNOTBLANK([Operation]),
([Operation] = "Other")
)
Hey, thanks for your answer. Actually, I just filled the โInitial Valueโ with formula [Operation].[Price], I might have missed it earlier, donโt know why.
Now Iโve a new problem, iโm trying to just make a bot that creates a new row in a different data set, which computes the money gained each day, but I canโt make a bot, I have an event of type schedule triggering each day and a process with only one step that add the row that I want, but when I try to create a bot I can choose my event and then I canโt choose my process and canโt create the one I want, and I donโt know why.
Baptiste
NB : I missclicked the โSystemโ button when I created one event and now I have this message if I ever click on it (I canโt even delete it)
Error: this component failed to render. Please report to support with a screenshot of this error message so it can be fixed.
Error: Minified React error #130; visit https://reactjs.org/docs/error-decoder.html?invariant=130&args[]=undefined&args[]= for the full message or use the non-minified dev environment for full errors and additional helpful warnings.
(I cant copy everything bcs of all the links)
This is an internal bug. Please contact Support for help with it.
Just reported the bug to the support, but I still donโt know what iโm doing wrong with the bot. Iโll try to be more precise. I have a list of operations in a table, with the date and a price each time. I have also a table in which I would like to have, for each date, the sum of all the operationsโ price, but I want this to be automatically done each day. So I tried to make an event that triggers every day at 3am, and a process with only one action which is a data action that add new rows, and set the date of this new row to TODAY() - 1, and the sum should be automatically computed (with a formula). But I canโt create a bot with this event and process. I feel like I am missing smthg because when I try the action (without the bot and the process), I need to execute it from a row of the operation table, like it needs a row to execute, while it shouldnโt.
Thank you for the help, hope youโll understand what I explained.
Baptiste
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |