ContributionsMost RecentMost LikesSolutionsRe: 'Help Desk' type Customer Satisfaction SurveyThank you so much!! I knew there was an easy/obvious answer and I was overthinking it. ------------------------------ Jen Hamilton ------------------------------ 'Help Desk' type Customer Satisfaction SurveyWe have users fill out a request form. (Requestors) Then a team of users do what is requested on the form. (Request Team) When form is marked 'complete' a notification email goes out to the Requestors. The Request Team has asked to add a survey to that notification email. I could just make a Survey table and link to the 'new record' button... but they want to know which Request Form the survey is for. I can do a relationship... but how do I make the button open a new Survey form that has the correct Request Form pre-selected? ------------------------------ Jen Hamilton ------------------------------ Re: Capacity/bandwidth planning? I have something like this in my main app, a summary report predominantly displayed on the homepage so managers and people on the same team have basic visibility to each other's workload. First I made a table called "User Details" to store our team member data. Which team they are on, work location, role, capacities, and of course a "User" field where I select the appropriate Quickbase user. (Notes field is also handy, I log why obscure users have access to our app.) When I make a user drop down in another table (like the Projects table), I make a relationship to the User Details table and use it to select the project member instead of just adding a basic "User" field type. This way I can pull over other data about the project member and can also get fancy, like filtering the list so that the field only shows certain types of users. (I also went and added this to existing tables, used import/export to copy over the username data from the old basic User field.) Then back at the User Details table I add a summary field that counts their number of active items in each relationship (such as projects.) You could setup this basic relationship counting projects, then add project levels with a points system to your Projects table and bring it over to the User Details table as an additional summary field. Finally, make a formula field to compare it to capacity and a summary report to display this data. ------------------------------ Jen Hamilton ------------------------------ Use text field to define formula We have a table with a list of unique goals and I would like the users to define how to calculate their goal themselves. (This table has relationships, a bunch of summary fields they can choose from.) Field name: How to calculate Field type: Text Field Name: Metric Result Field type: Formula - Number Formula: [How to calculate] Record #1 How to calculate: ([Fail]+[Pass])/[Pass] Record #2 How to calculate: ([Complete]+[Incomplete])/[Incomplete] Currently the Metric Result field does not work, it gives a save error saying it is expecting a number. If I use ToNumber([How to calculate]) the result is 0. I could setup a notification and go write in a new part of a nested If or Case formula every time a goal is added, but I'd rather make it self-sustaining. Any other ideas? ------------------------------ Jen Hamilton ------------------------------ Re: Subtract business hours from timestampI thought that might be the answer. I often feel like I'm making things more complex than they have to be, "WeekdayAdd" works so well on dates that I hoped there was an easier answer. ------------------------------ Jen Hamilton ------------------------------ Subtract business hours from timestampI have a time stamp field called "Deadline" and I want to subtract business hours from it (weekday hours.) How? ToWeekdayP([Deadline]-Hours(#)) This doesn't work, it just knocks the result to a Friday if it falls on Sat/Sun. Subtracting 36 business hours from an 8am Monday deadline should return Thursday at 8pm, not Friday at 8pm. ------------------------------ Thanks, Jen Hamilton ------------------------------Re: URL link to view a specific form, but the form changes when the edit button is clickedThis sounds like it would work, what is the IOL toolkit?Re: URL link to view a specific form, but the form changes when the edit button is clickedEach form has 100-200 fields and almost 100 dynamic rules. Combining them would be significant work and require redoing testing/debugging. :(URL link to view a specific form, but the form changes when the edit button is clickedI have a table with two forms. "Course form" (ID#10, default) and "Offering form" (ID#2). I have a Formula - Url field to link users to the correct form from other tables and in reports: If(Contains([Request type], "Offering"),URLRoot() & "db/" & Dbid() &"?a=dr&rid=" & ToText([Record ID#]) & "&dfid=2"& "&z=" & Rurl(), URLRoot() & "db/" & Dbid() &"?a=dr&rid=" & ToText([Record ID#]) & "&dfid=10"& "&z=" & Rurl()) It works, until they click the "edit" button at the top right of the record. In edit mode it will ALWAYS show the "Course form" - the default form. I can replace a=dr with a=er, but I don't always want to always send them to "edit" the form. This is also a problem when I send them to create a new record on a certain form - when they save the record it always shows the default form. How can I fix this?Re: How can I add a data connection to an existing table?My workaround was to create a brand new connected table, then use "import" on my original table - "Import into a table from another table" to pull over data from the connected table. You can save the import settings to match up the fields, so I go mash a button once a day to copy over what was brought into the connected table. It is faster and more consistent than uploading a file. (I have two backups who have access to mash the import button as well.) It's not ideal, but I figure we'd have to spend a few years doing that every weekday before it would be more time than recreating my main table as a connected table. It has 405 fields, 25 relationships to other tables, and a form with lots of dynamic rules.