Howdy All
I am in the throws of cleaning up 3 years of data and its going “swimmingly” (sarcasm) .
In my main file with some 28,000 records, I can boil down the issues of whether a file has a photo stored or not. This normally has a Yes/No field but unfortunately in the early days that didnt exist so many records dont have anything at all.
Becase there is an automatic placeholder "no image on file"graphic in the file when its created, I have a mix of files WITH PHOTOS AND SOME WITH only the placeholder. Only way to differentiate is visually unfortunately a its a one-drive URL that identifies the image.
So in manually updating the Yes/No field I have to go through thse with no Yes or No and decided what to put. I can scroll down the page and then do an update (because its couple hundred) BUT
the handy select this reord tic box is so tiny and due to the tic box being the first "field"on a line it often reverts to the resize for the left hand side menu.
Anyway anyone knows of increasing the width of the field in raw database mode ?
If it was me I wouldn’t use the builder view. I would set up a new grid view page only showing the image and the checkbox and use in line edit to run through the grid clicking on the checkbox if its not the placeholder. If you filter for checkbox is unchecked that would keep reducing your list until all that’s left is placeholders.
Only using builder because it allows multiple selections and initiates an update of data on those selection en masse.
Not sure how U do that from grid view.
Ie change photo yes/no updated to yes on all selected records
There is an option on grid views to allow in line edit. You can just update the checkbox directly by clicking it. Simplest possible edit interface, like a spreadsheet.
Yes been there done that, doing them one by one is laboriously slow when you have 3-400 to do with ones in the middle that don’t need changing
Ok, then perhaps this suggestion - it is 1 click to change the yes/no.
Create a grid view showing just the IMAGE, the YES/NO field, and an ACTION button that sets the YES/NO field to YES. Add a default filter to hide records if YES/NO = YES. Display 1000 records at a time. This will show you all the records where YES/NO is blank, and as you pick them off by simply clicking the action button, they will vanish, leaving you with only those records that you dont want to set - presumably the ones with the placeholder.
See Knack (berrell(dot)knack(dot)com(slash)sandbox#photo-updater) as an example - took less than a minute to create this page.
