ContributionsMost RecentMost LikesSolutionsRe: Send Exact Form in Notification emailQuestion about this- I have the .html page working perfect as a notification, but what about displaying a report? I have materials that are connected to a Service Report. They can be displayed on an exact form but when I copy the rich text page html into the notification I can only get the materials to show up as a link... ------------------------------ Amanda Torrisi ------------------------------ Re: Simple Redirect for EOTII do not know how to remove the quickbase interface but leave the save button.... I had to create a submit button, and when I remove the redirect part from the survey url, the submit button no longer works. I could try to figure out how to add a thank you message if they select save and close (if I could figure out how to get save and close back on the page, while still hiding the rest of QB interface)... I feel like this is simple and I am just complicating it! ------------------------------ Amanda Torrisi ------------------------------ Re: Simple Redirect for EOTIOk I am just getting back to this after a week and I am losing my mind... the link works if I copy and paste into the browser but I am trying to make a button I can add to the form, and then the notification email. Why does this not work as a url field? (I've also tried rich text/formula rick text. etc) URLRoot()"https://lightshipgroup.quickbase.com/db/bqsxvcdiv?a=nwr&preview=1&dfid=10&ifv=1" "&rdr=&NextURL="&URLEncode("https://lightshipgroup.quickbase.com/db/bj9qhjr75?a=dbpage&pageID=41" Ive also tried URLRoot() "https://lightshipgroup.quickbase.com/db/bqsxvcdiv?a=nwr&preview=1&dfid=10&ifv=1" "&rdr=&NextURL="&URLEncode("https://lightshipgroup.quickbase.com/db/bj9qhjr75?a=dbpage&pageID=41"); ------------------------------ Amanda Torrisi ------------------------------ Re: Simple Redirect for EOTIPerfect, that worked! Thanks so much! ------------------------------ Amanda Torrisi ------------------------------ Simple Redirect for EOTI I have a customer survey form for EOTI to fill out. Ideally they would receive the link for the survey in an automatically generated notification from Quickbase. They would then be creating a new record once the survey is filled out. My link to the survey is this: (https://lightshipgroup.quickbase.com/db/bqsxvcdiv?a=nwr&preview=1&dfid=10&ifv=1) Once the use clicks "submit" I would like them go get redirected to a .html page that I have set as the EOTI default page. In other apps, I have more complicated rich texts fields that accomplish this, as well as creating other records at the same time...but I can not get the more simple formula to just save and redirect to work! This is the formula I have now and it just says the page unrecognized: var text bgcolor = "#34A853"; var text txtcolor = "white"; var text style = "style=\"text-decoration: none; background:" & $bgcolor & "; border-radius: 5px; padding: 8px 20px; color: " & $txtcolor & "; display: inline-block; font: normal 700 24px/1 \"Calibri\", sans-serif; text-align: center; text-shadow: none;"; var text url = "&rdr=&NextURL="&URLEncode("https://lightshipgroup.quickbase.com/db/bj9qhjr75?a=dbpage&pageID=41"); "<a " & $style & " href=\"" & $url & "\">Submit</a>" I feel like it is something simple that I am just missing!! Any help would be greatly appreciated. Thank you! ------------------------------ Amanda Torrisi ------------------------------ Automatically Import Multiple Records into a Parent TableI am trying to create a scenario in which a user chooses an option from a drop down box in order to create several new records. For example, if they choose "weld consumables" from a drop down, all the records from another table that are also marked as a "weld consumables" would populate on the parent record. It is possible that the parent records would need several different types of consumables so this would need to be able to happen more than once on a single parent. I have tried to do this with both actions and automations but am getting nowhere. Any idea? Thank you ------------------------------ Amanda Torrisi ------------------------------ RURL across appsHello, I feel like this is very simple and I think I may have even accomplished it before but I am drawing a blank. I am trying to let users add line items from one app to a parent record on anther app. I created the relationship and made sure to add the "Add Line Item" button and the report link. But when they add a line item(cross app child table) they are not returned back to the parent table once they press save, the record just saves and they are left on that record in the child table. Is there a way to save the child record and return back to the parent record? ------------------------------ Amanda Torrisi ------------------------------ Re: URL Button Return URLHi... what field are fid_7 and fid=10... I am trying to accomplish this as well but do not know what fields need to go in the formula... Assuming they are record ID and such but cannot get it to work... Thank you. ------------------------------ Amanda Torrisi ------------------------------ Re: How to go to grand parent recordThat worked perfectly. Thanks! ------------------------------ Amanda Torrisi ------------------------------ Re: How to go to grand parent recordI am trying to make this work and must be doing something wrong. The url is displaying as: http://<a href=https://lightshipgroup.quickbase.com/db/bkusrx5kc?a=dr&rid=252>Andrews Robert</a> Tables involved: Customers --> Locations --> Generator This is my formula: var text Words = [Customer Name]; var text URL = URLRoot() & "db/" & [_DBID_COMPLETE_DATABASE] & "?a=dr&rid=" & [Location - Customer - Record ID#]; "<a href=" & $URL & ">" & $Words & "</a>" My fields used [Customer Name]- [field which has an identifier of he Grandparent record which was double hopped down from the Grandparent to the Parent to he child you are on] _DBID_COMPLETE_DATABASE - Customers Table (grandparent) Location - Customer - Record ID#- Record ID hopped down?? Is there anything I am obviously doing wrong or missing here? Maybe I am not understanding the fields I am supposed to substitute? Thank you, Amanda ------------------------------ Amanda Torrisi ------------------------------