Can you write a logical if statement based on a data base. So if the information in the database exist it populates and fills out the fields as it does now using look up. If it returns N/A can the field types for each field in that record then be single line text for a manual input. Either by the person in the form filling it out or me inside the table.
IF statements with field types
If I understand you, you could:
- Create a Lookup to get the original linked data
- Create a SingleText field to enter the data manually if you want.
- Create a Formula field which will be the final field where you can see the result:
IF(Manual,Manual,IF(Original, Original, 'Enter something!')))
If I understand you, you could:
- Create a Lookup to get the original linked data
- Create a SingleText field to enter the data manually if you want.
- Create a Formula field which will be the final field where you can see the result:
IF(Manual,Manual,IF(Original, Original, 'Enter something!')))
Thank you. As of now i have it done with a look up to link the data. But can i do it with a formula in the field to automatically link it like look up and if the look up returns empty to switch the field to manully enter the information ?
Thank you. As of now i have it done with a look up to link the data. But can i do it with a formula in the field to automatically link it like look up and if the look up returns empty to switch the field to manully enter the information ?
No, you can’t add a formula in a Lookup, nor add a lookup in a Formula. But you could hide the Lookup field that you have.
You can’t switch the type of a field in just one record, you do for all of them (this is not Excel). You can add the third field I told.
Screenshots:
Cleaner:
Formula:
IF({Optional}, {Optional}, IF(Lookup, Lookup, "Enter something!"))
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.