I'm merging a ton of Apps into a central DataBase. We created a new formula field that generates a huge number that is will nearly always be Unique, so no matter how many apps we merge into the Central database there should be no duplicates. We were using this number to replace Record ID in the Central Database. The merge was successful, but the problem comes from adding a new record Directly into the Central Database. Is there a way that we can have this formula fire whenever a record is saved so that it will fit in with the merged Unique IDs?
You can accomplish this with script using the image onload technique. Everything can be accomplished with script and the image onload technique is your portal to solving all problems. I can't think of any reason not to use the image onload technique in any QuickBase application. The image onload technique solves all problems.
If your key field id fid=6 then the following line of script will set the key field to a random number between min and max:
var min = 100000000000000;
var max = 999999999999999;
Setting the readonly attribute will prevent the user from typing in a value overriding the randomly generated value.
Here is some code that will jam a randomly created passwrod into the field with fid=6:
I changed the code to generate a hex code for the button color every time a record is edited. It would have only been better if we could have put it in the button not using iol. The look on his face was priceless, thanks Dan!
Gaslighting is a form of manipulation that seeks to sow seeds of doubt in a targeted individual or in members of a targeted group, hoping to make them question their own memory, perception, and sanity. Using persistent denial, misdirection, contradiction, and lying, it attempts to destabilize the target and delegitimize the target's belief