Collaborate on Cab Receipt Generator for Research and Development with Ease Using airSlate SignNow

Cab receipt generator for Research and Development

hello everyone this is kyle from we  take care of you and today i'm gonna   do the final video for the invoice generator  series and for today's video we're going to do the   power app and we've already done the sharepoint  list for the data source we've already done the   power automate automation so today we'll  build the actual app we'll do a run through   and hopefully it all works first time  would be nice and so let's get straight   into it so as you can see up to powerapps  i'm going to create a new blank canvas app   so i'm going to do a blank canvas up here  and i'm going to call this english generator okay so what we want to do first is  we want to click insert and then we   want to add a form and we want to add an edit form i'm going to move that to the center and then  for our data source we want to connect to   those sharepoint lists that we created in the  first video so if you click on the data source   come down click connectors click on sharepoint   click your connection and then we want to find  that site that you created those listings so i've   got my form site and then i'm going to connect  to invoice system demo and then click connect okay perfect so now i'm just going to resize  this i'm just going to format this around a bit   so first things first i'm going to set the columns  to 2. um i found this very important with a lot of   power app developments is that you should always  set your columns first i've seen a lot of times in   the past and i mean i made this mistake myself  many a time seeing other developers do it with   this the columns could be on six or twelve then  they start trying to have you know visually just   two columns and then once the database refreshes  all the all the cards snap and refresh all out of   order and it can be a big pain if you've got large  um large forms show and hide in a lot of fields so   facing space yep set that column to two now what  i am going to do here is we are going to add our   title so i'm just going to go back to edit fields  here and i'm going to click this little ellipses   up here and i'm going to add a custom card so  there is our custom card now what i'm going to   do is i'm just going to come to the y property  of this custom card i'm going to set that to   zero and then you'll see these will jig up so i'm  just going to reformat these and set these to one bill two to one as well just for now and i'm going to re-select this width to width fit  so there you can see there's our heading there so   now what i'm going to do is i'm just  going to set the height of this to 50. just gonna zoom in a little bit okay and now what i'm gonna do is i'm  going to add a label so insert label i'm just going to put that  text as invoice generator i'm going to set the font of that to lotto and then i'm going to set the 20. and here's our font so next i'm  going to insert a media image and i am going to upload my logo so i suppose  just yeah for this if you want to grab your logo   put mine there and then i'm going to bring that  width out to be your 50 percent of the form [ __ ] i just want to set the width of this form to be 800 all right it's already 800 okay perfect so there  we've got our first sort of bring the label down   and okay so there we got our header so next what  we want to do is we want to have our date and then   we want to have an invoice number so i'm going  to set the date i'm going to set this position   to zero and i'm going to set the position of  this one to 400 and i'll just swap them over   as you can see and then i'm just going  to set this font to be lost over 13. and then what we are going to do next is if we set  the default date so if we just unlock this card   set the default date on this date to be  today open close parentheses and there   you'll see it'll set today's date now what you  can actually do as well is if we come to format   change it from short date and i'm just going  to do it as dd mmm yyyy and that's just   going to change the format of that date there  finally we're going to go to the display mode of this date display mode dot tables because that's always  just going to capture today's date and that's   that so next we want to put the title here so i'm  going to move this bill to down in fact it might   be better if i just do all them at the same  time so i'm going to put the bill to us too titles want to put the sale  amount so i'm going to move down i'm just going to reorder all these at the  correct so that's saying one can go to four   and we can set the full width for that and gst can go to set the five width for that and  then the balanced you can go to six so full width of that then we've got our bill  to and then we've got our vendor details as   well which we need to add hard-coded um and then  we've got our attachment so what i'm going to do   is i'm just going to remove this attachments  one because we don't need the attachments   field so i'm just going to click on form click  edit fields and then we just want to remove   the attachments field perfect  okay so it's shaping up already   so what i'm going to do next is  i'm going to add the vendor details the vendor details which is again a custom card  so we come back to edit fields click the ellipsis   here and then click add custom card which will add  this card and then i'm going to set this to two now i'm going to set the height of this close  that to 150 height of this to 150 as well now you can see it's shaping up a little bit  now what i'm going to do is i'm going to insert   a label into here okay so i'm just going to make the height of this to be 112 set the y to be 34 now i've obviously already   pre-positioned all of this in the other app  this is so it all just fits into one screen   so you know i suppose if you want to follow  these you can if not you don't have to   and i'm just going to go to the text and i'm  just going to set the text for the vendor details i'll just change that font to lotto make the 12 and then this bill 2 will make the height 112 as well the y34 okay so i'm just going to make  the height of this to be 34 which it is and then we're just  going to set the y value as zero set the y value 0 and the x value as 30. okay so now what i'm going to do is i'm  just going to copy and paste this and   paste it into that so i just selected bill  2 hellcontrol c and then ctrl v to paste it   into here and then we just  want to set the text of this to be vendor details inverted commas hey so that's a v34 let's apply that to zero set the x to be 30 so make okay perfect it's coming together nicely so   first what we need to do as well is change  this title field so we want to change this   text so we want to unlock this card and we want  to change all of this to say invoice number voice number and then we can just  set the visibility of this star to be   false because we don't need that okay perfect okay so what i'm going to do is i'm just  going to save this now so if you just click   file save as i'm just going to save this  as invoice generator what i'm going to   do as well is i'm going to call this  production production invoice generator okay so let's just continue with some more so  next what i'm going to do is i'm just going to   remove the borders from around all of these um all of these columns so let's just go to  click what we need click on the property border   thickness set all these to zero so again what i've  found like i've found a lot of time with a lot of   um different developers i've worked with different  power apps i've seen or you know just in this type   of space there's very little or you know i've  not worked at many developers who put much effort   into design i'm a developer myself so again the  design for my apps when i started out were pretty   basic and bad and i was always just use out of  the box i found sometimes if you just even make   some slight changes to the design it just makes  a world of difference so one of the things that i   like to do is just take the thickness away from  these borders sometimes i like to just set the   border thickness to one and in this case i'm just  setting it to complete zero um on all of these so okay so just set this thickness to one to zero   okay that's good so we'll obviously we  can't see any of them now we'll we'll   change the format of that shortly um so what  next so next we want to insert our button   you can just add that to the bottom in fact  what i'll do is change the height of the form   the height of this should be 768 that's fine okay so what we'll do is we'll put the button  in the bunch due property there unlock and add   one in there whilst we're on this balanced view   property we'll set the height of this to 35. i do  apologize it's it's jumping about a bit i mean i'm   just sort of noticing things and just building  this as i go along so please bear with me um so   now we're just going to set those three we might  as well set the three text fields relating to that okay so what i'm going to do is i'm just going to  have highlighted that checkbox so even you know   if you can't find it because we've removed the  boards if you just come along left click the data   card value in balanced view and i'm just going  to set the background of that to be a light gray and then i'm going to set  the width of it to be 350 and then set the x property to be 150 we should be able to just move that up in this position the way it is set the y value to 1. set the y value of the button to two i'm gonna set this balanced you font size for that x 30 y to 1 x to 30 and y 2 1 perfect okay actually i just  want to make that small so it doesn't conflict   with our button when people try to click on  the button we don't want to select on the text   because then it won't work okay so we're doing  good we're doing good i hope you're keeping up   and i'm just going to save these changes  again i hope that's okay just publish that okay so next thing i guess what we can do is we  can make all of the backgrounds on the fields   to be that light gray so i'm just going to come to  this gst one make that like gray back down as well this with 350. that y value to one okay i'm just gonna make this shorter that's the rest x is 30 y is one which is great and then finally at the sale i'm on so i'm just going to  do this one set the background to gray it was 350. okay looking good so i'm just going to set the  ground color of these as well to our gray color sure everything's the same set that's a five okay okay setting the dwight to 40 right so what  i'm going to do is i'll still just finish   the bit of the design and then we can start  going into the little bits of functionality   where we do the invoice number and the rest of  that so next what we want to do is want to add   another data card so this is going to be for  our tasks section so again click the form   click edit field click the ellipsis and add  custom card now what we want to do with this   is let's just see what that's saying  about y was we want to put that to two we want to full width it and then this is  where we're going to add our tasks so we're   going to have quite some functionality for this  so we want to set the height of this to be 303 we don't 280 for now um and then what we want to do is in this  data card we want to insert a gallery   so that's the first thing so insert gallery  and then you could just do a blank vertical now with the gallery it is i found it is quite a  temperamental when you try to add it into a thing   what you need to do is you'll see it added it  outside the data cards if you just now select on   that hold ctrl and click x to cut that gallery  come back to the data card and then now click   control v and then you'll see that that pastes  the gallery within that data card so that's just   a little i don't know what's a little bug with it  but that's how you put a gallery into a digital   so for this data source we want to add another  connector we want to have another sharepoint   connector and then click your connection go back  to your forms sharepoint site and then add the   invoice system demo tasks create connect to that  and then we just want to resize this gallery to be one five six okay we can set the width  for that to be seven four one and x and y properties x is  30 y is 1 3 9. so x is 30 and y is 1 3 9. okay boom right now what we need to do next okay so next click the data card click and say  and we want to add a label so for this label we want to do the width seven nine nine we want to do the y  value there's nine and the x value zero make sure that width is seven  nine nine seven nine nine   okay and then what we want to do is we  just want to change that text to say complete the fields below and select out row to attach the i'm just going to center that keep its 13 size change the font lotto and  that's that done now next what we want to do   is we want to add the button so we're still in  the stator cards we want to insert the button   and then there's going to be quite some  formatting that we want to do on this so again as i said what we'll do is we'll still  just work on the design for all and then i'll sort   of go through and add all the functionality  in sort of towards the end of the video   um so we got our buttons so we want to  change the text of this to be addressed and then what we want to do for this one is we want to change the color of that so we want to change the color of this button to be transparent but then we also  want to change the font to be black oh fun color there to be black   okay and then for this as well we want  to do border yeah the border thickness this should be one and then we want to put our border color so if you just look at the boards of color  and then if you just change it to rgb a open bracket 0 comma 18 comma 107 comma 1 and i'll  just put a nice little cheeky border around that   and as well i just want to make sure that text  is not on so semi-bold i'll just change the   text to normal and we'll change the font to  latter so again like we want we saw that we   want this clip this same button to be separate to  be different to the main submit button and again   this is just the design a little design change  which i think makes the form look so much better   and then finally we just want to set the  width of this button as well to be 97 okay we might as well set the  x 674 and the y value to be 95 yeah okay good stuff so there's our row  button now what we want to insert next is a separator line so if we just go to   icons at the top so i'm just going to  insert a separator so we just insert where is it where is it horizontal line there we go so what i'm going  to do is i'm just going to bring that up here   only extend that now this is a  bit awkward but what you can do   is if you just put the height of that  to one and then if you set the border thickness also to one then there you can see right so there we've got our separator okay  good stuff so next what we want to do is we want to add our inputs so if you  just put there come to insert go to text   and then we want to put text imports  i guess we want to add three of them and we want to line them up with this button so first one's going to be text description  what we'll call description input and we want to set the width of this to be 359 and we want to set the x value of this to be 31. next we want to call the next one description units input sorry change the width of this to be one two one and we want  to change the x value of that to the 401 okay and then this final one will be total  amount input so we mean that total amount input put the width of that to be one two eight and then we're gonna put the x  value of that to be five three four and that should come in nicely now what  i'm going to do to these three as well   is we just want to come to  default text for that and i'll just delete the default text you  want to change the border thickness to be zero and then we want  to change the background   to be our gray i'm just going to do that to the  other two as well so just come up to the fault remove the text import for the thickness it's none uh okay looking good so now what we want to  do is we just want to add three labels and in fact i'll just copy and paste   this bill on so ctrl c come into  here control v control v control v and we want to change that to mount position above that center we want to call the next one the units just drag this to here and then we want to call this one description okay looking good looking good so next what we want to do is we want to   i don't know where this form i'm  not working nicely i'll just change i'm just going to highlight all of these  on the yards row and just move them up   by one so we've got some space for our gallery so then what we want to do is come to our gallery and now we need to do some formatting in   the gallery itself so we've got  quite a few things to add to this so first things first we want to add our b  so we if you click on gallery and then you   click at the top here it then highlights the  rows for that gallery and what we want to do is we one two six i want to  set that to be one five six   yep so that's fine so then first  things first we want to click insert   an icon and we want to do a bin so the trash  move that over to here make that a lot smaller   change the color of that to red and then that's our bin and then next we want to add a separator  so what you can do actually is if you   just come up to this icon and to  that separator we are the before   where is it this icon icon three and click  control c and then in the gallery click ctrl v the separator there and then what we want to do is we want to insert some labels now i'm just going to insert this  first one now in the test of this first label what i am going to do actually what we need to do  first is if we go to the gallery and if we go to items so this is the invoices and demo tasks so  what we want to do sorry i know i'd say to   add this before we don't we we won't have to  change this we want to just type in invoice rows collection now that will error at the moment  so what i'll do is i'll just do the code for the   edge row because what we what we're doing here is  we're creating a collection and that has been each   row on the thing is going to be a collection so  so what i'm going to do here is i'm just going to   copy and paste all of the code into this so if  you click on the add row button go to unselect i'm going to paste in loads of code in here now  what i'll do is i'll just quickly run through   what this code does um and then as i said i'll  put all these pieces of code on the blog post   and so you can just come and take so if  you go to the description in the video   and the link and this will give you this code so  what we're doing here basically is when they click   add row we are going to collect the data put it  into a collection called invoice rows collection   and i'm going to take we're going to create three  fields in that collection the description the   units and the total amount and we're going  to take whatever value is in those three   boxes at that time so that's going to add them to  the collection then we have got this functionality   here so as you can see up until here this  functionality is relating to calculating   all of those costs so because unfortunately with  this functionality the way we add and remove that   decimal place the comma separator the the  dollar sign we need to sort of do these subs   these little functions here to sort of remove  all that format and so we can calculate the   total cost because when all that formatting is  on it it's not recognized as a value so so the   these first two rows just basically substitute out  all of those extra formatting to give us a number   then it creates the variables with that total  value so as you can see the total is just taking   whatever's added and it adds it to the total it  calculates the gst then after it does them it   resets these three fields that we've just entered  the text into and then it sets the format number   variable back to none now again at the moment  it'll probably show errors because we've not   got these formatted yet i might just do them  next just to get all these errors written but   but for now you can take this code put it into  the ads row functionality and that should remove   the error on the gallery which it has because  now you can see the invoice rows collection is   working now as you can see we should have an error  on this label here what we want to change this to is we want to keep it as this item but we want  to put this as the call total amount and i'm   just going to copy and paste this so ctrl c ctrl  v put another one here and then ctrl v again and   then we've got our description so i'm just going  to make that bigger so this one will be this item so it's a call description and this  next one will be this item dot units whole units so again what just what's happening  here is you know they put the value in here they   click out row that does all the calculation  add to the calculations and then it adds   it to that row so this will show the units  below that then in the gallery the next row   will come and it'll just keep building up that  gallery as we go so make that sure so much that okay i'm gonna save it as well  just make sure that you save these okay so i'm just going to do some different format  into this so i just want to change the height   of this one to b112 so it matches that to the  left of it because i can see it overlapping ah and then also we want to make the inline height oh okay so i want to make the line height for that  more point eight i just want to add another   space in between each of these  so just come back to the text fill it up and then again on the same thing here  we want to make the line height as 1.5 so that's   i mean the reason that we're doing this is just  because the two different controls so they just   have different heights but when you enter the  address it should look similar to that one   and okay so that's that done so what's next so i  guess what we want to do now is we just want to   add we want to fix the format and on uh okay one  of the things sorry is we want to add a border to   so we just go to our gallery and we want  to bore the thickness of one on that just make that a little bit smaller so it fits in okay now next what we want to do i'm  just going to make this y2 as well i'm just going to change  that y property to 137 just just to give a little space in  between and as well my gallery i'm just going to change the balls of color  to be the gray as well or maybe a bit better a bit of a okay good stuff right so next we want to   add the format into these so what  we're going to do is we are going to so we're going to make the display  mode for all of these to be disabled so we're going to unlock it display mode dot disabled i'm going  to ctrl a to highlight all of them   and i'm just going to do it  to all three display mode make sure they're all locked so no one can  actually add them and then we want to do   is we want to add some code to the default to  them so we want them to automatically calculate   and so if i now just go to the default  property and again i'm going to i'm just   going to paste the code into this again as i  say i'm going to put it you can take this code   off the link in the description and i'll just tell  you what's going on here so we're using a tech   function we're getting the value of this variable  that we set every time we add the row and then   this format and just reads the decimal place the  command the thousand separator and the dollar sign   so that's that one for that um so that's obviously  the variable total variable now for this next one um i'm gonna use this one so this is the variable  gst again with that format applied   and then we'll have our final variable yeah so then that is basically just adding  the two of them together so we're getting   our variable total value and our variable  gst and it's just adding them together okay   now next what i want to do is i want to just  come back up to this amount again i apologize   it's jumping just all over the place um there is  just so many different things to this so i'm just   going to come back to this amount text input here  and i'm going to come to the unchanged value right   and then what i'm going to do is i'm going to  paste in this code again this code will be in the   link in description basically what this is doing  is it's setting a variable called formatted number   it's taking that value and it's appending that  thousand separates in the decimal so you know   when the user types in 600 when they click off  that or when they click add row that'll add all   of that format button and that's just that piece  of code for that now we're going to come up to the we're going to come up to this here  and i'm just going to go to so we're   just setting the invoice number it's  going to go to the default of this   and just for the default of this we've just got  a variable name called invoice norm so again   that'll error when we do this now now what we'll  do is we'll go to the onstart of the application so we'll go to the on start of the location so click the app come to the property onstart  and then what we're going to do is we're going   to paste this code in so we're going to set  that invoice number so in this piece of text   here you can add whatever you like so i suppose  this is relating to the app you want you know   you could have your company name or whatever this  is just what's going to appear before the number   on the invoice so i just kept it as in and  then what it does is it's got an ampersand   and then we've got the last invoice demo id and  then we plus one to it so as i said this always   just automatically increments so it looks up  at that sharepoint list of of all the invoices   it gets the last one of it so it'll get the latest  one the highest id which again could be like five   and it'll just take that fifth add one to it  and then that'll make our invoice number six   so that's how we keep that unique incremental  and we are nearly there so i just want to   now come to the form i'm just going to add  the border thickness to be one on the form and then what i'm going to do is oh no so something's happened there i think right i don't know what's happened here but i'll  just quickly fix it i assume yours might have hit   the same as well so i think that was because it  was a refresh to the database so what i'm going   to do is i'm just going to change the width  of this to be 800 or 700 and 8 invoice number why is all of this gone different my property that should be one so  just change that date to be one it seems that everything has jumped  up and changed we can just quick   quickly fix this i'll just change that invoice  to be one bill two the y value can go back to two right okay i should fix all that i'm  just gonna we've got the sail amount   i'm just gonna change the width of this to be 800  3c as well and even though we did have the width   fit sometimes you know if it's still if  the width of it is still only half the size   it will just bunch them up onto the same row  and so i hope you've been able to just fix that   little issue there and as we can see we've got our  scroller that's come back in so we just want to   bunch this up a little bit more just  change the height of this to 30. we click on this bottom this  is the error that's come up and i'm just going to change  i'm going to move this up   and i can just go there i mean that error  is not going to appear because we've not   got required on this but just moving that up has  now made the um the scroller disappear so i do   apologize for that that's just the powerapps  glitch i hope you've been able to fix that   and so what we're going to do now is  we're just going to insert a rectangle icons for rectangle there you go and then i am going to set the  background color of this rectangle to be   a dark gray and then i'm going to just make  this fill the whole screen now on the settings   of this rectangle just come to the ellipsis  and then click reorder and then center back   that should then bring our form in front now what  you'll see here is because the form is transparent   and everything looks a bit different so what  i'm going to do i mean this is a bit of a   weird way of doing it if you do if you um  if you do know a different way to do this   please let me know but what i'm going  to do here i know it's not the best   practice but i'm just going to put another  rectangle inside of each of these um and i'm just going to put the color of that as  white and then i'm going to send that to back and then that is our rectangle so now i'm  just going to copy and paste that and i'm   going to put it through all of them  and again i know this isn't the best best method of doing it but i hope it still works center back i hope you don't have too many issues  doing this you know i'll just center back [ __ ] because that keeps coming as a whiff  i'm just going to copy this one again let's   just send that to back and now i'm just going to  control c so i can take that one and it will be um okay so we are done by the looks of it i  just want to resize some of this because okay so i've just had to resize that just  to because i just really don't like the um hey okay so just set that to 50 and 50. so you i mean  it is possible to get it where it's just dead on um just put the y value of that to be zero  and then just make that height to be 50. okay okay so what i'm going to do here is well i'm  going to change this button text to be submit and bring it into it on a line and there we go so i think that could actually  be it um let's do a run through i'm just going   to save it and let's try it out publish this  as well so let me try it out oh that's not good   let me just set that default form to new we  come back up here go to default form click new   now when i click the play button  that should be ready to go uh   okay so the dates in the invoice number  are swapped and that is not disabled so   if you come to the invoice number come to display  mode and we want to change that to disabled i'm just going to change the  position of that to be 500.   i'm just swapping back uh the vendor details soft  as well so i'm just going to change the position   of that again to be 500 to apologize that's  that recent bug okay so now that should be it   um so again i've just as we've built this realized  the bug so because there's no actually nothing in   those lists the invoice number's not coming up  if i just run the app on start see if that works   okay so it's just come up as invoice one  um which is actually all right yeah so i'm   just going to make a space of this put a hyphen  and i'll just run that up on start again there   we go so we've got our invoice one now i'm just  going to save and publish it again and let's do a run through so bill two ah straight away knows  there's another issue with this text field we   wanna change this to multi-line so then the text  comes at the top so bill two customer one address   one post code one leave that as is if you want  to make that a little bigger just so that fits in so i'm just going to change the y values  on this to be 32 just so i can accommodate   for that height size to fix that issue  and i hope you're following us on this   channel 114 change that height to b114  okay that's looking good so now i just put okay so we've got our four lines there   city now next we're going to do our description  so sharepoint development units ticks amount 500.   so if we click off that that's not reformatted  correctly so i need to change that okay what we   need to do is we just need to change the default  of this to be formatted numbers let me change that so that's the variable that we want and  then we just want the default of this to be formatted number okay so now you can  see the 500 comma if we click add row   there it adds correctly let me just now come  into this i want to just center align this   in fact we want to just center align  all of this to make it look better okay ah and we forgot to do our bin as well  so let me just do the bin so in the bin i'm gonna just paste this block of code  which as i said be in the description but   again what this just does is it just  clears everything and it just removes   so what it does is it removes the value that  was on it from those total costs and then it   just removes this item from my collection so  it's no longer in the collection and so now it looks like our total amounts are coming in  correctly 600 500 100 if i just delete that   that's set then back to  zero so that's working great so now i'm just going to add a couple of couple of rows and i'm gonna ah so we  finally need to do our submit button as well   um so the submit button is relatively easy and that is just submit form okay so now we've got everything generated  if i just click submit form click submit   ah okay another thing okay another thing so what  we want to do right is this is just the best   practices that on this button it clicks submit  form what we want to do is we want to change   something in the on success function when the form  is successfully submitted so what we want to do is again i mean i'm going to paste load  the code i'll just explain what it does   um so what it does is it takes all of those  roads from that collection and it patches   it to that invoice system demo task list that we  had and then it takes those units that's putting   those values into that sharepoint list then it  tells the user that's successful um it sets the   form to be a new form so it removes everything  it clears that collection sets all the values   back to zero and then it's it resets the um that  invoice number so i'm just gonna now that we've   added that block of code to the on success  i am just going to run the onstart again and in fact what i am going to  have to do is if you just save it and we are just gonna have to refresh our  screen as we apologize for this refresh the screen that should open our app again click override because it's still got that session  open but it's all saved so it should be okay okay so let me just quickly  fill this out again customer one   press one city one postcode one that's looking  good sharepoint dev five units six hundred dollars i mean i wish i could get six  hundred dollars for five hours work   um okay so that's all looking  good so let me submit that again   successfully submitted everything's cleared we  can see our invoice has gone to the next the   next thing now let me just wait for that email  to come through and fingers crossed we will have fingers crossed comes through successfully okay so hello the email sent correctly it looks  like it has attached something let's open this up   okay so it hasn't pulled in those values correctly  now let me just figure out why that's happened okay ignore me so this was the previous email  before we added that on success so where's the   next email so let me just pull that up  and with the text that we added in that   on success methods should fix that issue  that i've just explained so here's the email   let me just open this perfect and there you can  see so it's holding those records successfully   there's the units that's all worked successfully  the total amount there our invoice is generated   and there you go all done thank you so much  i hope this has helped uh i'm pretty pleased   with how that's gone it took a lot longer than i  expected but we got there in the end if there's   you know there's any issues with anything just  put it in the comments i'll definitely reply   to all the comments please like and subscribe to  the channel you know anything around this i just   want to you know get more popularity around this  i think this could be a good system i think this   can help quite a lot of people especially for like  small businesses or people who don't want to pay   the costs for like accounting systems and things  like that you can literally just whip this up   and you can be away with it so yeah please and  subscribe to the channel and take care thank you