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

Question

Question

Forms Table Formula Question

Forms
Updated May 16, 2024
asked on May 6, 2024

I have a table with 1 to 4 values that need to be pulled forward to another single line table field.
 

student_tbl_2.Campus_1


budget_code table

=student_tbl_2.Campus_1 pulls in the data but wondering if there is a way to show the data as 043 005 with no commas.

I tried the INDEX function but my formula only returned a specific row value.


Any thoughts would be appreciated!

Thanks!

Pete

0 0

Answer

SELECTED ANSWER
replied on May 7, 2024 • Show version history

You could try this

=SUBSTITUTE(TEXT(student_tbl_2.Campus_1),","," ")

This would replace the Formula in you Budget-code table Campus field. The Student_tbl.Campus_1 would be the formula you are using to pull the table fields together

0 0

Replies

replied on May 16, 2024

I have another scenario where values from student_tbl_2 need to populate another table.   

For example, student_tbl_2.First_Nam_2 and student_tbl_2.Last_Nam_2 (Joe Dirt) needs to populate
invoice.invoice_number field.  The same with John Dirt in row 2.

I tried =CONCATENATE(student_tbl_2.First_Nam_2, student_tbl_2.Last_Nam_2) but it is putting the same value in all 4 rows.

student_tbl_2

invoice.invoice_number

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...