Basically I have a form where users can create a new job. One project may have multiple jobs, for example if we have a job called Coke Commercial, we would have
Coke Commercial - Run of Show Package
Coke Commercial - House Location Drop Load
Coke Commercial - Bowling Alley Drop Load
The thing is run of show packages are 90% of what we do, so having to type this in every time is a bit frustrating and repetitive. I’ve been trying to figure out an easy way to do this, but I’m really striking out since the options for default values in a text field seem to be limited to only to columns in the user sheet. Otherwise I would just make a template and a checkbox that turns the template on or off and then use that as the default value in the field.
Basically I have a form where we add projects.
Right now I have just made the default value be - RUN OF SHOW so that we can put the cursor before it and then type in whatever. If we want to do a drop load package we just delete RUN OF SHOW and then type in what we want. It works, but it’s not the cleanest solution.
Does anyone have any other suggestions on how to accomplish this?
It should not be this way. I will find some time today to give you a copyable app for this, assuming you have multiple jobs and you want to add projects for each job. I will also add the job name before the dash for you.
1 Like
Here, I have a template column joining the job name and “Run of Show”.
Then I use that column in the form when I submit a new project for the job.
So when I have a new project, let’s say “Burger Sunday”.
Then the template will be changed dynamically.
Copyable link:
1 Like
Okay great! Thank you so much for that. So it seems like the difference is you are using a form button as opposed to the Add button at the top and that allows you to put a template inside of the field as the default value. Is this the only way to achieve this? I’m not 100% sure I want the level of organization as having to click into the project, then select the specific job, as 90% of them are just a single job within a project. It seems like I may have to make my main screen a detail view, add an inline list, then add a form button at the top in order to do the same thing you’re doing without adding that extra layer of organization.
So you don’t need to have the context of the “job” right?
If you just need " - RUN OF SHOW" as your default value without any context of job, I think you can just specify it directly as a custom text without pointing to a column. Can you confirm?
Thanks for this, I’m going to give it a shot soon! Will update you with how it works.
1 Like
Great, looking forward to see how it goes!
