Hello,
I have sessions table that contain these columns:
Group, Teacher, Classroom, Start of the session, End of the session, Date of the session
Letโs say I want to create a session with Group โAโ, Teacher โAโ in Classroom โ1โ, from โ9 to 11 amโ on Friday April 17, 2020
Whatโs the best way to create same sessions with differents dates for 16 weeks (April 24, May 1, May 8, May 15, โฆ until July 31) without having to fill the form again and again for each date
Thank you
Solved! Go to Solution.
You may wish to try following approach. Here you will be able to copy the latest record for a given combination (Group, Teacher, Classroom, Start of the session, End of the session) by using an action and then simply save it back without filling in a single field. However you will need to manually tap on โCopy Recordโ action everytime you want to create a new record.
Please create a LINKTOFORM() action on the form and table wherein the above information is stored.
The LINKTOFORM() expression will look something like LINKTOFORM(โYour Form View Nameโ, โGroupโ,[Group], โTeacherโ,[Teacher], โClassroomโ,[Classroom], โStart of the sessionโ,[Start of the session],โEnd of the sessionโ,[End of the session])
In the โBehaviorโ setting of the action , you may have following condition for the action
[Date]=MAX(SELECT(Table Name[Date], AND([Teacher]=[_THISROW].[Teacher], [Classroom]=[_THISROW].[Classroom]โฆ ))) Basically all those conditions that you wish to have constant except for the [Date]
This condition will ensure that the action is always available to only the latest record for that combination. Make this action inline and attach it to a column. You may create a text column simply to attach this inline action.
A screenshot of the test app is shown below, with inline actions attached only to the latest records.
You may wish to try following approach. Here you will be able to copy the latest record for a given combination (Group, Teacher, Classroom, Start of the session, End of the session) by using an action and then simply save it back without filling in a single field. However you will need to manually tap on โCopy Recordโ action everytime you want to create a new record.
Please create a LINKTOFORM() action on the form and table wherein the above information is stored.
The LINKTOFORM() expression will look something like LINKTOFORM(โYour Form View Nameโ, โGroupโ,[Group], โTeacherโ,[Teacher], โClassroomโ,[Classroom], โStart of the sessionโ,[Start of the session],โEnd of the sessionโ,[End of the session])
In the โBehaviorโ setting of the action , you may have following condition for the action
[Date]=MAX(SELECT(Table Name[Date], AND([Teacher]=[_THISROW].[Teacher], [Classroom]=[_THISROW].[Classroom]โฆ ))) Basically all those conditions that you wish to have constant except for the [Date]
This condition will ensure that the action is always available to only the latest record for that combination. Make this action inline and attach it to a column. You may create a text column simply to attach this inline action.
A screenshot of the test app is shown below, with inline actions attached only to the latest records.
These additional references may help you just in case you have not yet eferred these
With such explanation, you canโt miss your goal
many thanks to you
User | Count |
---|---|
36 | |
34 | |
27 | |
23 | |
18 |