is "Tanggai" a date field that records the date of an employee's work history?
On what layout based on which Tutorial: What are Table Occurrences? did you place the summary field?
If you define the summary field in Transaksi Gajian but place it on a layout based on Master Karyawan u..., you should get the total days absent for the specified date range for the current employee record.
You can also get a count of the days absent if you place that same summary field inside a sub summary part "when sorted by" IdKaryawan on a Transaksi Gajian layout if you then sort the records by IDKaryawan. With such a layout, you can perform finds for one or more employees and for a specified range of dates to get the number of days absent for one or multiple employees.
yes, "Tanggal" is date field.
I made the layout based on Master Karyawan U.. that you mentioned. It only show employee name and Transaksi Gajian::AbsentSummary. But it shows nothing on summary field. When I clicked on Transaksi Gajian::AbsentSummary field it tell me that "This operation cannot be performed because one or more of the relationships between these tables are invalid." Is that because I have other Master Karyawan table related to Transaksi Gajian?
I don't like to see all transaction to see summary, it is overwhelming since the range is about a year.
Is there any clue to show only name with "not resigned" status?
What storage options have been selected for IDKaryawan?
The "T" connector type in the relationship line shows that this field is either unindexed, unstored, global or a combination of the three.
This field should be a field of type number and it should indexed and cannot be a field with global storage specified.
I can't make IDKaryawan as indexed, because it is a calculation from table Form Transaksi. Here is a layout based on "Form Transaksi" table where user is inputting data for all transaction. This is a weekly wage, and name is inputted on Form Transaksi table.
As you can see on my previous post, relationship between Form Transaksi table and Transaksi Gajian table is only related on ID Transaksi field. Is there a workaround to make it work?
It should not be a calculation field. It should be a number field that is assigned a a value at the time data is entered into that table. This will happen automatically when you enter data in the portal to Transaksi Gajian if you enable the "allow creation of records via this relationship" option.
I have thousands record already, can you help me to show the way to fill that number field for existing records? All I can think is auto enter feature with calculation, but it will only work when I create a new record, so it won't work for existing field.
EDIT: do I have to change all field to not have T shaped relationship? Or I just need to change Transaksi Gajian::IDKaryawan, and leave Master Karyawan u..::THRmulai and Master Karyawan u..::THRselesai as global storage?
THRmulai and THRselesai is just a reference record for range.
Replace field contents can be used to do a batch update on all the records on your field. Be sure to save a back up copy of your file first, then be sure to select Show All records so that the update updates all the records in your table.
You should not modify the storage options on all your match fields to make them stored, indexed, non-global fields. You just need to understand how they work and when they will not work. Such fields function as match fields in a "one way" relationship. You can access other related records from the context of the table that defines the unstored or global field but not the reverse.
Thank you Phil.
But now the final problem is to filter only working employee on that layout. I never be able to filter using "perform find" command in script. The value to filter is in Keluar field, with value of "1" (without quote) for resigned, and "" (without quote, empty) for working employee.
I use that script on a button to filter resigned employees, then go to absent list layout. Can you help me with that too?
bump for script to filter to omit when Master Karyawan = 1
I can search it manually, but I cannot apply it on script