Hi,
I’m creating a table to track playlists and their curators. To stop me from adding duplicate records by mistake is it possible to set a requirement/validation on a field that all data must be unique.
To be more specific, I’m currently using Knack...
Hi,
Firstly … sorry for such a basic question but I’ve been through pretty much all the options a few times and still a blank look on my face!
I’m planning to migrate over from Knack.com, here it’s easy to set a url column of data and change it to a ...
Yes your absolutely right … I had a few Curators with our url data. Which was only a temp thing. In future this will be a required field so this shouldn’t be an issue … I’m hoping!
Am cleaning up that part of the data and will re-run … in theory I gu...
Ah fantastic … thank you so much for checking the code. It’s so almost working ;o)
When I hit run it’s populated 15 rows, in a random order, and missed the rest, which is about 435 other records. Mmmm. I’ll have a dig around the data to see if someth...
Hi Bill,
Ha ha … yes you are right and I’m afraid even that’s a bit beyond me. I did try it but not entirely sure what it’s doing.
I did however try and almost understand what’s going on here with this script example, posted here, but couldn’t get it...
Yikes … looking in the Script Block and the amount of custom code needed to create a simple hyperlink, using text from another field, is utterly bonkers!
I think I might just use a button for now … and wait for Google Tables to be released to the UK!...
Hi Bill,
That’s great, thanks for clarifying. I’m off to now watch a few videos about Scripting Blocks so I’m sure I’ll have it up and running soon!
Cheers
Nick
