api add a record if one does not exist

Question

I am able to write the formula to add a record, but I get an error page if the record already exists. How can I add the ability to only add if the record does not exist?

If([Auction]="Dealers", URLRoot() & "db/bn52z25bj" & "?a=API_AddRecord&apptoken=xxxxxxxxxx&_fid_39=" & [AMS#]& "&_fid_6=" & [Dealership Name] & "&_fid_17=" & [Tel:])

------------------------------
Kelly
------------------------------

markshnier__you · Answer

I don't know enough from you post to understand the your app and it's relationships, so here are a couple of thoughts.

If you are trying to create a parent record by launching off the Child, my suggestion is to create a field on the Parent table called [AMS Exists?] (if that is the Parent table) as a formula checkbox field with a formula of
true. The look that up down to the child table and build that into your formula so that the button goes blank if there is already a parent AMS# loaded.

If([Auction]="Dealers" and not [AMS# Exists?], URLRoot() & "db/bn52z25bj" & "?a=API_AddRecord&apptoken=xxxxxxxxxx&_fid_39=" & [AMS#]& "&_fid_6=" & [Dealership Name] & "&_fid_17=" & [Tel:])

But then the other problem is that when you button runs it will spew back on the screen the XML success message which is not user friendly.

If you tell me where you want the screen to refresh to after the button is clicked I can help you with that. Do you just want to refresh the record or are you launching off a report?

.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

kellybianchi · Answer

This is actually to create a record in another table. Perhaps it would be easier to have a combined edit or add option, because I would like the record to be updated. Would that solve the problem? Can you provide the code for that?

------Original Message------

I don't know enough from you post to understand the your app and it's relationships, so here are a couple of thoughts.

If you are trying to create a parent record by launching off the Child, my suggestion is to create a field on the Parent table called [AMS Exists?] (if that is the Parent table) as a formula checkbox field with a formula of
true. The look that up down to the child table and build that into your formula so that the button goes blank if there is already a parent AMS# loaded.

If([Auction]="Dealers" and not [AMS# Exists?], URLRoot() & "db/bn52z25bj" & "?a=API_AddRecord&apptoken=xxxxxxxxxx&_fid_39=" & [AMS#]& "&_fid_6=" & [Dealership Name] & "&_fid_17=" & [Tel:])

But then the other problem is that when you button runs it will spew back on the screen the XML success message which is not user friendly.

If you tell me where you want the screen to refresh to after the button is clicked I can help you with that. Do you just want to refresh the record or are you launching off a report?

.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

markshnier__you · Answer

Yes, I understand that this is to create a record in another table. Is there a relationship between the tables? Can this record "know" if the other record to be created or edited exists? Can you tell me the Key field of the other table?

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

kellybianchi · Answer

The Account number is the key field. There isn't a relationship between the tables. This feature needs to create records in various applications, so I didn't relate the tables.&nbsp;   ------Original Message------Yes, I understand that this is to create a record in another table.&nbsp; Is there a relationship between the tables?&nbsp; Can this record "know" if the other record to be created or edited exists?&nbsp; Can you tell me the Key field of the other table?------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

markshnier__you · Answer

An alternative is to create a saved table to table copy which will merge on Account#.&nbsp; The advantage of that method is that it will either add or update the Account#&nbsp;Table.There are some steps to set this up, and I might have to work with you one on one to get this going, as the button would need to first set a Focus on the record you are on, so that the saved table to table import would just import that one record.The button would need to1. Edit a Focus Record which would have Record ID# = 1 with Record ID# of the detail record.&nbsp; (that will be looked up back down to the details table)&nbsp;2. Run the saved table to table import&nbsp; API_RunImport&amp;ID=10 ...3. Refresh the record you are on.Contact me via the email my signature line if you need help setting that up.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Forum Discussion

api add a record if one does not exist

Related Content

Pipeline: Create a parent record if one does not exist

Custom Record Titles

Add Existing Child Records from New Parent Record

Pipeline to Search 130k Records in Another App and Create if the Record Does Not Yet Exist

Using Grid Edit to Edit Multiple Records at Once