Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Editing multiple records using CDML

Featured Replies

I have a couple of issues with a hosted database I am trying to write the web interface connection for.

It is part of a Course Request System for high school students. The part I am working on is a way for department heads to enter the eligible courses per student, and then have that list be a custom pop-up, based on each student's eligible courses. E.g, Math Head says Suzie Q can take Trig & pre-calc, but not robotics. Then when suzie q logs on, she only can choose from Trig & pre-calc. Right now I am just getting the basic mechanics working and have a few problems.

The entry page for dept heads works. They find a set of students (11th graders for Math checkboxes). The page displays usingFMP-If's and tokens for the grade and dept combo, so they see the correct stuff. Great.

They see only student1, and can enter her checks and SUBMIT. That's okay, BUT - is there anyway to EDIT a LIST? I can get a list to view, with all the checkboxes, but it's my understanding that -Edit and -RecID can only edit one record at a time. If that is not true, that would be GREAT! But, since I think it is...I have made an alternative, but still need help with that.

Okay, if they submit checks for one student, the reply page brings them back the same found set, and goes to student 2 using a token in an inlineaction. That works fine, it actually looks like the page just refreshed and went to student 2. The problem is that the -edit button does not work there; it says format file not found. I did specify a format file, but if I include -RecID in the inline, it gives me the previous record, and messes up the find and skip. I am guessing that it is because it is all inside an inline action whose action is -find. So...can I have an edit action inside an inline - or am I approaching this the wrong way?

Here is my inline action on my reply page:

[FMP-InlineAction: -db=_EligibleCourses.fp5, -lay=Eligible, -format=reply2.htm, -token.1={CurrentToken.1}, -token.4={CurrentToken.4}+1, -Max=1, -Skip={currenttoken.4}, -SortField=ToScheduler::NameReverse, -SortOrder=Ascending, -Op=eq, ToScheduler::Grade={currenttoken.2}, -find]

So that find works, but then my -edit button does not. ANY clues? Is CDML too simple for this? Thx, in advance!

You can edit multiple records through a portal, you need to use the 'current portal row number' replacement tag.

e.g.

input type="text" name="relationshipname::fieldname.[fmp-currentportalrownumber]"

Hope this helps.

The other way is to use PHP.

All the best.

Garry

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.