ContributionsMost RecentMost LikesSolutionsRe: Your File's so Fat... (File too large for Preview) I think I found the problem via Google... Note: The maximum file size limit for the Google Doc Viewer preview is 25MB, this is not a limit that we can change. Open to ideas... ------------------------------ Meredith Moore a.k.a. Quick Base Girl Dallas TX ------------------------------ Your File's so Fat... (File too large for Preview) Have any of you ever gotten this before? This is for an xlsx file that is 34.6 MB. (I know, I know) Is there a limit of file preview sizes? I know the file upload limit is 100MB... ------------------------------ Meredith Moore a.k.a. Quick Base Girl Dallas TX ------------------------------ SOLUTION: Making your Conditional List pretty (with html) So, I have seen it on the forum many a time "How do I make a list look like a list, but [insert complication/conditional here]...". Well today I'm gonna give you all some code that may be helpful to start down the path of making stuff look gooder without having to use scripting or hire Dan. (All the love to Dan, as he has helped every one of us at some point.) Ok here we go. All HTML, all the time... The Problem You have a Contact (named Nicole Samkange) and you want to submit her for a new job as a "Content Champion" on a client account. You need to know if she is already on the account and who else is on the account ("...She works well with Bob, but not with Sally" or whatever the reason). You also need to know if someone has already submitted her for the job, as there is nothing HR likes more than 20 submissions for the same thing. The lists we want You also have many different roles you can request for her (or anyone) but you only want to show what is relevant. So let's look at the fields we want to work from... The conditionals we have... The code we make... So, you need to make yourself a nice Rich Text Formula field and a case statement. But, let's break this down. What are we looking at? What it looks like broken down Case([Role], //(1) "Content Champion", //(2) If(ToText([Current Content Champion])<>"", //(3) "<h3 style='color:steelblue;'>Current Content Champion Contacts</h3>" //(4) &"\n" //(5) &SearchAndReplace(ToText([Current Content Champion])," ; "," <br>") //(6) ,""), //(7) (1) Start with a case statement. This is what you will be breaking all your lists up by. In this case the job [Role]. (2) List all of your [Role] choices in "". You are literally looking for when the [Role] matches this text. (3) When your [Role] matches your text you must tell it what to show, but we want this to be conditional, so we will be using an if statement here. We also have pulled a Summary field from the Agency table. We use this Summary field to pull a list of all of the Resources in that [Role] currently approved in the [Approval] field at the Agency we are trying to place Nicole. But Summary fields can be a tricky thing. First we have to turn it into a string of text. We do that by adding ToText in front of the Summary field. Now if there is no one at all in the [Role] at this Agency, I don't want to show anything, but if the Summary field isn't blank (<>"") I want to show all the pretty. (4) Let's make a pretty header for our list. I like steelblue. I also like my words to be bold, so I used Header 3 (h3) size (google html header sizing and web colors for more info). Then I put my header title, making sure to close my header sizing after that. (5) I want to start my list on a new line so here I add a return by typing &"\n". & is how you add text and text elements to your code, and "\n" means return. (6) Now to make the list of names below the header. We now need to break down our long list of names in our Summary field. To do that, first convert the Summary field to text with the ToText. Next enclose the whole thing and do a SearchAndReplace. When you convert a Summary field to text it divides each name with a space, a ;, and another space. We need to get rid of all of this so we do a SearchAndRepalce where we take out " ; ", and replace it with a space and a line break " <br>". I know you are asking, "Why not just leave a space and not add another space?". The reason is that the space and break will now only show up when replacing a ;, keeping you from having extra spaces at the end of your list. (7) ...and the last part. Remember I said at the beginning, that even if they chose this role, if there were no names in the Summary field I didn't want anything to show? Yeah, this just says that. Just make sure to put a comma after this if you have more conditionals. So let's see this for real... What it looks like all-together Case([Role], "Content Champion", If(ToText([Current Content Champion])<>"","<h3 style='color:steelblue;'>Current Content Champion Contacts:</h3>"&"\n"&SearchAndReplace(ToText([Current Content Champion])," ; "," <br>"),""), "Business Development", If(ToText([Current Business Development])<>"","<h3 style='color:steelblue;'>Current Business Development Contacts:</h3>"&"\n"&SearchAndReplace(ToText([Current Business Development])," ; "," <br>"),""), "eCommerce Senior Manager", If(ToText([Current eCommerce Senior Manager])<>"","<h3 style='color:steelblue;'>Current eCommerce Senior Manager Contacts:</h3>"&"\n"&SearchAndReplace(ToText([Current eCommerce Senior Manager])," ; "," <br>"),""), "eCommerce Manager", If(ToText([Current eCommerce Manager])<>"","<h3 style='color:steelblue;'>Current eCommerce Manager Contacts:</h3>"&"\n"&SearchAndReplace(ToText([Current eCommerce Manager])," ; "," <br>"),"")) As you can see, this is what makes the conditional lists. To make the Pending list, do the same thing, but pull another Summary field from the Agency table that just shows the Resources in the [Role] that are still Pending in the [Approval] field. I hope this helps a few of you, and if you have a better simple html way, please feel free to share. I love new ideas and solutions. :) ------------------------------ Meredith Moore aka Quick Base Girl ------------------------------ SOLUTION: Making your Conditional List pretty (with html) So, I have seen it on the forum many a time "How do I make a list look like a list, but [insert complication/conditional here]...". Well today I'm gonna give you all some code that may be helpful to start down the path of making stuff look gooder without having to use scripting or hire Dan. (All the love to Dan, as he has helped every one of us at some point.) Ok here we go. All HTML, all the time... The Problem You have a Contact (named Nicole Samkange) and you want to submit her for a new job as a "Content Champion" on a client account. You need to know if she is already on the account and who else is on the account ("...She works well with Bob, but not with Sally" or whatever the reason). You also need to know if someone has already submitted her for the job, as there is nothing HR likes more than 20 submissions for the same thing. The lists we want You also have many different roles you can request for her (or anyone) but you only want to show what is relevant. So let's look at the fields we want to work from... The conditionals we have... The code we make... So, you need to make yourself a nice Rich Text Formula field and a case statement. But, let's break this down. What are we looking at? What it looks like broken down Case([Role], //(1) "Content Champion", //(2) If(ToText([Current Content Champion])<>"", //(3) "<h3 style='color:steelblue;'>Current Content Champion Contacts</h3>" //(4) &"\n" //(5) &SearchAndReplace(ToText([Current Content Champion])," ; "," <br>") //(6) ,""), //(7) (1) Start with a case statement. This is what you will be breaking all your lists up by. In this case the job [Role]. (2) List all of your [Role] choices in "". You are literally looking for when the [Role] matches this text. (3) When your [Role] matches your text you must tell it what to show, but we want this to be conditional, so we will be using an if statement here. We also have pulled a Summary field from the Agency table. We use this Summary field to pull a list of all of the Resources in that [Role] currently approved in the [Approval] field at the Agency we are trying to place Nicole. But Summary fields can be a tricky thing. First we have to turn it into a string of text. We do that by adding ToText in front of the Summary field. Now if there is no one at all in the [Role] at this Agency, I don't want to show anything, but if the Summary field isn't blank (<>"") I want to show all the pretty. (4) Let's make a pretty header for our list. I like steelblue. I also like my words to be bold, so I used Header 3 (h3) size (google html header sizing and web colors for more info). Then I put my header title, making sure to close my header sizing after that. (5) I want to start my list on a new line so here I add a return by typing &"\n". & is how you add text and text elements to your code, and "\n" means return. (6) Now to make the list of names below the header. We now need to break down our long list of names in our Summary field. To do that, first convert the Summary field to text with the ToText. Next enclose the whole thing and do a SearchAndReplace. When you convert a Summary field to text it divides each name with a space, a ;, and another space. We need to get rid of all of this so we do a SearchAndRepalce where we take out " ; ", and replace it with a space and a line break " <br>". I know you are asking, "Why not just leave a space and not add another space?". The reason is that the space and break will now only show up when replacing a ;, keeping you from having extra spaces at the end of your list. (7) ...and the last part. Remember I said at the beginning, that even if they chose this role, if there were no names in the Summary field I didn't want anything to show? Yeah, this just says that. Just make sure to put a comma after this if you have more conditionals. So let's see this for real... What it looks like all-together Case([Role], "Content Champion", If(ToText([Current Content Champion])<>"","<h3 style='color:steelblue;'>Current Content Champion Contacts:</h3>"&"\n"&SearchAndReplace(ToText([Current Content Champion])," ; "," <br>"),""), "Business Development", If(ToText([Current Business Development])<>"","<h3 style='color:steelblue;'>Current Business Development Contacts:</h3>"&"\n"&SearchAndReplace(ToText([Current Business Development])," ; "," <br>"),""), "eCommerce Senior Manager", If(ToText([Current eCommerce Senior Manager])<>"","<h3 style='color:steelblue;'>Current eCommerce Senior Manager Contacts:</h3>"&"\n"&SearchAndReplace(ToText([Current eCommerce Senior Manager])," ; "," <br>"),""), "eCommerce Manager", If(ToText([Current eCommerce Manager])<>"","<h3 style='color:steelblue;'>Current eCommerce Manager Contacts:</h3>"&"\n"&SearchAndReplace(ToText([Current eCommerce Manager])," ; "," <br>"),"")) As you can see, this is what makes the conditional lists. To make the Pending list, do the same thing, but pull another Summary field from the Agency table that just shows the Resources in the [Role] that are still Pending in the [Approval] field. I hope this helps a few of you, and if you have a better simple html way, please feel free to share. I love new ideas and solutions. :) ------------------------------ Meredith Moore aka Quick Base Girl ------------------------------ SOLUTION: Rich Text Formula field not showing in Grid Edit Are you having an issue with having your embedded report not showing your beautiful icons and formula fields when you have them set on Grid Edit? Well I sure did, and I wanted to save you all from my hour-long rabbit hole of trying to fix it. The problem: I had two embedded child reports on one form both set to grid edit mode, but only one was showing all the pretty icons and rich text formulas. Milestones embedded table showing icons in Grid Edit Tasks embedded table NOT showing icons in Grid Edit vs. What it should be showing So, I checked every field, link, permission, sub-children, grandparents, DNA, horoscope, formula, and view that I could find. I lined everything up so that it was exactly the same permission-wise, and still no dice. But then I thought of one more thing... The #*%?$@^! Form / Report Permissions... That's right kids. IF your table has more than one form you need to look at the permissions of your reports in that table. Most often they will just grab the permissions from your roles, but that can mess with your Grid Edit. And remember, this ONLY happens if you have more than one Form on your table. So yeah, that is fun. Milestones (1 Form) Tasks (2 Forms) The Fix So here is the fix. Just scroll down to the "Override role settings by report" section (right below your list of Forms) and find your embedded Report. Change the Grid Edit (Full Site) to "<Standard Behavior>". Yeah that is #*@^%*! it! The Culprit The Fix I hope this has been helpful. If so, say hi to me at Empower, or just send a sugar-free energy drink over to my table. I will nod, and we will both know of the rabbit trail you didn't have to follow today. ------------------------------ Meredith Moore aka Quick Base Girl ------------------------------ SOLUTION: Rich Text Formula field not showing in Grid Edit Are you having an issue with having your embedded report not showing your beautiful icons and formula fields when you have them set on Grid Edit? Well I sure did, and I wanted to save you all from my hour-long rabbit hole of trying to fix it. The problem: I had two embedded child reports on one form both set to grid edit mode, but only one was showing all the pretty icons and rich text formulas. Milestones embedded table showing icons in Grid Edit Tasks embedded table NOT showing icons in Grid Edit vs. What it should be showing So, I checked every field, link, permission, sub-children, grandparents, DNA, horoscope, formula, and view that I could find. I lined everything up so that it was exactly the same permission-wise, and still no dice. But then I thought of one more thing... The #*%?$@^! Form / Report Permissions... That's right kids. IF your table has more than one form you need to look at the permissions of your reports in that table. Most often they will just grab the permissions from your roles, but that can mess with your Grid Edit. And remember, this ONLY happens if you have more than one Form on your table. So yeah, that is fun. Milestones (1 Form) Tasks (2 Forms) The Fix So here is the fix. Just scroll down to the "Override role settings by report" section (right below your list of Forms) and find your embedded Report. Change the Grid Edit (Full Site) to "<Standard Behavior>". Yeah that is #*@^%*! it! The Culprit The Fix I hope this has been helpful. If so, say hi to me at Empower, or just send a sugar-free energy drink over to my table. I will nod, and we will both know of the rabbit trail you didn't have to follow today. ------------------------------ Meredith Moore aka Quick Base Girl ------------------------------ Re: iframe refreshOption 1 function timedRefresh(timeoutPeriod) {function timedRefresh(timeoutPeriod) { setTimeout("location.reload(true);",timeoutPeriod);} window.onload = timedRefresh(5000); // this is set for 5 sec Option 2 (also good for timed redirect) <meta http-equiv="refresh" content="5;url=http://example.com/" /> content = (this is in seconds, put to 0 for imedate redirect) ; url= (put either redirect page, or same page for refresh, or whatever) ------------------------------ Meredith Moore ------------------------------ Re: Auto refresh after saving?try meta refresh on your custom page (or button?) <html> <head> <title>Best Title for Page Ever</title> <script type="text/javascript"> if(window.top.location != window.location) { window.top.location.href = window.location.href; } </script> <meta http-equiv="refresh" content="2; URL=javascript:window.open('different-or-same-page.html','_top');"> </head> <body> Such a great page. </body> </html> ------------------------------ Meredith Moore ------------------------------ Re: Create a button to print a html page?Well this looks like yo may be seeking an Exact Form, but I don't have access to your app to see the page so I am not sure.