Hi all,
Iโm very new to Appsheet and Iโm still learning along the way. I was wondering if anyone could help me?
I am currently making a โCashing Upโ application which involves the user Inputting data (Cashing up) on form, which will then be calculated in a spreadsheet to then output answers back to the user, in which if any discrepancies occur, a message box will appear for reply.
So far my application allows the user to cash up with a time stamp, the ability for the user to write their name, till used and notes and coins counted. Once this part is done, the form is submitted to the โCashing up Spreadsheetโ here the data will be calculated.
But iโm having a hard time trying to figure out how the discrepancy message will be outputted back to the user? If any discrepancies occur of course. And I was wondering if anyone has any solutions for this.
Thanks!
@Aleksi_Alkio Well Iโll certainly give it a go! Thanks for the help!
How do you want to identify this message? With an email?
@Aleksi_Alkio Hi, Iโve just made action for the user to send a message through email. Iโm just stuck on how to apply this action to the chosen column. In other words I only want this email to pop up when a calculation in the spreadsheet shows negative.
Try something like AND(ISNOTBLANK([Column]),[_THISROW_BEFORE].[Column]<>[_THISROW_AFTER].[Column],[_THISROW_AFTER].[Column]<0) for the condition. It will fire the email when the value is negative. It wonโt send the email again if the record is udated somehow if that calculation has the same result again. And at the same time it wonโt send anything if the calculation result is blank. I donโt know if thatโs the caseโฆ if itโs not, you can remove that part if itโs not relevant.
How do you want to identify this message? With an email?
@Aleksi_Alkio Hi, Iโve just made action for the user to send a message through email. Iโm just stuck on how to apply this action to the chosen column. In other words I only want this email to pop up when a calculation in the spreadsheet shows negative.
Try something like AND(ISNOTBLANK([Column]),[_THISROW_BEFORE].[Column]<>[_THISROW_AFTER].[Column],[_THISROW_AFTER].[Column]<0) for the condition. It will fire the email when the value is negative. It wonโt send the email again if the record is udated somehow if that calculation has the same result again. And at the same time it wonโt send anything if the calculation result is blank. I donโt know if thatโs the caseโฆ if itโs not, you can remove that part if itโs not relevant.
@Aleksi_Alkio Well Iโll certainly give it a go! Thanks for the help!
User | Count |
---|---|
43 | |
28 | |
23 | |
14 | |
14 |