RodericWest
Qrew Trainee
Joined 6 years ago
User Profile
User Widgets
Contributions
Multiple notifications after grid edit
On a single record, when we change the status to Approved, it will send the contact person, Email field, a notification. I have created a grid edit table, so we can update multiple records at once. However, I need a notification sent to each email on each record. How do I get Quickbase to do this? Image of single email: image when I use multiple record version: when I tested, each individual record got an email, but it was the multiple record version. It just displayed the field ID, and not the individual information needed per email. ------------------------------ Roderic West ------------------------------Re: Save and redirect to a thank you page
Thank you! That works! The notification sent successfully with the link. I like the way it displays. However, when I clicked the Submit button, I was given and Error, page not found. The record was saved and updated. ------------------------------ RWest8 RWest8 ------------------------------Re: Save and redirect to a thank you page
Thank you. The Submit button works great! Where do I enter the code prior? URLRoot() & "db/" & [_DBID_PRE_SURVEY] & "?a=er&rid=" & [Record ID#] & "&ifv=1&nexturl=" & URLEncode(URLRoot() & "db/" & AppID() & "?a=showpage&pageid=7&ifv=1") I was entering it into a Formula URL, that is where I got an error, assuming the wrong place. ------------------------------ RWest8 RWest8 ------------------------------Re: Save and redirect to a thank you page
I tried the code you provided, however, I got a syntax error message. URLRoot() & "db/" & [_DBID_PRE_SURVEY] & "?a=er&rid=" & [Record ID#] &ifv=1&nexturl=" & URLEncode(URLRoot() & "db/" & AppID() & "?a=showpage&pageid=7&ifv=1" What would I do to simply have it save the record? And then to explore, what would be the native option and how that would work. Sorry, I am not very good at coding, in the process of learning. ------------------------------ RWest8 RWest8 ------------------------------Re: Save and redirect to a thank you page
We don't have them add the record. The record is created by us, and based on certain selections a notification of the record is sent to the outside person. They fill out the information they need to and then save. I wanted to add a Submit button at the end, so they click that, save the record, and redirects them to a Thank you home page. It was requested to have a Submit button at the bottom, rather than use the Save button at the top. ------------------------------ RWest8 RWest8 ------------------------------Save and redirect to a thank you page
I have a form that I need an external user to complete. I want to add a Submit button, that will Save and Close the record and direct them to a Thank you page. I have a Home Page that has a Thank you text and image, I assume I can make an HTML page with information as well. I am not sure where to start, I have a Formula URL field, and not sure what to put in the formula field. I checked out a lot of the discussions, and just confused about where to start. Looking for some assistance and guidance. ------------------------------ RWest8 RWest8 ------------------------------Numeric Formula font color change
I have a Numeric Formula. It is a simple subtraction field. [Total Points 2015-16]-[Total Points 2016-2017] I would like to have it turn green when positive, and red when negative. I understand you can not do any conditional formatting in a Numeric Formula field. I understand you need to use a TextFormal Field. I have tried different things i have seen in other post, but i simply can not get it to work at all. What formula can i use to make this happen?
