ifv not working with API_AddRecord?

Question

Hey all, has anyone else encountered this? I'm using a rich text button to (among other things) add and display a new record in one fell swoop. However, I cannot get it to respect my &amp;ifv=10 settings, it's still pulling up the new record in a form with full QB branding and navigation.&nbsp;
var text NewTimeSheet = URLRoot() &amp; "db/" &amp; [_DBID_CREW_TIME_RECORDS] &amp; "?act=API_AddRecord"&amp; "&amp;apptoken=XXXXXX"&amp; "&amp;_fid_37=" &amp; [Record ID#]&amp; "&amp;ifv=10"&amp; "&amp;disprec=1";
#APIsandcustomcode #api_addrecord&nbsp;------------------------------Elena Larrabee------------------------------

quickbasejunkie · Answer

Without seeing the full formula, I think what you may be looking for is:

?a=nwr in place of where you have ?act=API_AddRecord

The API_AddRecord happens behind the scenes and requires a redirect to say what to display after the new record is created. However, since the record isn't created at the time the button is pressed there is no way to capture the new record's ID to display it in the the redirect. There are some ways of doing this, but they are quite complex.
Using nwr (or API_GenAddRecordForm) simply passes the values you want to a new record but the user is responsible for saving it. This means you will still need a custom save button on your form when using the ifv=10.

I teach both APIs and Rich Text buttons in the Quick Base Junkie Button Bundle if you want to learn more.
-Sharon------------------------------Quick Base JunkieSharon Fausthttps://quickbasejunkie.com------------------------------

elenalarrabee1 · Answer

Thanks Sharon! Unfortunately, I have to have the record fully created before the user lands on the record form for the next step in the process, because there is a button on the next step that has to pass along the RID to a record in another table. I was trying to avoid having to use Javascript to pull the RID on the second button in the series....

------------------------------
Elena Larrabee
------------------------------

chayceduncan · Answer

Sounds like you'll need to either 1) use some kind of code page injection to create the record and then redirect the user to the new RID or 2) consider using some kind of save and continue button if possible.&nbsp;

With the code page you would just create the record and get the RID from the response and redirect the user to the new record. If its available though - you could try and convert your button over to a GenAddRecordForm and instruct the user with a 'Save &amp; Continue' type process where it saves the record and keeps them on their new form with the next step in the workflow unlocked now that the RID has been committed. Either one should allow you to continue with the IFV in place since you would be in control of the redirect.&nbsp;
------------------------------Chayce Duncan------------------------------

markshnier__you · Answer

A low tech solution if the only answer is code pages and others see this post and don't have those technical skills, would possibly be to redirect the user to a report of records created by the current user within the last minute. There would probably only be one record there.

The user would launch off a button on that report to continue with the next step.&nbsp;&nbsp;------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

elenalarrabee1 · Answer

I think I may end up needing to go with a code page solution... I'm encountering a few other use cases this morning where it seems necessary to create a new record and pass that new RID onto another record with the click of one button. Do any of you know of a good example of someone doing this? I haven't thoroughly search the forums yet since I was hoping to avoid this eventuality.&nbsp;------------------------------Elena Larrabee------------------------------

Forum Discussion

ifv not working with API_AddRecord?