I am trying to add a change counter for how many uploads are made. I have a column ‘Upload’ that is type image. I have another column ‘change’ of type changecounter. I want the counter to increment by 1 whenever an image is uploaded. I do not want the counter to change when an image is cleared. Is there such a value as NOT “null” so that my counter only counts upload?
I’m pretty sure there should be a more beautiful solution.
But, in theory, instead of deleting rows you can set them as “deleted” and filter not deleted rows using a slice.
Then, the COUNT() function can be used to count absolutely all uploads
Hmmm. The data for my uploaded images is actually saved to a different table. I am simply using the main table as the vehicle to do the uploading. Images that are cleared don’t actually get deleted from the images table.
If I clear the image, it gets removed from the main table, but it is not removed nor marked on my actual images table. I did this intentionally since the actual image is still stored in Google Drive. (As far as I know, clearing images does not delete the picture from Google Drive.)
Lets imagine we have two tables:
Then:
Create a column in the parent table “Change Counter” with type “Number”
Create an action for the parent table called “Count images: +1”
[Change Counter] +1
Create an action for the child table called “Count images: trigger parent”
ANY(SELECT(Parent table[ref id column],[_THISROW].[ref id column] = [ref id column]))
Create a workflow for your child table with images
I didn’t check it, but in theory it should work just like requested 😃
User | Count |
---|---|
39 | |
32 | |
30 | |
16 | |
14 |