Help in designing my data in Google Sheet

Ask for Help
6

  1. I don’t have any good advice regarding notifications. There are several posts in for forum regarding different types of notifications, whether it’s emails, text, whatsapp, etc. There are also several methods for implementation, like scripting, third party integration like Zapier, etc. Do a search to find out some more info on that.
    As far as structure, maybe you could use the Bill/Payer sheet or create another sheet that is similar and contains the biller, payer, and specific bill details.

  2. You could maybe create a sheet that will hold all of your date choices and use formulas in the sheet to calculate the date that pertains to that value. So one column could have of value of ‘15th of this Month’ and the next column would calculate the June 15th. In the choice component you can selet 15th of this Month, but write the actual date to the sheet. You might need to establish several choice components with different billing day values and only show the respective choice component via visibility depending on which bill title was selected. That or you would be better on making the Bill title selection on a detail view screen, let it write to a user specific column in the sheet, then build a relation to the choice sheet where you would need to also add a bill title column. Then you can use the relation for a second choice component to show the date choices that relate to that bill title. Once both choices are selected, then display a form button to continue issuing the rest of the bill with any additional details you need. Look at Dynamic List Filter and Booking in https://concepts.glideapp.io/ to get a better idea of what I’m talking about.

  3. The link I was referring to was if you ever need to remove a payer from a bill title. A form can create the link, but unless you are viewing it somewhere in your app, there is no way to delete that association unless you do it manually within the sheet.

  4. I was only saying to have the bill id and the payer id in separate columns so you can create relations from the bill sheet to the bill/payer sheet and the payer sheet to the bill/payer sheet. What you do beyond that is up to you.

These are all pretty broad questions, so without knowing specific details about your app, how it looks, or how it’s supposed to function, it’s hard to give specific answers. Hopefully you can make sense of what I said above.

Best way to add attach multiple entries to a single title