Jul 03, 2022 02:42 PM
on “IiloscZlotowekTydzien” i have formula =iloscZetonow*2.
Field iloscZlotowekCalosc I need to update each week by adding iloscZlotowekTydzien to iloscZlotowekCalosc.
Any idea how to do it?
Jul 03, 2022 08:26 PM
Hi Maciej, I’m not too sure whether I understand the problem correctly. Could you tell me which of the two below is the one we’re trying to achieve please?
We only want last week’s value, where it would look something like this:
We want all of the previous week’s values, added together:
Once you’ve confirmed which option it is I’ll figure out how to automate it
Both of these can be found here
Jul 04, 2022 12:07 AM
Thank you @Adam_TheTimeSavingCo. I have Option 1 in my mind.
Thank you for the link but I can’t see the formulas on each column.
Jul 04, 2022 02:48 AM
To view the formulas, duplicate the base by clicking the title of the base at the top of the screen, then the three horizontal dots on the right, and then the “Duplicate Base” button.
Roger that. The idea is to:
Only last weekfield)
Last week's valuefield)
If you’re alright with it, you can do this manually by linking last week’s record to this week’s record.
If you want it to be automated, then you’ll have to create a system to find last week’s record by linking all of your existing records to one record and using
I’ve updated the original base with just such a system and automation. I’m unsure if this is what you’re looking for; let me know if it is and I’ll answer any questions you have.
(You could also accomplish this via a script, but you’ll need a Pro account and someone that can write the script for you; I can help with this as well if you need it)