I’m trying to create an invoice table, and my problem here is that i can only add 1 product for every 1 invoice. Any suggestions?
Sounds a bir vague. Can you clarify more? Table schema, column structure, how data is related?? 1-2 screenshots could be supportive.
Guide on How To Create a Community Post Tips & Tricks ?
Dear valuable members and users, For a long time I’m seeing a lot of multiple and concurrent posts, posts like novels seeming to aim the Pulitzer Price, exactly the same questions by the same user but paraphrased/re-phrased etc. Being a dedicated community member and an AppSheet developer who is reading around 2.5K posts per day, I urged myself to tip on some good advice and best practice BEFORE posting something in the community: #1 - APPSHEET DOCUMENTATION AppSheet has a very good help do…
2 Likes
https://imgur.com/a/T7G1xCO (table product)
https://imgur.com/a/HZLD7n1 (table invoice)
here are 2 screenshots of my column structures!
Why do you need 2 ref columns in Invoice table? Only 1 reverse reference (where isPartOf set to ON) will be enough where you can assign multiple products to an invoice item.
2 Likes
Thank you very much! I didn’t understand the logic of how it works, I just assumed that I needed the 2 columns, cause I wanted to show both columns in my invoice! I’ll try the solution!
1 Like