ContributionsMost RecentMost LikesSolutionsRe: Upcoming Changes to JavaScript in QuickbaseWe are just bringing time and payroll processing on line with Javascript controlling all of the interaction through buttons (not even iol stuff). We've been working on it for a year and half. Losing the ability to interact with the DOM makes this package no longer viable for our needs. But I think it's a good business decision on QuickBase's part and will benefit them long term.Centralized Management of SubscriptionsHas anyone found a slick way to centrally manage subscription lists? Our number of subscriptions continues to grow and we are wanting to come up with a way to easily add and remove people from subscriptions without having to go to each individual table. Ideally, we would add a checkbox field for each subscription to our "Team Members" table and then we could just check the box for each subscription they wanted to receive. All ideas are welcomed. ------------------------------ Brandon Clark ------------------------------ Re: Regarding Address Subfields extensionFrom my understanding you will need to break it back out and just use regular fields instead of the address field type with subfields. If you want it to behave similarly, you could always have the individual address entry fields visible for add/edit and then have a formula URL field visible for view that concatenates it back down to an address link. ------------------------------ Brandon Clark ------------------------------ Re: Using iol to Select Tab of Child After Adding Child RecordStarting to see the first minor flaw in the plan. The fid_104 is required to be visible on the form for this work. I can live with that for now but any thoughts on a better way to pass the information without using it on the form? ------------------------------ Brandon Clark ------------------------------ Re: populate calendar through a buttonMake sure you have your default calendar app already set. Using Chrome at least, when you click on the iCalendar field and download it, you should be able to click the up arrow next to the file and select "always open files of this type." Select that and then the next time you click on iCalendar it should at least pop the invite for you in edit mode. Also, I have formula field that will allow you the following if you are interested. I found it be a little more natural. 1. Select date form calendar 2. Enter start time separately 3. Enter duration 4. Have it concatenate the Start Date/time and calculate the Stop Date/Time for iCalendar export. ------------------------------ Brandon Clark ------------------------------ Re: Using iol to Select Tab of Child After Adding Child RecordIt works brilliantly. Everett you are genius. Thank you. ------------------------------ Brandon Clark ------------------------------ Re: Using iol to Select Tab of Child After Adding Child RecordYou nailed it. I let the original parameter back in on a copy/paste. The tab selection is working now. And I now understand how to check the parts along the way. You guys are awesome. (Side note: For anyone else that is struggling with Javascript, I found this little tutorial to be a pretty efficient way to learn the basics -https://www.learn-js.org/) Now for the last piece, I need to take a stab at setting the Tab #field back to 0 after the focus. Will post what I figure out. Here's the code page as it stands: (function () { //Get the expected tab value var QBUmytab = Number($("#tdf_2").text()); //Go to tab based on value switch(QBUmytab) { case 2: $("#tab_t2_link a").click(); break; case 3: $("#tab_t3_link a").click(); break; case 11: $("#tab_t11_link a").click(); break; case 20: $("#tab_t20_link a").click(); break; case 30: $("#tab_t30_link a").click(); break; };})(); ------------------------------ Brandon Clark ------------------------------ Re: Using iol to Select Tab of Child After Adding Child RecordOk, that was really good info. So here's my first shot at dividing it up. Both of the alerts with the values are displaying NaN. It is not making into the Case 11 as expected. (function () { //Get the expected tab value alert("lets go fishing"); alert( Number($("#tdf_1").text()); var QBUmytab = Number($("#tdf_1").text());alert(QBUmytab); //Go to tab based on value switch(QBUmytab) { case 11: alert("No way, it's too nice out."); $("#tab_t11_link a").click(); alert("But there's free bait!"); break; case 13: $("#tab_t13_link a").click(); break; };})(); ------------------------------ Brandon Clark ------------------------------ Re: Using iol to Select Tab of Child After Adding Child RecordThanks Austin. It appears the QBUmytab variable is not getting defined. Did #tdf_1 need to be edited for my implementation or does that convert to fid_104? I've tried simply changing to tdf_104 with no luck. (function () { //Get the expected tab value var QBUmytab = Number($("#tdf_1").text()); console.log(QBUmytab); //Go to tab based on value switch(QBUmytab) { case 3: $("#tab_t3_link a").click(); break; case 4: $("#tab_t4_link a").click(); break; };})(); And I agree on getting used to adding the troubleshooting code. I probably have 30 hours into just trying to accomplish this one task. But if I have this snip with the code to debug each step along the way then I can start using this as my reference example to build out from and start getting some context to better understand the javascript documentation. Thx again, Brandon ------------------------------ Brandon Clark ------------------------------ Re: Using iol to Select Tab of Child After Adding Child RecordHi Everett, I pasted the code in but nothing is happening. Do you by chance have any debugging code I can insert to see if the variable is passing in and if the cases are selecting properly? Thanks! Brandon ------------------------------ Brandon Clark ------------------------------