It is an app that points to 2 Sharepoint lists, 1 with 7 columns (demand) and another one with 5 columns (availability)
column type details in the images.
How does it work:
Availability: The manager registers the availability (monthly %) of the resources to be used in projects.
Demand: the PM requests the time in which he needs that resource for his project.
The appearance of the app in the attached images
A formula (or way) in which you can add the demand for each resource (within the established date), and if it is greater than the availability of that resource (previously registered) on the available date entered, a warning would appear that there is overdemand (also the % of demand entered for those dates changes to red color).
from the pictures it looks like you have a data table that is only used to display data and not to manipulate it. To achieve your goal, add a gallery, a demand text input and a save button. When you select the button, you need to build your logic.
First, you need to look through the table to find the availability of the selected resource (Lookup function). If the result of Lookup().availability is less than the demand, update the row, otherwise set a variable (say var_visible) to control the visibility of the warning message (a label)
Hello @anibra ,
Both screens have a gallery as you can see in the attached image.
The edit the items in the gallery, click on the ''edit in grid'' button or hit the ''new item'' button to add a new line.
To save, click again on ''exit grid view''.
Any idea how to find a formula like the one mentioned above? involving the resources (individual sum for each one) and the dates...
I still do not understand how to sum all the demand entries by date for each resource. Could you explain more in detail?