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.

Can entry in html form become FM query criteria?

valyent
in Custom Web Publishing

Featured Replies

From a HTML form on a page within my site, I would like to "on submit", access my FM Web published database and using the "Job Number" entered, serve a read only view of the record relating to the job number entered ie:

1. User enters job number "xyz" in field of form on html page;

2. Submit button calls up the database at dns and searches for "xyz" info

3. Displays a read only layout with necessary data.

Any help would be appreciated...

This can be done with ease using Custom Web Publishing (CWP). For example:

http://mydomain/FMPro?-db=mydb.fp5&-lay=mylay&-format=results.html&job_num=xyz&-find

or

<form action="FMPro" method="post>

<input type="hidden" name="-db" value="mydb.fp5">

<input type="hidden" name="-lay" value="mylay">

<input type="hidden" name="-format" value="results.html">

Enter Job Number: <input type="text" name="job_num" value="">

<input type="submit" name="-find" value="Show Job">

</form>




The Format file (results.html) would look like this:


<html><head></head><body>

Details:<br>

[FMP-Field:job_name] [FMP-Field:anyother fields.....

</body></html>

All the best.

Garry

Create an account or sign in to comment

https://fmforums.com/topic/13383-can-entry-in-html-form-become-fm-query-criteria/
Go to topic listing

Important Information

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

I accept

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.