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.

Customer Referral Program

Featured Replies

  • Newbies

I am not sure if I am posting in the correct location. 

I have been working on a database for a few years now, I will not call myself an expert, but I have figured out how to do a lot of things.  I am at a spot where I need help. 

I have created custom invoices and status screens for my screen printing and embroidery company, now I need to create a customer referral program.

 

I have already set up the relationships where I linked the referrer to the referred.  I can see totals of each referred customer in the referrer's customer layout. 

 

I need a way to add the points, which is 1 point per $1 spent, to the points section of the customer layout.  Then I need to have a way to apply the points to an invoice of the customers choice, and deduct the points from the total once the discount has been applied.  I think it is an easy solution to this, I have just been racking my brain over this issue, could someone please point me in the right direction.

 

I am thinking that I need to create a table with referred line items, then as an invoice status is changed from estimate to invoice, then it will set variables for the data needed, then set fields in the proper place in the line item tables.  Then write a calculation that just adds the points from the new record into the points field.  Once a discount has been applied, then delete points from the points field.

 

What is the most efficient way to do this?

 

Screen Shot 2018-02-21 at 7.34.38 PM.png

Create an account or sign in to comment

Important Information

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

Account

Navigation

Search

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.