I have a situation where I want to format all the datacards in my page based on a hidden seed data card... of course, that means (unless I'm missing something) that I have to edit each and every field of every key and value of every data card (there's 40 of them) and paste the function to reference the first data card.
That's a lot of work... a lot of repetitive work... which, in my mind, means it should be doable in some way programmatically.
The problem is that I can't edit them all at once. So, I got the bright idea, what if I copy and paste fields?
Well, that worked on some of my data cards... I was able to copy and paste the value field, anyway, and it actually updated with the values of its host datacard (though I had to change the update formula of the datacard to point to the new value field). Titles were a little bit trickier (they wouldn't let me specify their height), but creating a custom data card and using the title from that let me do what I needed.. so great, all well and good...
Until suddenly it didn't work.
For some reason, the data card I'm trying to edit right now isn't letting me paste either my custom data card title or the value. Now, maybe it's because the data type changed - I can see that affecting the value... so great, I went in and manually set up those fields, with the hopes I could copy and paste them to later data cards... but the title field is escaping me. I can delete the old one, but I cannot paste a new one in.
I'm making absolutely certain I've selected the data card... and it works on other data cards to paste... just not this one.
So, two questions:
1. What's wrong? Why am I not able to paste into this data card when I was able to on all the others?
2. Is there another way to handle making all these changes at once, perhaps through a function somewhere?
