ContributionsMost RecentMost LikesSolutionsURL edit record through email I have created a URL edit button that goes out with the email that allow our registered user to action task by clicking the button if they already logged on, the API call will work fine. However, if they are not, they will receive an error message which request them to sign in. instead of having the error message, is there a way for them to simply put in their log in details so that the call can continue any help is appreciated. Thanks ------------------------------ Leon Wong ------------------------------ URL edit record through email I have created a URL edit button that goes out with the email that allow our registered user to action task by clicking the button if they already logged on, the API call will work fine. However, if they are not, they will receive an error message which request them to sign in. instead of having the error message, is there a way for them to simply put in their log in details so that the call can continue any help is appreciated. Thanks ------------------------------ Leon Wong ------------------------------ Mobile phone Pop Up alertI am setting up a button with javascript pop-up alert if certain criteria is not met This button works fine on browser but it stops working when click it through my APP it will take me straight to a browser. Has anyone had any idea how i can get around this. Thanks below is my code. any help is very much appreciated If(not IsNull([Actual Completion Date]), "<a " & $style & " href=\"javascript:alert ('Task has been completed!!')\">" &[Task Status]&"</a>", ------------------------------ Leon Wong ------------------------------ Mobile phone Pop Up alertI am setting up a button with javascript pop-up alert if certain criteria is not met This button works fine on browser but it stops working when click it through my APP it will take me straight to a browser. Has anyone had any idea how i can get around this. Thanks below is my code. any help is very much appreciated If(not IsNull([Actual Completion Date]), "<a " & $style & " href=\"javascript:alert ('Task has been completed!!')\">" &[Task Status]&"</a>", ------------------------------ Leon Wong ------------------------------ Re: How do i calculate monthly balance for multiple product?Thanks Blake. your flowchart and guidance have given me some ideas!!! manage to work out with less tables (not sure if this concept is similar to your thought process) what i did 1. Product (master) connects to product movements (child) 2. summarise monthly movement into Master table (12 new summary fields) 3. Create accumulated fields for each month against each product in product table (another 11 new summary fields) 4.create accumulated lookup fields in Product Movement table (child) for each month (12 new lookup fields) 5. create a formula field to workout the balance each record should pick up 6. Month table (master) connects to Product movement table (child) 7. Create average summary field for each product in month table i will then get the below table on Quickbase that calculates the accumulated usage in each month for each product which is identical to Excel ------------------------------ Leon Wong ------------------------------ Re: How do i calculate monthly balance for multiple product?Hi Blake I am restructuring the APP (nothing has been setup yet) so that the team can get the above sample report on Quickbase I am able to get around using excel connection to download the usage into excel, formulate them and feed the numbers back into Quickbase in the above table format. However, this means the team can view this in live environment and this creates another manual process I have tried several times, the relationship i created is able to pick up the stock movement for each month (ie a month table that has many orders/movements) and i struggle to come up idea that is able to summarise the balance for each month for each product without potentially creating hundred of fields. We try to future proof this in the future as the department might source more products. appreciate your help thanks ------------------------------ Leon Wong ------------------------------ How do i calculate monthly balance for multiple product?I work in a project delivery department The department source a few products from overseas and we use quickbase to facilitate the delivery and orders we currently extract all data into excel and use excel to report the products balance each month. we have been trying hard to find a solution within Quickbase to provide a live update in graph format each time the product movement is updated/created below is a screen shot of the graph we try to achieve in Quickbase any help is much appreciated ------------------------------ Leon Wong ------------------------------ How do i calculate monthly balance for multiple product?I work in a project delivery department The department source a few products from overseas and we use quickbase to facilitate the delivery and orders we currently extract all data into excel and use excel to report the products balance each month. we have been trying hard to find a solution within Quickbase to provide a live update in graph format each time the product movement is updated/created below is a screen shot of the graph we try to achieve in Quickbase any help is much appreciated ------------------------------ Leon Wong ------------------------------