Glide: Append ANY CHOICE LIST after completing a form AUTOMATICALLY

hey guys this is bob from edtechify and today we're going to show you how to dynamically populate a second sheet of categories based off of a form submission so the premise here is let's say i want to create a new task i want to assign that task a category but the category doesn't already exist so not only do i want to assign it a category but i want to also append my list of categories with the new category dynamically so that way i don't have to duplicate efforts let's show you how [Music] to start we need a simple setup of two different sheets in my data editor i'll show you that i have one sheet with the list of tasks and a second sheet with my category list in this example my category list is source name and in my task sheet i'm referencing that source name with this source column i then created a relation between this source column and the source name in the sourcesheet i don't need to match multiple because that source should only be listed once now where the magic happens is that this relation not only matches after the record has been created but it'll actually attempt to make that relation as you're completing the form let me show you so back in my layout view i have an add condition here to add a new task this source choice component is referencing my sources sheet and pulling the values there we only have the one source at the moment bombshell but let's say i wanted to add a second source and not only add it to this task but also add it to that sources sheet here i have a text entry component that's also writing to the sources sheet so in the event the source doesn't exist we can type one manually now to prove to you that that relation column is going to attempt to make the relation between what i'm entering and the sources that already exist what i did is i applied a visibility condition to only show this text entry when that relationship is empty meaning that there is no relation right so here in this text entry component in the features i set a visibility condition to only show when that relation is empty note that this record has not yet been completed it's still in the process of being entered and it's only going to show when the source is empty meaning that there is no match so if i make a match by selecting an existing source we should see that the text entry goes away and it does so again this proves that that relation column is making the relation even though we haven't yet completed the form i'm going to cancel and go back into it so now that we know that that relation is actually taking place even though the record has not yet existed we can do some trickery here to also add this new source to my sources sheet to do so we're going to leverage the on submit action for this ad screen currently it's just showing a notification that the task has been assigned what we want to do is first check to see if that relation is empty and if so add a new entry and then show this notification so we're going to come over here and create a new action and this will be a very simple conditional multi-step action so first we want to check is if the relation source is empty okay if it's not empty meaning that it found a match all we want to do is show notification that the task was completed however if it is empty we want to add a new row so we are going to add a row to our sources sheet and we're going to write the source that we typed in to the source's name then we'll show the notification this action mb create new source upon creation save all right so now our add screen has a custom action that's going to check to see if we're typing in a new source and if so add it to our sources sheet let's see if this works source right we're not going to select an existing one we're going to type a new source and complete the form see the notification and let's check our sources sheet to see if that new source was entered and it was so just by using a relation you can now create new entries in a different sheet altogether based on whether or not that entry already existed so hopefully you can use this in your app if you have any questions feel free to email me at robert.potato at woodward.edu and as always thanks for watching

Channel: Robert Petitto

Views: 2,029

Keywords: glide, glideapps, glide app tutorial, glide apps examples, app development, nocode app development, nocode movement, no code platform, low code development platforms, low code, low code no code, glide app, gtd, automation, form fields, nocode

Id: RyiOxzsN9N4

Length: 5min 19sec (319 seconds)

Published: Fri Jan 29 2021