Hello All,

We are using the Invoice starter solution as our database for entering our PO's in the Payment info Popover, I want to modified to suit our needs.  I want to put the "All items received" and "Forwarded to Accounting" in the radio Button selection. 

What I want is, If I select "Forwarded to Accounting" I don't want to see the word "Paid", I want to see only "Forwarded to Accounting" and the date or "All items received" and the date.

Please see the attached file that I'm working for easy reference.

Thank you in advance to any help that you can extend.

 

Invoices.fmp12

Hi Karen

The file you have uploaded is broken. I just get a message that the table cannot be found when I open it. Can you check it and re-upload please?

 

Thanks for the reply Rwoods,

Sorry for the broken table. Please see attached file.

 

Invoices.fmp12

Edited October 25, 20169 yr by karenjoy

Still a non-functional file but at least it opens.

Your relationship doesn't work, you seem to have deleted the Invoice ID field.

The original Invoices table had 33 fields; your has 19.

Hi Bruce,

Sorry for that, I thought I don't need those fields that's why I deleted some fields and tables  to make it easier to somebody to help me.

Please see the original Invoice starter solution file that I'm working.

Thank you.

Invoices.fmp12

Edited October 25, 20169 yr by karenjoy

Quote

I want to see only "Forwarded to Accounting" and the date or "All items received" and the date.

What date are you referring to? Do you mean the current date?

Case    ( 
IsEmpty ( Method ) ; "Set Payment Status" ; 
Method = "Forwarded to Accounting" ; Method & ¶ & Get( CurrentDate) ;
Method = "All items received" ; Method & ¶ & Get( CurrentDate);

$$PLATFORM = "Desktop" ; TextStyleAdd ( Status & "    " & Date Payment ; Bold )  & ¶ & TextSize ( Method ; 12 ) ;

Status & "    " & Date Payment & ¶ & TextSize ( "    " & Method ; 16 )
    )

Hi Bruce,

 

Thank you. Yes its the current date. I tried to put your formula and it works perfect. 

Hope Im not asking too much favor, but pardon the newbie. I have again another issue. I want also to change the Word "Paid" into "All Items Received" or "Forwarded to Accounting" in the field "Info".

Thank you for the Help and most specially your patient.

Best Regards,

KJ

No, I'm not willing to do that and I don't think that would be a good idea.

That is a trivial mod and the sort of thing you should be able to handle yourself.

http://www.filemaker.com/learning/