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.

Is it possible to Update related field?

Featured Replies

Lasso 3.6.6 and MacOS9 w/ FMP6.

Can you update related fields using the Update action?

Example:

<INPUT TYPE=hidden NAME="-Database" VALUE="Orders.fp5">

<INPUT TYPE=hidden NAME="-Layout" VALUE=Test>

<INPUT TYPE=hidden NAME="-RecordID" VALUE="[FMP-FIELD: 'recidnum']">

<INPUT TYPE=hidden NAME=Status VALUE=Closed>

<INPUT TYPE=hidden NAME="-UpdateResponse" VALUE="CheckOut.html">

<INPUT TYPE=hidden NAME="-Response" VALUE="CheckOut.html">

<INPUT TYPE=text NAME="Account Number" VALUE="">

<INPUT TYPE=text NAME="Customers::Email" VALUE="[FMP-FIELD: 'Customers::Email']" >

<INPUT TYPE=submit NAME="-Update" VALUE="Place Order">

This shows values from both databases, but renders an error -10005, which doesn't even show up in the documentation, when I submit.

When I remove the related field, it works.

Thanks,

Ken

I do not know about 3.6.6. Couldn't you use Inline and not displaying field names. That is security risk.

Maybe portal?

  • Author

I have been using inlines throughout the rest of the site, but for some reason it doesn't work on these couple (most important) pages. Want to check my code?

<FORM ACTION="action.lasso" METHOD=POST>

<P><INPUT TYPE=hidden NAME="-Database" VALUE="Orders.fp5">

<INPUT TYPE=hidden NAME="-Layout" VALUE=CGIInv>

<INPUT TYPE=hidden NAME="Order ID" VALUE="[Cookie: 'FlandersOrderID']" size=30>

<INPUT TYPE=hidden NAME="Customer Number" VALUE="[Cookie: 'FlandersID']" size=30>

<INPUT TYPE=hidden NAME="-Operator" VALUE=eq>

<INPUT TYPE=hidden NAME="-Response" VALUE="CheckOut.html">

<FONT COLOR="#FFFF00"><B>Next

Step:</B></FONT><INPUT TYPE=submit NAME="-Search" VALUE="Continue to Check Out">

</FORM>

Translates to this for an inline:

FORM ACTION="CheckOut.lasso" METHOD=POST>

<P><FONT COLOR="#FFFF00"><B>Next

Step:</B></FONT>

<INPUT TYPE=submit NAME=submit VALUE="Continue to Check Out">

</FORM>

CheckOut.lasso looks like this:

[inline:

database='Orders.fp5',

layout='CGIInv',

'Order ID'=(Cookie: 'FlandersOrderID'),

'Customer Number'=(Cookie: 'FlandersID'),

-Operator=eq

search]

[include: 'CheckOut.html']

[Error_CurrentError]

[/inline]

Can you see why it would not work? It brings up the CheckUp.html page, but the fields are not populated. Did I miss something in my inline?

  • Author

Anyone see the problem?

I am just trying to search on 2 fields, both of which are saved as cookies. The LDML version works fine, but is not very secure and I would like to use an inline instead.

Am I missing something when I translated it to an inline? Did I call the cookie wrong?

Help!!

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.