You are viewing limited content. For full access, please sign in.

Question

Question

Laserfiche Forms- Auto Populate Per Diem

Forms
Updated August 29, 2018
asked on June 20, 2016 • Show version history

How can I auto-populate the per diem amount based on number of days selected and based on the location selected from earlier fields on the form? I have imported the GSA Per Diem rates into a SQL database.

0 0

Replies

replied on June 20, 2016

Hi Jorge,

If the per diem rates are stored in a SQL database, you can create a lookup rule to retrieve the rate based on the location selected, then use a formula to calculate the total amount based on the number of days. Be sure to configure your data source and associate that business process with the data source. Hope that helps! 

1 0
View 2 previous replies
replied on August 3, 2016

Hello,

 

Are we able to use an API as a datasource in Laserfiche Forms? It seems like this is the only way to be able to get the per diem rate by searching with the zip code.

 

This is the link that GSA provided for using their API for the per diem rates:

http://www.gsa.gov/portal/content/162379

0 0
replied on August 27, 2018

Did you get this to work?

 

We are wanting to use the API to auto fill the form as well.

0 0
replied on August 28, 2018

Yes. What we ended up doing was importing the Per Diem database into an internal database where we could then configure the lookups on Forms.

0 0
replied on August 28, 2018

Jorge,

Do you have a link to the database you downloaded from them? we found the Excel sheets they publish, but those took some manual manipulation to get into a CSV format and still are not fun to lookup against...

0 0
replied on August 29, 2018
0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...