hello everyone in this video I will show you how you can make a complete crud web application on top of Google Sheets without any coding you will be able to build multiple apps on your own by editing the app settings and schemas it also features file upload Dynamic dropdown dependent fields and computed Fields dependent fields and computed Fields will require minor coding but that can be done very easily so let's start when you open it you will see multiple app sections to perform create read update and delete operation targeting different sheets you can search your record you can create a new record by clicking this add new item button here you can see I have opened the projects tab in Google Sheets it contains fields like project name project category deadline date status approval priority and assigned user based on these records I have built a crud application that you can see here it's displaying all the projects in a nice table along with nice and Rich formatting you can also do the Sorting searching and filtering you can very easily create a new record by clicking on this button called new item this will open up the form let me fill this form click on save you can see our new record has appeared here on the top now to edit this record click on this pencil icon this will open up the pre-populated form you can edit this form and hit save to save your changes here you can see this row got updated to delete it click the trash icon this will ask for your permission to delete it allow to finally delete it and here you can see our record has been deleted successfully you can also sort your records by any field you like to let me show you that as well here I am sorting it by deadline date by priority and so on you can very easily filter or search through your records let me show that to you let's search for Project G let's show only pending projects so it's filtering the records nicely let me give you another demo with file uploading Dynamic dropdown dependent fields and computed Fields this is the product list or you can say rate sheet this list will be used in sales form to enter the product and its rate this is the form to create a new product we can upload an image like this hit the submit button and our record has been created successfully you can view the created record like this let me show you the uploaded file and its location here is our uploaded image the script will automatically create a folder inside the parent folder containing the spreadsheet now let's move to the sales tab here we can pull product rates like this notice when we select the product the rate field also gets updated and when we enter quantity it calculates the amount field too this demonstrates dependent fields and computed fields and the product dropdown can be updated easily using the products tab there by making the drop down Dynamic now hit the save button and you can see the newly created record you can view your record by clicking this view icon if you are liking the video then please take a moment to like And subscribe moving on let's talk about how to do configuration here I have a table with one ID column this ID column is necessary in order to perform crud operations you can name this column anything next you need to have a schema that will dictate how the table should get displayed and it will also be responsible for constructing the form the sheet containing the schema can be named anything you can simply make a copy of this sheet and customize the fields to suit your needs do not change the text in the header the entries in the key column should exactly match with the header in the record tab to ensure this you can pull your header Fields using this formula you can edit the labels for the corresponding Keys here this is how it will appear in the table and in the form also in the type column you can select from the available choices like text date time number number currency text area select radio and checkbox file file image link required column is used to set if the fields are mandatory you can put false against the non-mandatory fields you can provide options for input Fields like select radio checkbox in this options column it should contain items separated by comma you can also pull options from different sheets like here I have pulled project categories from the dropdowns tab I have used the join function to make it a comma separated list you can also use another record as a drop-down source for example I have used the products table as a dropdown Source in the sales form for that you need to set the type as select option source and enter the sheet name and key name in this fashion here the source is the sheet name and key is this item field name if you want to pull options from a record- like products if you want to sort your records based on certain Fields then you can set its value to true in this sortable column for the alignment of text in a particular column you can choose from three values Start Center and end end is suitable mostly for Price or amount start is suitable for plain text and descriptions for number types you can also set its maximum and minimum values you can also hide certain columns in a table view or disable fields in a form that needs to be computed or that depends on other fields once your schema is ready move to the app setting tab do not change the name of this tab as it is hardcoded in the scripts here you can list different apps provide the app name here you can also choose your local and set currency this will be required for formatting dates price and amount in the table you can also change the data entry sheet and schema sheet so it allows you to have multiple data entry sheets in the same spreadsheet and hook them with your web application at ease if your table has an ID column named different than hash then you can alter that here this refresh sheet list button is meant to refresh these dropdowns containing sheet names click refresh sheet list to update the dropdown with any newly added sheets once again don't forget to choose the data entry and schema sheets and specify the ID column as this is crucial for the application to work properly if you notice here you can see nice formatting in the rating column using stars and in these columns also you can see some nice formatting for status and approval columns so you might be thinking how you can have those formatting Styles in your case for that I have kept a few key names reserved for the application so that when you use them in your schema it gets picked up by the application code to format it the way you have just seen let me show you in more detail what I mean by that here in this schema if you use rating as a key name for some sort of performance field then it will automatically be formatted as stars I have provided the detailed instructions here in this comment you can read it later by making the most of these features you can seamlessly customize and adapt the application to meet your specific needs remember to save the settings after any adjustments to make sure they take effect now the most important part is how do you make this yours so first of all make a copy of this spreadsheet you can get it by visiting the purchase link I I have kept the price very affordable I will try to publish such paid content as minimum as possible your support is highly appreciated once you have opened the spreadsheet then click on extensions and then app script now click on deploy and then choose new deployment select web app as deployment type give it a name like version one in execute as dropdown select me in who has access dropdown choose only myself then click on deploy it will then ask to authorize the code go ahead and Grant all the permission it will take some time and then you will get the app URL now go ahead and open the URL then you also need to save app settings and refresh the app again here you got your application let me show you where to modify the code for computed fields and dependent Fields here in this file named comp compute mix in you need to modify these functions for example when a product is selected this handle select change method is called here we provide an app name which is sales in this case then we find the selected product like this then we retrieve its rate and assign it to the rate field similarly you can modify this calculate block to have autoc computed Fields if you desire an even more customized version then please contact me using my email I will try to provide that at an affordable price if you liked the video then please hit the like button and please subscribe to my channel for more such videos thanks for watching and see you in the next one