bcooney

https://www.youtube.com/watch?v=94HVrQblPcc DB Services shows different ways to generate a PDF and email. I reference this video because it shows at the end how his report script is called by a server script schedule which is what you want to do. You'd need to add to your report script the logic to see if it's the last day of a semester. As Olger mentioned, this can be a query to a table that has a record for each last day of semester. Also see: https://fmhelp.filemaker.com/help/18/fmp/en/#page/FMP_Help%2Frunning-scripts-on-server.html

xpost https://community.filemaker.com/en/s/question/0D50H000072ok3SSAQ/create-a-heatmap

Start here. https://filemaker.jiveon.com/docs/DOC-9285

And the old "prefixing with a g < > global field" - check the storage setting!

truncate table. be very careful.

Please post screen shots.

Alan, what you're building isn't simple. Perhaps this site will help: http://filemakerinventoryresources.com/

"The input menu does not show me anything from the drop down menu" What input menu? Show us the UI with a screen shot in layout mode. The table "Music Inventory abc" is oddly named. What does it represent? Can one music inventory item be used across multiple grades? Your data model does not allow that. Are Arrangers and Composers people? Can an arrange be a composer and vice versa? I'd probably put them in a People table. You can name the table occurrences if you want for the roles. Perhaps add Indicator fields in the People table, ComposerInd, ArrangerInd. That's a simple form of a party model. I'd suggest reviewing Library data models. https://tinyurl.com/yyx47at6

have a creation date field and I would like to add a year to Just to be clear, keep the creation date and add an additional date field "MyFutureDate" , auto-enter calc, to comment's suggested calc.

Conditional value list. Have you considered a find? It's much simpler than complex relationships.

I'd like to help, but your terminology confuses me. You have a list of records that have a categoryId. You have a global field that has attached to it a value list of Categories (Id and Name?, showing second field only) - RIGHT? I'd do a scripted find given the Id populated in the global. What is a "cascade filter" ? What do you mean by "Global field as a variable to generate a look up list" ? What are "Report lines - Each line of the report" ? Do you mean the records? Are you new to FileMaker and so are using terminology from another platform?

I’m not following. However, I’d probably just do a find using the category in the global. The find script could run onobjectsave.

Can you describe your use case using actually values? “I want the user to select from a list of active products when creating a new invoice line item,” for example. A screenshot is even better.

I agree. A stored summary table for this data would be better. see: https://www.geistinteractive.com/2018/04/02/filemaker-summary-table/

Layouts are merely vehicles for displaying record data. Are you more concerned with one user at a time editing a record? Seems to me you might think that is necessary to handle. Filemaker handles record locking for you.