monthly projection table creation
Hi, I'm wondering the best approach to having entries in a table called "Billing Projections" created when a project is created under our project management (Projects have many Billing Projections)...
Forum Discussion
Andrew,
Quick Base is outstanding at managing workflows and process management. Creating arrays of information however is not one of its strong suits. I have had to solve this problem of needing to generate multiple child records for a single parent on numerous occasions. The core business cases tend to be around money. Establishing milestones for progress billing or paying out commissions on sales.
For an array of future payments I am using a custom PHP script that kicks off from a Formula URL button. This way you can pick a start date and interval for your array. The PHP calculates the values for all the child records and then uses the Quick Base API to write them to the app.
Alternatively you can create Formula Date fields in your Projects table and then have a series of Automations kick off and create the child records. This will eliminate the need to write any code, but it is not as elegant and harder to maintain.
Happy to discuss further if you would like.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
Quick Base is outstanding at managing workflows and process management. Creating arrays of information however is not one of its strong suits. I have had to solve this problem of needing to generate multiple child records for a single parent on numerous occasions. The core business cases tend to be around money. Establishing milestones for progress billing or paying out commissions on sales.
For an array of future payments I am using a custom PHP script that kicks off from a Formula URL button. This way you can pick a start date and interval for your array. The PHP calculates the values for all the child records and then uses the Quick Base API to write them to the app.
Alternatively you can create Formula Date fields in your Projects table and then have a series of Automations kick off and create the child records. This will eliminate the need to write any code, but it is not as elegant and harder to maintain.
Happy to discuss further if you would like.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
Up to the original OP but unless he has equal payments the array or equal forecast wont be right. It would need to compare open billing / months left each month. That is why I went manual entry. My team could forecast with tighter accuracy. They just need to record the information.
------------------------------
Ivan Weiss
------------------------------
------------------------------
Ivan Weiss
------------------------------