Forum Discussion
Sorry, but I'm not understanding the question.
I gather you're using an API to actually create a record so you were using the API of API_AddRecord
When you view that record the form rules would all activate in terms of show/hide, if you're expecting any formulas to edit the record then they will not fire until the form is put into edit mode. If you wanted any other fields to be populated to replicate what the form rules do then that would have to be built into the API_AddRecord. You can populate an unlimited # of fields with the one API. But, like I said I really am not understanding your question, this response may not help you!
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
It's an URL field and yes, it's clickable. However, is possible to where the URL can be navigated to automatically after the API call is completed? I have tried to use rdr and can't get it to work. FYI, the URL is to YouTube, if that makes a difference.
------------------------------
James Carr
------------------------------
- MarkShnier__You3 years ago
Qrew Legend
OK, now I get it. It sounds like you are trying to track who watched the video so you want to click and add a log record and then redirect the user to watch the video.
The generic format to redirect after a URL is this.
The syntax for the AddRecord formula variable would be this if you are launching off the parent record. It's best not to hard code the app's URL as if you transfer the app to another Realm or get out of the builder program, then the URL will fail. Also its a whole lot easier to read and debug if you write the formula vertically.
URLRoot() & "db/" & dbid() & "act=API_AddRecord"
& "&_fid_175=yes"
& "&_fid_45=" & URLEncode(audreywright1@gmail.com")
& "&_fid_174=yes"
& "&_fid_10=389"
& "&_fid_161=yes"
& "&apptoken=c7e8rngbcix5bscgwyxitde55c57";
var text YouTubeLink = URLEncode("https://www.youtube.com/watch?v=Y1YTup_gPxQ");
$AddRecord
& "&rdr=" & URLEncode($YouTubeLink)
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------- MarkShnier__You3 years ago
Qrew Legend
One other thing is that it is possible that your builder account is set not to allow external redirects. I would first test by redirecting somewhere internal to QuickBase and get that working and then change the redirect to something external. The external redirect then fails then you will need to put a ticket in to Support to ask for your builder account to permit external redirects. I don't know if they will approve that or not as I don't know what the limitations of the builder plan are.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------