ChayceDuncan2
Qrew Cadet
Joined 7 years ago
User Profile
User Widgets
Contributions
Re: File attachment from request form/table to elsewhere in the app via automation/JS
You can I believe - the tricky part is the download. You can use API_EditRecord or API_uploadFile to do the upload - but the download, I believe you have to do a GET to the download URL and play with the contents. Try out doing a GET against the download URL format: https://realm/quickbase.com/up/dbid/a/rRID/eFID/v0 - that theoretically would give you the raw Base64 contents to just copy over to your new record. I've only work with the uploads - so I'm not 100% confident with the answer. Chayce Duncan | Director of Strategic Solutions (720) 739-1406 | [email protected] Quandary Knowledge BaseRe: Create a ""Contact Us"" form on website, create Record in QBase, Auto-email response
To condense this - Ryan is saying that when your customer is submitting a new record from the website - that you just set up a basic Quick Base notification to send them back a response. This would be an 'open' email notification that would go to someone who is not a user. The catch to this is that you will need to actually capture/log the persons email from the site. So when they're submitting via your website - one of your fields should be an email, and you log that to Quick Base. When the record is successfully added to your system - you fire off a notification to the email listed in that field, and you've got your 'thank you' Chayce Duncan | Director of Strategic Solutions (720) 739-1406 | [email protected] Quandary Knowledge BaseRe: Sweetalert
Can you be more specific about what you mean by adding the script pages? Where / how are you using it currently? Are you using dbpages or are these built into a button in your app using $.getScript or something equivalent? Just a thought - If you're currently using the original library make sure you swap out the script tags and actually remove the original ones so they don't conflict with one another. Chayce Duncan | Director of Strategic Solutions (720) 739-1406 | [email protected] Quandary Knowledge BaseRe: Create a ""Contact Us"" form on website, create Record in QBase, Auto-email response
The standard for a role / user like this is to set up a new role with basic permissions - and set their default access to view/modify to none for all tables - hide all the UI elements and toggle everything off in your app with one exception that the role should be able to 'add' in the target table you want records added to. That should do it Chayce Duncan | Director of Strategic Solutions (720) 739-1406 | [email protected] Quandary Knowledge BaseRe: Create a ""Contact Us"" form on website, create Record in QBase, Auto-email response
Technically yes - but I'm not clear if that counts against the license When you add a user start typing 'Everyone' and if your realm is already set up for it it will populate everyone on the internet as an option Chayce Duncan | Director of Strategic Solutions (720) 739-1406 | [email protected] Quandary Knowledge BaseRe: Create a ""Contact Us"" form on website, create Record in QBase, Auto-email response
Your best route to go is to open your application to the internet with the Everyone on the internet use with an extremely limited role that can only add records in your source table. They can't view/modify anything - just add to that table. That way you can get around the authentication issue. You don't want to go to api_authenticate or deal with tokens since this is client side and you don't want to expose that information publicly on your site. Everyone on the internet would be an easy solution though. Chayce Duncan | Director of Strategic Solutions (720) 739-1406 | [email protected] Quandary Knowledge BaseRe: Coloring a field
You don't need to repeat the reference to your field in the Case(). Just at the very beginning and then check for expected responses Case([Overall compliance status], "Fully compliant","<div style='background-color:#9EFFAF;'"&[Overall compliance status]&"</div>", "Not fully compliant","<div style='background-color:yellow;'"&[Overall compliance status]&"</div>", "") Chayce Duncan | Director of Strategic Solutions (720) 739-1406 | [email protected] Quandary Knowledge BaseRe: formula field to do an ajax request
A formula can do it but it has to be on a button click. Embedding your own Javascript requires that you initiate the action - so a formula can do it as a button. Else you'll have to use Image Onload. You can do a formula url and use the syntax: javascript: { } else you can use a formula rich text and do an a tag with on onclick function Chayce Duncan | Director of Strategic Solutions (720) 739-1406 | [email protected] Quandary Knowledge BaseRe: JQuery referencing by FID??
I can't say for absolute certainty if it will work or not - but I know from a brief glance that IDs aren't how Quick Base references fields now. They changed the formatting of their field IDs on the page to be 'tdl_#' (like 'tdl_6' or 'tdl_7') Try swapping out that syntax to see if it works Chayce Duncan | Director of Strategic Solutions (720) 739-1406 | [email protected] Quandary Knowledge Base
