Recover Attachment Field with airSlate SignNow

Populate attachment field

as you recall in an earlier training video we learn how to create our tables create the fields therein and assign them a data type like the data type field here is auto number and the rest of these are text fields where I can type in text or numbers or a combination of both in any case I want to introduce you to another data type field and it's called the attachment field where just like it says it allows you to attach like documents zip files and most images to your records here and it will automatically compress the images and files if they aren't already so to go ahead and add this other field with the data type attachment let's well come up here right click go to the design view and let's do mint hit the tab key the data type click on the drop down arrow and it's right there attachment and then down below you got the option to add a caption so what you see is the field name will be for you in the design view they won't see that up front if you type something else here for the caption so we can do something like clip like paperclip you want to attach something clip it to this record in any case that's what I'm gonna do and then let's come up here click on the View button and be sure to save your table and hey let me scroll over there it is clip so that's the caption that we see here but back in the design view the name of the field is attachment and you can see we got 0 attachments or clips to the field and to add one or two or many just go ahead and you can either right click on it and manage attachments or you can click on add or close out you can double click opens up the same window so we can click on add and it's like okay where are these well there's the books image double click and let's add another let's add this document here delete certificates path double click and when we're done click OK and hey there you go we have a total of 2 now you can see over here and that it's still in write mode so we haven't saved the record yet after we attached it so we want to save it let's hold down the shift key and hit enter and there we go and then to go ahead and access those attachments we can just double click on it to open it up and you can actually with it selected click on open or just double click on it and it'll open up that image in the program that is associated with this extension dot PNG and so it's the Windows Photo Viewer and if you want to learn more about extensions you can watch my Windows training video on extensions close out and this is a document double click and there we go and so once you open it up you can of course well I put the save as on my quick access toolbar click on save as now what we got to enable saving and there we go I can do it to the desktop and then save it right there so it's on my desktop now out of the attachment tool is still there but it's as a copy and click cancel them in my system to the taskbar and there it is you can do it that way or let's restore this by clicking on the button you can double click to open it up and just say hey I want to take this and save as and that way you don't have to open it up to be able to get inside that file and that program that it opens it up in to save it to your desktop you can go to the desktop and click Save but since I already have it there it says do you want to replace it ok so you can do it that way in fact you can take all the attachments and say ok save all of them and dump them all on the desktop or in a folder on your desktop or wherever you'd like and then of course to go ahead and get rid of them you can't select it and remove it but I don't want to do that so I want to add it and it's in the exercises folder on the desktop and the delete certificates path and click okey-dokey and we're in pencil mode so shift enter to save it and the reason why I want to keep it there is because I want to show you that when you create a form based upon a table that has this attachment field I want to show you what it looks like so let's go ahead and close out of here we got the table selected and come up here click on the create tab let's go to the forms group and let's do form and there we go it's right there but we're not in the actual form view so let's right-click on it or in layout let's go to form and so there it is and to be able to access it you can see when I hover over it says double click to view or add attachments you can double click you can view them or add them click cancel you can right click on it and when you do that you can not only manage the attachments but let me click cancel as you saw there when you right-click on it you can go forward and it takes it to the next clip that's in there and right click and go backwards and if you actually click on it you see that little mini bar up at the top you can go forward and backwards as well and also click on that little clip to manage the attachments so it's there you can still manage it within a forum thanks for watching hey as a quick reminder if you liked my video please give it a thumbs up you can also click on me and subscribe to my channel to get notified for the latest videos and for great specials and my products please see the description below this video