Corroborate Dropdown Field with airSlate SignNow

Corroborate dropdown field

[Music] hi this is David from Metro management consulting and today I propose you to further improve our document that we created previously with drop-down lists listing the different projects that we have and having the unit cost based on that project as well so retrieving the unit cost corresponding to that project we started creating a simple invoice with the form fields and auto calculated result last time we also included a text based on the result of the total amount displaying the total amount in words now we are going to include a list so each of those fields now display the list of the products that we have and have a name like choice 1 for this one choice 2 3 4 5 6 so that we can trigger the unit cost corresponding of the result of each of those lists choice 1 least tries to and so on so if we choose one product like product B and we validate we have the price retrieved corresponding to the product B and if we enter the amount then it calculates the result so I have also updated that field so that it doesn't display the amount if one of those two fields is empty if we have the quantity like 10 then it doesn't display unnecessary result and if we have a project selected in this one and it displays the unit cost based on that product but the quantity is empty it doesn't display either unnecessary result so it's some improvement that I have made on that document now let's choose also a project age we have the quantity the price automatically is displays based on the result of that field now we have project D we can also add a certain quantity 34 and we have a water-tight calculated and the text displays the total amount in words now with this improvement we improve the way the project ritum so we avoid spelling mistakes and calculation mistakes let's imagine that by mistake we write 13,000 instead of 130,000 that would be a huge drop in the result of our invoice so with that we make sure that once the project is selected the correct unit costs corresponding to this project is going to be is going to be displayed in that field let's have a look what we have behind and how we can do that we need to remove the protection first of all so we can go into either developer tab or also the review tab and choose from protect restrict editing once we have removed the protection we can see what we have behind us the things so in in in the column particulars we have a drop-down list that we can have from the Developer tab controls group and legacy form that's the one we chose okay drop-down list we double click on it and we reveal the options that are available behind I haven't other entire list so we can just type the item inside here click Add and for each item we do that I have also included an item field with space so that we can have something like an empty field that that we have the origin of the of the document then I have named in each of those fields with choice one choice two three four five six and make sure to check calculate and exit for each so we can have a look at this one it as the name choice six or the list of the projects and calculate an exit as well so that we can use the result of this field in the unit cost and display that let's reveal the field codes that we have with alt f9 then we see what other codes that are behind so I used an if statement so that if the field reserved choice one correspond to the space item then we don't need to display anything so I I left empty double quotes so that we don't display anything and otherwise where it retrieves the reference bookmark based on the result of the reference bookmark choice one so there are two reference bookmark embedded in each other activating that here we have an if statement saying that if either with the oral function if either b2 is equal to 0 or c2 is equal to 0 then it is it is true then we don't display anything so again empty quotes we don't need to have unnecessary result in that if if we don't have the quantity or if you just have the quantity but not cost corresponding to one product and what I have done is also listing the different products that we have and the price associated to that product so we need to use a set field to set the bookmark product a to 30,000 and so on until product J so we need to use the underscore to avoid spaces a bookmark can't have a space so we need to write something with other space so that's what we did to improve the document I use the drop down form field and base the result of that drop down form field to retrieve the unit cost corresponding alt f9 to go back to the form value and we can use the document when it is protected next time what I propose you is to use the use the data that we have collected in those forms once we have created those forms and sent this form to the client we have a lot of information that are very useful we have the name of the clients that we have invoiced the list of the product in Boise the quantity and the date and the number of the invoice and so on and we can use this information for that we see that we need to go into file menu options and with advanced we need to make sure that one checkbox is checked this one's a form data as the limited text field so that when we save the document it saves as a delimited text file and then we can retrieve those information in Excel through power query do little bit some transformation and start creating a database of the data that we can use for statistic purposes and so on so see you next time thanks for watching