Hello Bubblers,
I hope you’re all doing good.
First of all let me give you a bit of context. As you can see below, this is one of the lines that displays information regarding one of my current deals for a freelance worker. When I create this deal, I indicate the date of beginning of the mission and the date of ending.
Then, each month, I want to indicate the number of days he worked during the month in the Input “Number of worked days”. (This field must be handwritten by me due to organization constraints)
My question is: How do I make this field save the data I have populated for each month, in my database?
For example, my freelancer works from the 1st October to the 30th November. I want to be able to indicate how many days he worked for each month.
Is this feasible in the same field? How can I make this possible ?
Thanks a lot in advance for your help and have a nice day
its simple, i belive you have a data type for each month ( the row you are showing ) … just add a field in it like worked days … and then only let a user with permission to update it.
Hello Baloshi, I hope you are doing good!
On my side, I have the data type “deals Freelance” where I basically save the date of beginning of the contract and the ending date of the contract.
I do not have a data type for each month, but should I create one?
Is it not possible to use conditionals or workflows for my “number of days worked” to be stored in the correct month? The best option would be to only have one input field where I indicate the number of days worked, linked to the current month.
For example, my freelancer has worked 10 days in october. I fill in 10 days at the end of october, click on save and the 10 days are saved in October. Once the current date is november, I’d like the field “number of days worked” to be reset and that the data being entered from now on is saved for November. Then, my freelancer works 12 days in November and I indicate 12 in the input field.
This would mean that I have one entry for october with 10 days and one entry for november with 12 days.
Please let me know if I’m not clear, I’ll elaborate.
Thanks a lot in advance for your help Baloshi! Have a nice day
Hi,
This is how I would do it: in your current data type “deals Freelance” I would add two more fields: Month and WorkedDays.
Then go to workflows…add a new workflow →
So when your input value is changed → make changes to a thing
and then add the month and the days to your db
After this you add a final step
And this will reset your inputs so you can add more days for next month.
Let me know if this worked for you.
Cheers,
1 Like
Hello Razvan,
Thanks a lot for taking time to explain this to me! I confirm that it works 
Thank you very much again for your clear explanation!
Have a nice day,
1 Like
