Jump to content
  • 0

Create New Record If Value Is Not Found



I am working on a Clients database and a Work Order database. They go hand in hand; when a customer calls, we search for them in our clients database and click a button that pulls up a Work Order submission form. 

Right now I have a button in the Client Report that sends the record key from the Client record to the Work Order submission form.

<button class="workorder" onclick="OpenPopupCenter('https://xxxxxx.caspio.com/dp/e75050009fd4376ea---------?CG_Client_ID=[@field:CG_Client_ID]', '', 800, 900);">Start Work Order</button>

At this point, the Customer Name, Address, Number, etc. is automatically populated from the record of which the popup button was clicked. Obviously, I have a submission form to enter new Clients into the Client Database.


I have a Blank Work Order popup that just pulls up the Work Order submission form completely blank. Is there a way to have the information entered into the Blank Work Order submission form create a new record in the Client Database if that info isn't already there? In other words, if a Blank Work Order is submitted, I would like the values to loop through the Client Database and create a new client record if there isn't a match on first + last name, or something along those lines.


I'm not sure of a better title for this - sorry. Picture of Work Order form below. The first 5 fields are what would create the new Client record.


Link to comment
Share on other sites

1 answer to this question

Recommended Posts

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...