Commission Calculated Field with airSlate SignNow

Assign signer, Add calculated fields and eSign

[Music] in this session I'm going to demonstrate how to use the query design and also define calculated fields or have calculated fields as part of the query design let's assume that we have a bunch of customers they have not paid their invoices and we want to calculate a late fee so part of our query we want to display what the late fee calculation would be so here's how we do that we go here under the query design and then first thing we need to pick the tables if we want to utilize so let's say we want customers then we want contracts and then let's say we wanted the invoices so I'm just going to list those three tables that we are utilizing at this point but in reality I'm going to use only customers and invoices in this case so we want the first name I'm double clicking on them last name and then let's say you either state address city state and zip and then we want also the invoice number the date the item amount and then we want what it was paid or not I'm going to resize this I'm just dragging it up so we can see this a little bit easier and now if I go and run this query now this is going to display the data that we picked however it's not filtering yet or it's not giving us only the unpaid invoices to fix that we go on the design view again and then we go under invoices we say not paid so whether it was paid under the criteria notice the criteria row here we say no now the next thing that we want to do and by the way if we run this again notice it'll be display now if we go back we want to create here a new field and we'll say late payment and then part of that field we wanted to calculate what the late payments would be so the way you do that is by clicking here on this option that is called builder so we want to build a new calculated field we click on builder so first I selected in your field where we want to do this and secondly we want to utilize the Builder function before we can utilize the Builder function it's best to save this query first so we could say just click on the X here at the top right and we'll say yes then we'll call this late fees and then click OK now we go back here to the late fees and we run this query then we go under the design view by the way you could right-click on it and choose design view as well to get to it and then we scroll all the way to the MT new field here and then we want to click on builder on builder by the way it wants to save...